One thing I hate about those login messages they don't tell you what database it is trying to connect to.

Turn on a profiler trace the failed login attempt with all...

Compatiblity Charts ..

2005: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx?PHPSESSID=0324345d45ef1bf1f764044e03584cd0

2008: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

Thanks.

Have a look at ...

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/3a9324d4-e28a-40a0-b2db-f0d5855ec7b2/

and

http://support.microsoft.com/kb/933945

Thanks.

Here are the links I had gotten...

http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409

http://support.microsoft.com/?id=943345

http://technet.microsoft.com/en-us/library/cc262731.aspx

http://support.microsoft.com/kb/932744/

http://blogs.msdn.com/chrisfie/archive/2008/06/18/sharepoint-performance-tuning-references.aspx

Thanks.

Mohit.

I have moved SQL installs from one drive to another; but never binaries. I usually only relocate the data/log files if needed.

I would ask your co-worker not to do...

Found this KB article ... http://support.microsoft.com/kb/314530

I'll keep looking...

Thanks.

Check out Query Governor setting on your SQL Server.

I had a similar message when my Query Governor was turned on; it is designed to prevent long-running queries. I changed...

The NET Library information resides in following registery key:

HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib

Under there you should have folder for each protocol ..

Attached is Reg file for that you can try importing it,...

Urg sorry; that wouldn't work because the function returns a table which was not supported in SQL 2000.

You can run that query in a database that is 90 and it...

I would leave Print gives you nice log out put :).

I use that in one of my SQL 2000 job where it is detailed Store Proc doing the work; and...

Rob Symonds (3/24/2009)

---

C: RAID1 72 GB (2 x 72GB @ 15k RPM) – OS, pagefile, SQL Binaries and SQL tempdb.

D: RAID5 900GB (4 x 300GB @ 10k RPM) or RAID5...

State 12 indicates the user does not have access to the default database or the initial database in the connection string.

Ref: http://sqllearnings.blogspot.com/2008/10/error-18456-severity-14-login-failed.html

Thanks.

Thanks for article, I had found something similar at CodePlex, Link[/url].

Only thing about CodePlex version was I couldn't get it to script out only the objects I wanted. So...

Hmmm on your production box you don't have any NET libraries? But it is working? That is strange; I ran into it once but my production box was...

If your Stored Procedure is executing SQL Statements based values passed then it will generate two different execution plans. The query that is running slow your execution must not...