Ewan,

The default instance of SQL Server is always referred to as the server name, not server\service (localhost\mssqlserver). You can also refer to it by network name. Only named instances are...

I would look at 2 things very quickly. Try to see if there is a AUTOGROW going on in the current activity window. Also, look to see if there are...

This looks like your .NET application is not correctly creating its connection to SQL server. The MOST you would see would be an authentication error if it even got to...

If the PUBLIC role has been granted, then all users will be able to update. To fix this, you would need to Revoke Update to Public. But BE CAREFUL -...

If everyone / everywhere is loosing connection could it be an application issue? Could the app be doing some backup / default / ??? process which forces the users off?

Could...

It would help all of us if you posted what the actual problem is .....

I have posted this question in several places and have yet to solve my problem.

The...

Right on. Just remember - no local only drives ....

The number of tempdb's is dependant on the number of virtual instances. From your description, there are 2 virtual instances (2 active, one passive), therefore you should have 2 tempdb's.

Thanks for the quick responses. It wasn't what I wanted to hear, but it was what I expected to hear.

I can't really tell if you want to put the count in the query or the report. The description that you provided is for a function in reporting services. If...

You need to run the following select:

select * from sysmessages where error > 50000

This will give you all of the custom error essages that need to be created in your...

Why don't you just set identity_insert on, insert the records, set identity_insert off, and then do a DBCC check_identity to set the next identity to...

Umm ... Matt, I think that you are using the terms deterministic / non-deterministic incorrectly for the functions that Michael wrote. They are all deterministic functions - ie given...

Interesting discussion. The reality of this in MY opinion is that there is no single answer as to which form is correct. I believe that you have to normalize down...

In SQL 2K, the Agent will not start automatically upon SQL startup, however you can set it to start automatically when the OS boots up. The best way to insure...