Search results for query: *

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...

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 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!

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 =...

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

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...

When I run the following: SET NOCOUNT ON SET QUOTED_IDENTIFIER ON DECLARE @TableName VARCHAR (255) ,@SQLStr VARCHAR (255) ,@IndexName VARCHAR (255) ,@MaxLogicalFrag DECIMAL ,@MaxScanDensity DECIMAL SET @MaxLogicalFrag = 0 --0 is the best SET @MaxScanDensity = 100 --100 is...

Hi there, I'd like to know how to rollback: 1- Delete from table 2- Truncate table Your help is greatly appreciated

Hi there, I have a table that is used in several dts packages and I'd like to know if there's a query that'll return a list of dts packages that use that table. I appreciate your help jsql12