Viewing 15 posts - 36,121 through 36,135 (of 39,771 total)
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
July 21, 2003 at 2:17 pm
I agree with the above post. OLAP or we need more information to suggest something.
Steve Jones
July 21, 2003 at 2:14 pm
1. no index used, full scan required.
2. no index used with functions
3. no index used
Steve Jones
July 18, 2003 at 6:30 pm
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...
July 18, 2003 at 10:18 am
Most likely DTS, though custom scripts will work.
Steve Jones
July 18, 2003 at 10:10 am
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...
July 18, 2003 at 10:08 am
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
July 18, 2003 at 9:56 am
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
July 18, 2003 at 9:53 am
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...
July 17, 2003 at 12:40 pm
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...
July 17, 2003 at 11:49 am
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...
July 16, 2003 at 10:22 am
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...
July 16, 2003 at 9:44 am
July 16, 2003 at 9:40 am
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...
July 16, 2003 at 9:37 am
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...
July 15, 2003 at 3:07 pm
Viewing 15 posts - 36,121 through 36,135 (of 39,771 total)