It depends on your business needs. If it is a secure system, it may be a reason for putting it outide the domain, but in this case you will  not...

When you are installing, select the lower radiobutton "SQL Collations" and the collation named "Dictionary order, case insensitive, for use with 1252 Character Set" On my servers with US English OS...

See instructions at:

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

How to upgrade to SQL Server 2000 Retail Version after SQL Server 2000 Evaluation Edition expires

You would want to check if you were out of space when the message was posted. Check the system log, if the drive did not have space then there would...

Registry Entry:

HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\80\Registration

Value Name : CD_Key

If you don't have it currently installed, then check the registry anyway, it may still be there or call Microsoft or your vendor telling...

Debbie,

I would say it is something like that. I did not run this code, this is just a suggestion. please check for syntax errors. Also '''' means four single quotes...

I agree with others that this is a nice list of the new features but not Best Practices.

I would not advise to reset Compatibility Level because your current version of...

Niall,

I am going to implement the custom log shipping and I am planning to use one backup per file at a time. I am planning to have logs being generated...

Greg,

Stopping the server by using Shutdown button on the screen is not a Hard Shutdown which is pressing a button on the hardware. You can see an orderly shut down...

See my reply to your question on SQL Server 2005 forum

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=309730

Stored Procedures and Views are cached in memory with their execution plans. After you Update Statistics the SPs should be recommpiled and views are accessed more slower the first time...

Why you could not just restore the database under a different name and if the developer needs empty tables in the new database just truncate all tables?

I would use Client Network Utility because you have to specify the port as well probably. Also check if the port is open to the instance port between servers. You...

Public role has Select permission on these views. Every user is a member of Public. If you don't want these 2 people see info in these views and you don't...

satz, I can say the same about myself: near the ocean in the northeast (do we live in the same town? 🙂 ). I walk in the morning, mostly. This Saturday...