We have a database maintenance job that is scheduled to run everyday. It backs up all the databases on the server. Additionally, Performance...
We have a sql server 2000 job that invokes a DTS. A log file has been specified for the job. Now we are using ActiveX script(using...
We have a job that uses isql and executes a stored procedure. This SP contains a query in which there is a join between the table in one of the...
DB2 Transform task Error I have a DTS package that is invoked by a job that has 3 transform data tasks that connect to a DB2 server (using IBM DB2...
We have a stored proc which takes data from a database D1 (multiple tables) and inserts it into a temporary table variable. (DECLARE @Table TABLE(...
I am using isql to execute a stored procedure and write the output to a file. I need the output to be on a single line. however the output beyond...
I have a table Numbers: Nos 123 456 789 I need a query to display the output as : 123,456,789 How can this be done?
I would like to know what could be the possible issues if i disable all the alerts(that come in by default) in Sql server. This is important since...
Separate names with a comma.
