Yes I am using the 4 parts. However I am not using OPENQUERY statements. Like I said earlier, I can run select statements from Oracle using the 4...
Why don't you use SSIS (SQL2005, 2008) or DTS(SQL2000) instead of inserting the data this way? You could store the data into a csv file and then...
The MSDTC service, on the Server 2003 where SQL2005 runs, is started and configured. Oracle server runs on Windows 2000 server. I am not sure if I...
Is data coming from one table or more? if coming from one table then use this syntax: select year, <data> from <table> where data exists for <year>...
Hi, I am using SQL 2005 on Server 2003. I created a linked server to an Oracle DB 8.x. I can select/update/delete from all tables in Oracle using the...
Thank you. I followed the MS article for manually uninstalling SQL and it worked. I ended up uninstalling both SQL 2k and 2005 and reinstalling from...
Hi All I am having this error when i try to start Enterprise Manager, " Error 65535: General Error". This is how i got to it: I have SQL 2000 and...
Can someone please tell me which is a better statement to use, performancewise, "Select..Into" or "Insert Into..Select"? I am selecting about...
Thank you so much. All good now.
I have 7 databases, 6 of them have tables replication from 1 big database, and all on the same server. This server is the publisher and distributor....
Thanks but That did not help. I could not find answer for my problem!
It works just fine in a web browser and yes ParamUIP is not blank it gets filled in with all the value needed.
Hello. I have the below code in an ActiveX Script Tas in a DTS package. The code works fine until the code "objU1.send objComm1". When I run the...
I think writing a DTS package and using the ActiveX task to write VB script is the perfect solutions. However it is failing when I try to send the...
Thanks Madhivanan. I tried to use xp_cmdshell to run iexplore.exe and pass the web address with the parameter. Everytime I try that the script...
Can someone please tell me if it is possible to run an ASP page from T-SQL? Basically what I am dong is: I have an ASP page that expects one...
Log shipping is a better solution since it seems you need the entire database on your reporting server not some selective objects. You need to have...
Could it be that more than one update statements are called to update the same row in table "a" at the same time?
You can change the default port 1433 to another port# that only those you want to connect to your SQL know it.
Separate names with a comma.
