It's hard to tell if you have single quotes, doubles, multiple singles, etc.

Build the string

select @cmd = 'bcp ' + xxx ...

and then select it out

select @cmd

in a window and...

I'd actually consider designing so you can move clients to separate databases. SQL Server scales, but to a point. There may come a time when a client doubles or triples...

I'm not sure you've reduced the workload. There might be less locking, but you are still doing a lookup.

I agree that there should be a unique index if this is...

Each one looks like a select from one table. There's no way to refine that.

Run multiple queries if the fix doesn't work. run 1 transfer with 200 tables, then another...

good luck with that. I spent years (like 5) on 6.5 and I'm not sure how well I'd do with this.

Definitely look into SSIS to make things easier and...

Make sure this is SQL Server. We do get people thinking that MySQL or Sybase are handled here.

As Dr. Andras mentioned, you cannot restore a backup to a lower version....

You can do

case

when x = 'A' or x = 'b' then x

...

It's been awhile, but I think that the service account for SQL Server needs admin, or some high level of permissions. It might be that it needs to be a...

Microsoft does not pay me a thing, nor have they ever even purchased any advertising on this site. I believe in the product and think they've done a great job...

Are you blocking Google in some way? did you include the quotes around xp_cmdshell?

I find quite a few results using Search in the upper right corner here.

Thanks, I'll pass along, but can you explain what class and what panel you mean? Is there supposed to be something between the quotes?

You must go to your blogs page. There is a Control Panel on that page once you are logged in.

It is completely separate from this site right now. We are...

I believe IA64 is Itantium processors and x64 are for other 64 bit CPUs.

As far as stability I think you go to SP2 and only apply the cumulative updates for...

It's a hard battle and I think many companies try to do the right thing, but there are always managers that will abuse things. And I do think tech/software companies...

That is supposed to be for packages stored in metadata services instead of the regular msdb location. It could be a generic error appearing because of something else with DTS....