Adriaan, Thanks for reply.. Sorry I misunderstood earllier.. Yes it is Sql Server 2000 on Windows 2003. They are planning to upgrade to 2005 but...
Thanks for the reply, and you are right its SQL 2000, sorryy for that but actually my Trigger is not inserting data into any other table, There is...
Hi, My application needs to fire a web service and pass a record to it as soon as one particular field is updated on the databse. I serched on net...
Hi, I got answer to my question: If column (col2) is char then in Lookup in Data Transformation , you have to specify SELECT col1 FROM...
No error but it is not always giving blank results (i.e. no record) ... I tried passing parameter as - %0001 - '%0001' - '00001' but no luck with...
Hi, In DTS Lookup, I want to write a query as SELECT col1 FROM Table1 WHERE col2 like '%0001' ( this would be parameter) col2 is varchar column...
Hi, Configuration was not good (392MB RAM, P3 and 20 MB) as it was testing server.. I changed SQL Server to machine with 40 GB, 512 MB and P4.....
Hi, I have SP which is running continuosly in a loop.. (windows service program calls that SP).. And after a while, my SQL Server stops with...
Hi, I want to write a script which would display all the indexes in all the tables of database.. Kind of report in excel.. Any help would be...
OS: Windows 2000 Advance Server<br />SQL Server 2000<br /><br />The windows service <br /> - Executes Stored procedure<br /> - Waits for completion...
Hi, I have main stored procedure which is calling 6 stored procedure in sequence. Since the data fetched in main stored procedure is required in sub...
Hi, In my application, there is one master table called status which holds number and short desc as follows: SttausShort StatusId RDY...
Thanks Chappy, Very much appreciated.
Hi, I have data in table as follow... Table 1 Id A B C D E F 1 10 11 12 14 15 16 2...
Thanks all, we generally think that in order to get a value we have to use select statement but never think that update can also be used to get the...
Hi, I have a query which generally returns multiple records but I want to return top 1 record. For this purpose I am using Top 1. Now since the...
Hi, I have SQL Server 2000 and have multiple database. Say database A and Database B. There are stored procedure in A which is refering to tables of...
Hi, I have DTS which takes data from table and generates file. And for this I am using Transformation task. I want to create file only if there is...
Hi : Our scenario consists of around 150 connected laptops hitting a central SQL Server 2K. Is there a problem with all the laptops executing a...
Separate names with a comma.
