Viewing 15 posts - 36,151 through 36,165 (of 39,804 total)
Do you mean the first post that you have not read?
Have you tried the "Active Topics" link?
Steve Jones
July 24, 2003 at 12:34 pm
July 23, 2003 at 9:38 am
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
Viewing 15 posts - 36,151 through 36,165 (of 39,804 total)