my bcp OUt exampel shows the delimiter between dbl quotes, and not the sole char after the -t.

try that...

also check your row terminator; if it's not CrLf, you might need...

interesting...

it looks to me that SQL 2008 has the REPLACE function overloaded now...pass it CHAR...it returns CHAR. pass it VARCHAR, it returns VARCHAR.

maybe SQL 2005 didn't have the same overloaded...

Welcome aboard Jimmy;

A few questions:

Instance1 and Instance2 are seperate servers, right, and not databases?

so the commands are really referencing ServerInstance1.LiveDatabase.dbo.Table1 and you want to migrate some data to OtherServerInstance.TestDatabase.dbo.Table1?

Or are...

Windows Task Scheduler.

you can set a job to repeat on a schedule, but more importantly, you can decide what user context to run the command as much easier.

Marcus has hit the core issue, i think: it's all about permissions, and the service running the SLq Service account doesn't have what is required.

the fastest, easiest fix is...

don't run...

unless your procedure is specifically updating a datetime column, or you have a ROWVERSION datatype as one of the columns in the table, it is not possible to determine the...

i think you will also need to explicitly cast to a decimal; where are you getting the verison info from? how are you building the variable for the server version?

...

an new instance is a complete installation, so you would have to run or re-run the MSI and explicitly give the name of the new instance...\SQL2005 or \SQLEXPRESS are commone...

Oracle SQL Developer is a free download straight from the oracle web site.....but i think they require you to register:

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

i think the Op is doing two or more things ...not real sure now after rereading...

IF EXISTS(...)

BEGIN

PRINT 'do something conditionally'

PRINT...

lallu_jaya (8/5/2011)

---

The if exists statement that I included performed the check but it also updated the column group values that were not equal to 2 (<>2) made 2.

It updated the...

lallu_jaya (8/5/2011)

---

I want to include this check within the stored procedure. I want sql to automatically check when stored proc is called by JOB...Can I do that?? or should I...

soemthing like this?

If EXISTS(select [group] from dbo.group_data WHERE [group]<> 2)

BEGIN

EXEC MyProcedure @param

--email that the proc was run?

END

AFAIK, the C2 trace should already have the STOP on error flag in place,

at least when i read this:

http://technet.microsoft.com/en-us/library/cc293615.aspx

it's a requirement of that type of audt.

double check with the SQL...

it has to do with one of the parameters in the trace creation:

http://msdn.microsoft.com/en-us/library/ms190362.aspx

if you have a trace like this, where @options = 2:

you need @options = 6 to enable stop...