We installed SQL 2005 on a Win2k3 server that was previously running SQL 2000.

The issue we encountered was that local SQL login accounts were not migrated properly ... while all...

Hello.

There was a bit of redundancy in this article. Therefore, please forgive me if I overlooked your mention of a very useful byproduct of using TRUNCATE.

If your table has an...

Unfortunately, that list (and I'm certain others like it) is unpublished publicly and only shared amongst M$ Support Engineers.

By the way, the engineers were in New Delhi, India. Very...

As a follow-up, Microsoft engineers were kind enough to share this additional feedback with me:

The following Network Interface Cards are known to exhibit such issues on occasion:

- Broadcom Gigabit Adapter

-...

Hello,

Check out my post in this same forum:

http://www.sqlservercentral.com/Forums/Topic401383-6-1.aspx

Please leave some feedback, whether or not it works for your situation.

As I originally suspected, the issue is due to latency between the central office (servers) and remote office (clients). In short, Kerberos is unable to send and/or receive authentication...

Hello. Thanks for the feedback.

The SPN listed in the error message is correct, as is the results of ping-ing the SQL server by NetBIOS name OR IP with -a specified...

Please post the employer name or, at least, general locale. We're all dying to know, even if I am alone in admitting it.

Use this FREE tool:

IDERA.COM has free SQL tools as well as more robust tools for a fee.

What is SQLpermissions?

Idera’s SQLpermissions is a freeware tool for copying or moving logins...

I am experiencing the same issue with Database Name, as well as other relevant columns. We are an Active Directory shop and I want to trace usage on application and...