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, 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, 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...
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...
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...
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...
I am trying to copy a file from 1 machine to another using the T-SQL's Shell command : This is what I'm doing : EXEC Master..xp_cmdshell 'copy...
I have a SQL Server 2K machine as the central DB server. There are around 120 occassionally connected laptops on the internet/intranet having MSDE...
Going by the previous posts, I have changed my SQL Server LogOn account to ./Administrator (instead of LocalAccount) through ControlPanel > Services...
Hi, I want to define a global variable in DTS which could hold approx 1000 characters. I thought of defining as varchar but that is not one of the...
I am trying to programmatically restore database on a machine. However the operation is timing out. Database is approx. 50 MB. How can I specify the...
What is the exact syntax for adding a foreign key constraint on an existing column, without dropping the column ?
how do I restart msde (sql server) server programmatically ?
I have a DTS job which loads the data into the SQL Server. First step is to log "that job has started.." and on success or failure update the status...
Separate names with a comma.
