It coudl be. This is definitely an AD issue of some sort. I had this on one server and could not get rid of it, even ran the server under...

Is Client Access installed on teh SQL Server?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Do you want them split out? sp_helpdb gives you the total size of the two.

sp_helpfile

gives each for the current database. Need to run this in the context of all dbs...

This isn't the appropriate place for this. Pls post in the admin section.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

NO ONE CAN STOP SQL SERVER!!!!!!

Anyone that can stop services (usually admins) can stop the service.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

On the sql server, there is a server network utility that is in the MS SQL Server program group. Check that for the libraries that are running. Client Network Utility...

Has something changed on the server? Is the server all of a sudden taking longer?

Are you running this in QA?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Is the database in EM?

I suspect someone changed something. Be sure the server network utility and client network utility match for access. Also, are these the same box?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best...

Msdb isn't usually an issue. We remove guest here.

master is another story. there are things that are needed. you can default the users to antoher db and remove access from...

The data set may be entirely in memory for both boxes, so I'm not surprised. The boost on the server is when there are lots of people using it, not...

I think there is a resource kit utility to do this, but a quick search on Technet doesn't find it.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Personally I like working with thin clients and a web browser, but then again, that is for simple apps and requires a different mindset. Try to deliver minimal information per...

Can you tell which parts are producing the deadlock? I'd run the proc with a profile running and include the SQL Stmt adn the deadlock events and try to track...

Or the server isn't listening for sockets (check the server network utility).

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

http://www.dkranch.net

Scare me too.

The restore from a network share is the same as another restore, use the UNC path, be sure the SQLAgent has rights to read from the share.

Steve...