I'm having a problem passing a parameter value into a stored procedure that I am running on a remote (linked) server, and am receiving a DTC error...
I am currently building an SQL Server job. One of the steps of the job is to run sp_start_job to call another job that already exists on the server....
I've been having a problem while moving a DTS package from one server to another and then calling the DTS package from a job. I have a development...
I was trying to export some data using BCP to a text file. The command line prompt was running locally and the DB server is remote. The line I was...
We have a table in a database on our server with employees. When an employee is no longer active, there is a flag in the table that is changed. We...
We're having a bit of a problem here and I'm hoping some of you can help me out. Our production database (used for OLTP) is a SQL 7 machine. We...
I'm going to be creating a stored procedure which will be taking in a comma delimited string as a parameter. In short, I want to return records that...
A co-worker of mine is working on a script and is trying to trap an error. The script he has is as follows BEGIN TRANSACTION a SELECT CONVERT(int,...
Separate names with a comma.
