Okay, don't know how many ways I can say it. It looks like you need to add the -S parameter to your BCP command line. Without it BCP...

YSLGuru (9/19/2012)

---

Thanks for the suggestion Jeff but I'm using the same account on the new server that I was on the old and both servers on on the same domain....

Like this:

declare @idxname sysname;

set @idxname = 'idx_DatePosted';

I am finding that I am writing more code using SQL Server 2008 syntax and forget to change it for SQL Server 2005.

JC-3113 (9/19/2012)

---

Hi Lynn

receiving this error executing the code:

HResult 0x8B, Level 15, State 1

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 2, Server NSAB-SS80-SQL-N, Line 5

Must...

Why?

pandeharsh (10/9/2009)

---

Hi,

Thanks.

Actually,I hv a best practices of Sql server document,where it is mention

like whether to use cursor or not etc and many such thing.

I was expecting equivalent of this document...

You are going to have be more explicit in your request. I have no idea in what context you are asking about compression.

I'm curious why they require them to be sequential, and is that for each customer or just in general? Mr. Celko didn't really elaborate on that particular area.

From what you have posted, I have no idea. Please take the time to read the first article I reference below in my signature block regarding asking for help....

If you start with a million it is a...

Duplicate post. Please post all further responses here.

Please, don't make duplicate posts, it just fragments your answers to your questions. Most people that help here either subcribe to...

Actually, trying to connect to a named instance. Need to specify that in the command line. The reason it worked on the old server is probably two-fold. ...

CELKO (9/18/2012)

---

No, you do not. A table has a key and you have none. What...

#1CoolGuy (10/26/2007)

---

Thanks Vidhya but, If I am starting the job with sp_start_job I don't see how he "on error" in the SSIS package will help me.

I figure I can...

Bumping thread due to editting issues.