Just tried it here using one SQL 7 server to profile another. You need to be sure when you create the trace that you change the server name on the...

We've got Compaq / HP SANs running here with both Compaq and IBM servers connected to them. Some with local storage some without.

In the last 9 months, we've had lots...

Thanks for the note. Glad you like 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

Use the varbinary or image type.

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

If you change auth from NT to SQL, you need to change this on the server as well.

This should work easily enough if you do that. NT auth shouldn't work.

Steve...

http://www.microsoft.com/traincert/mcp/mcdba/default.asp

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

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...