They (I believe) create a DMO object and call ListAvailableServers to get a collection of the servers.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_m_l_9jfo.asp

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

I agree with the above post. OLAP or we need more information to suggest something.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

1. no index used, full scan required.

2. no index used with functions

3. no index used

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

I suspect that the user executing the trigger may not have rights to the xp_sendmail procedure.

Keep in mind that generating things from triggers can result in lots of emails, which...

Most likely DTS, though custom scripts will work.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

They both use the same controls. However once things are loaded in EM, they will be quicker in Computer Management. I suspect that the MMC for computer management might pre...

Homesite did go to Macromedia.

I'll give Ultraedit a try and thanks for the notes on commenting in Edit Plus. Not as easy as a hot key, but pretty close.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

I have one Oracle server (nearly 50 SQL) that I manage,but mostly I just check backups as it's backing a 3rd party app.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

I know, I know. We've heard it and I'm sorry..

Other projects and life are really eating up time. I'll try to take a look at this next...

Mail is getting tough. The lockergnome guys get a few complaints a day when their mail isn't received. So far we've avoided being blacklisted, it really only takes one complaint.

Apologies...

Our workaround was to run the query in a DTS package and it seemed to work. Also worked fine, in SQL 7, same db structure, same linked server connection.

Haven't chased...

I've seen similar issues with this. Is this SQL 2000? Seems to be some Client Access issue, but we have not chased it down. We had a workaround, which I'll...

I've gotten a few here recently.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

Good suggestions. Documentation always helps, but I have to admit that I'm torn as to how much to add. To me, many scripts shouldn't be run by someone other than...

You'd have to be able to spawn processes and run this. You could probably do this with a batch file or issue a few commands in xp_cmdshell that were like...