With 2008 you do it with "facets". Right click on the server instance in the SSMC and select facets......

who is the database owner? That login was evidently mapped as dbo.

Hmmmm. At this location I am the only DBA, but also am a .NET developer about 1/3 of the time as well.

We have about 20 front line SQL servers, 3...

These situations are similar to what you would encounter when multiple users attempt update to the same row on the same table on the same server except you have the...

Okay, I understand your question now. It appears that the implicit conversion from (n)varchar() to uniqueidentifier involves only the first 32 valid hexadecimal characters and SQL server ignores the rest.

That...

you'll need to create a new table and insert the date from the old one.

I'm a bit confused by your sample TSQL code.

The local variable @ID that you are initializing with what appears to be a comma separated string of UIDs would never be...

If I understand what you are saying, you want a list of ReportIds from all 100 tables that have a matching reportID row in the finalTable. If that is the...

How about this:

update TBL set kPageName = '---'

from yourTable TBL

join (select (min(kPriority) as pri, kPageId from yourTable group by kPageID) LP

ON TBL.kPageID = LP.kPageID and TBL.kPriority > LP.pri

Read this: http://msdn.microsoft.com/en-us/library/ms190919.aspx

regarding ramification of using -c switch

What I am implying is that a different codepage is in effect when it is run from the command line (shell) versus...

try specifying a different value for the -C (codepage) option.

How to interpret that also depends upon whether you are running in a 32 bit Vs. a 64 bit OS.

I don't have an answer except to suggest that you use bcp utility instead. It provides for saving a detailed error message regarding the data issue that is failing.

We use...

how does the hardware of this new server compare to the old one? How much memory? How many drives? Is tempdb on its own drive array and have you set...

what does it say in the event log?