Search results for query: *

Thanks again. I will check their posts.

I checked our SQL Server 2005 instance (standard Edition SP2) but I didn't see the the microsoft Ole db provider for IBM UDB DB2. Like you said, it might be available on the SQL server 2005 Enterprise Edition. I have installed the OLE DB provider for IBM but it doesn't seem to work for some...

Thanks RiverGuy for taking the time to answer my question. We are getting actually good response time from the IBM server. We have standard edition installed in the SQL 2000 box and it didn't have the drivers for IBM that's why I installed the IBM iseries for Windows to use the odbc connection...

Hi all, I've set up a DTS to export a table from SQL Server 2000(SP3) to an IBM AS400 box that is running a DB2 database. The DTS uses an ODBC connection (ibm iseries for windows) to connect to DB2. The problem I'm having is the DTS runs very slowly. It takes about 20 sec to process 1000...

Thank you Denny for your quick response! The Stored procs are part of a DTS package that we execute every night. The DTS has been running for years without any issues. Recently, since last week, we started getting these errors consistently and I found out that the step that fails is the one...

Hello, I get the following error when executing some stored procs in one of the client servers. [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionCheck ForData (CheckforData()) The stored procs actually reside on a different server, which I have registered in my EM. I can ping the...

Hi, It's not that it doesn't like the word "AS". Try putting single quotes around BegBalance like this 'BegBalance'. GOOD LUCK!

Thanks a lot fuzzyocelot that was exactly the mising part. I really appreciate it. jsql12

that query doesn't return anything. I already did the following: select loginame from sysprocesses where spid = xx --xx is the spid that is apparently using the dll and it didn't return anything. So for some reason it wasn't logged in the sysprocesses table. Thank you for the effort guys.

LNBruno the message is from sql server error log and it is not associated with any number. What is worrying me is that the source of this message is a spid. So I'm wondering if somebody is trying to do something he/she is not supposed to be doing. Thanks!

Hi Esquared, I know what it does. What I'm more interested in is what would cause this entry in the error log. spidXX using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_cmdshell' Thanks!

Hi all, I always see an entry in the error log like this: using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_cmdshell' Does anybody know what it is? what's the purpose? Thank you!

Thanks fuzzyocelot! but I still get the same error.

Hi all, I'm creating a DTS Package that only has a one step, which is an activeX script. It is supposed to remove any files with a .BKP extension. The script is as follows: call CleanFile("\\Server\F$\SQL_Backup\") sub CleanFile(folderspec) Dim fso Dim oFolder Dim oFile Dim f1 set fso =...

Thank you all for your help. You were extremly helpful jsql12

Thank you AndyKr and bborissov a lot! I need to do this just one time. I'll try both solutions and see how it goes. Thanks again!

Hi all, is there a query that I can use to query all the tables in sql server 2005 for a specific column called status in which there's a value like '%out of state%'? Any help is greatly appreciated. Thanks

Thanks danvlas. I appreciate your help

Hi everybody, The following query is very costly in terms of IO: SELECT distinct m.memberID, [mem number] from members m left join discounts d on m.memberID = d.[id] I'd like to avoid using distinct. So, I'm thinking of using a subquery with where exists. So is there a way of rewriting the...

Thank you all very much! especially, SQLDennis I think I found out where my problem was: I didn't enclose my OR comparison between brackets. so one of the statements should have been like this: ------------------------------------------------------------------------------- --USING THE...