Viewing 15 posts - 36,061 through 36,075 (of 39,720 total)
Not sure if this is possible. On NT 4, there was a MAPI client already, the Exchnge client which would work, but this seemed more buggy.
Is there a reason...
July 24, 2003 at 1:08 pm
First explanation is correct and the 2nd question does not make sense.
Steve Jones
July 24, 2003 at 1:03 pm
A result code of failure was returned. I believe this is 1.
Steve Jones
July 24, 2003 at 12:58 pm
July 24, 2003 at 12:57 pm
I'd insert into a temp table that does use an identity. You can set the seed to be the "pop" value from your separate table and then update that at...
July 24, 2003 at 12:54 pm
Have you checked that the db is not in use when the job runs? If there is any user in the db, it will not restore.
Steve Jones
July 24, 2003 at 12:47 pm
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
Viewing 15 posts - 36,061 through 36,075 (of 39,720 total)