What collation are you using ? If it is case sensitive it may appear that XXX\LOGIN could actually be xxx\Login or XXX\Login.

In actuality you are not creating a unicode text file. By not specifying th -c (character mode) parameter your bcp out file is in the default 'native' format.

There is never time to do it right but always time to do it again.

It's time to go back to the basics - edit your parameters (API arguments) for:

• the number...

5 years ago: Fex-time. 45-50 hours a week, 5-10 hours is remote support. Telecommuting 1 day a week. Round trip travel time to/from the office 2 hours 30 minutes per...

In my organization there is a team of "System Engineers" each with a specialty - AD, Exchange, PC Architecture, SMS/MOM and mine SQL. We all possess 3 logins: domain user,...

RGR, we have a few specific vendor supplied applications that require the entrie server, not just the database, to use Latin_1_General_Bin. These SQL Servers interface to AS400's and related applications...

Sybase and SQL Server were once the same beast - I mean absolutely identical - just different labels (Sybase 4.9.2 and SQL v4.21). At present you could call them different...

You may want to check the Wins setting on your server NIC card(s).

A few questions first ...

• Is the SQL Server Service using the LocalSystem account or a domain account ?
• Is the SQL Agent Service using the LocalSystem account or a domain account...

Jason - there is no such thing as a 'typical' day froa DBA. You will probably find as many definitions for a 'typical' day as there are opinions amongst the...

The biggest issue with autogrowth is that it will usualy occur at the most inopportune moment. I'll not touch the growth parameters since that coiuld be another entire thread. What helps...

Since you are using SQL Server authentication the issue of different domains should not matter. I'd first try to ping the SQL Server. If that works then try a telnet...

Try looking at a function whose name begins with: USP_GET_ENCODED_DATA

If you can replace it's functionality, and things then woork then it's the culprit. But for the actual cause and fix...

Buy new and use the old machine as is for dev/test or even take it home for the kids.

Caveat Emptor <period>