Good idea. Search is one of our week points , but I'll pass along the note to the others. Maybe someone will find a little time.

Steve Jones

sjones@sqlservercentral.com

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

The...

Thanks for the replys. I'll add them to my list.

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

There was an ADO bug that truncated text columns if they were not the last columns in the result set. I don't think that's the case here though.

One other ?,...

might need to "reseed" the desitnation table when you are done as well.

dbcc checkident

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

We have a general IDS (From NA) that monitors all servers, but not specifically for 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

Not that I know of. I wish there was as a default.

What I've done in the past is search for new objects each day and get them corrected ASAP.

Steve...

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