For God's sake, DO NOT use a NAS with SQL Server.  You are asking for nothing but trouble.  Even Microsoft does not recommend it.  I've used Network Appliance NAS and...

Just for future reference, when you install SQL Server 2000 you must choose "custom installation" to be able to choose a collation.

As Lucky has posted, you can either rebuild master,...

Andrew,

Look in Books Online under 'Backups' and 'Maintenance Plans'. 

To back up the transaction log as part of a maintenance plan open the maintenance plan and click on the transaction...

Estuardo,

There is no standard naming convention for SQL objects, however most people tend to use very simalar prefixes, and some people prefer to use suffixes.

The reason people use prefixes and...

Can you connect to SQL Server through Query Analzyer or Enterprise Manager with the same login?

http://www.sqlcourse.com is a good starting place to learn how to construct simple SQL Queries.  There is also the followup site http://www.sqlcourse2.com.

Cheers,

Angela

Hi James,

I can't really offer you an explanation as to why SQL Server is running slower, but I can tell you that I have experienced the exact same problem on...

Stefan,

You are right, SQL Server is looking for the BACKUP folder under 'c:\knowledgebase\businesstesting\MSSQL$BUSINESSTESTING\'.

As far as I know, you cannot change where SQL Server will look for this file.  I think...

I had the exact same error returned in Query Analyzer when performing some intensive data loads.

In my case, the database files reside on a SAN.  When SQL Server got to...

I use this sp that I found on this site.  I've found it very useful.

http://vyaskn.tripod.com/fn_get_sql.htm

It shows the actual code that's running.

Why don't you just backup the databases you need on Server A and restore them on Server B?  Then you don't have to do anything to the master database.

Lawrence,

I would ask you developer why he specifically requires access to msdb.  None of my developers have access to system tables or system stored procedures because they don't require it.

If...

Kevin,

You are right.  You are getting the error because you are trying to insert a string into a datetime field.

You can't do a straight convert because in your string you...

No.  You cannot run SQL Server 7.0 on Windows 2003

http://support.microsoft.com/default.aspx?scid=kb;en-us;810391

Kurt,

You may also want to try this:

This function will evaluate an input string and convert it to title-case format. It uses the delimchars parameter to determine what are the triggering...