Viewing 15 posts - 6,076 through 6,090 (of 6,105 total)
Andy makes a good point. If you do copy it to another server, the sysadmin role by default is going to get dbo rights. I didn't think about...
July 17, 2001 at 10:35 am
Wow. Andy's suggestion is probably the best one. How often is the data being added to or updated? Also, is there a possibility of keeping some tables...
July 16, 2001 at 8:53 pm
The first error is usually gotten around with "admin" and "" for username and password respectively when it shows up.
As for the second, you said it's been running for a...
July 16, 2001 at 8:49 pm
Very interesting, indeed. Please keep us informed. I for one would really be interested because my company will eventually be going to Exchange 2000 and it'd be good...
July 16, 2001 at 8:44 pm
I'm not real familiar with MSDE with respect to applications development and installation. So if I sound like a complete buffoon, please forgive me after you slap me around...
July 16, 2001 at 8:42 pm
Ok, you're speaking with respect to the maintenance plan. I believe that works through xp_sendmail, too, since it's coming from SQLMAINT.EXE. Steve asked this once before. Are...
July 15, 2001 at 10:03 pm
I'm afraid with the information you've provided, no one can give a valid answer. Can you give a more complete synopsis of what you're trying to do?
K. Brian Kelley
July 13, 2001 at 11:25 pm
Sacrificial Summer Intern. Appease the admin's wrath. 😉
But seriously, ok, we've ascertained xp_sendmail doesn't work like it should. However, an e-mail notification from SQL Agent does. When...
July 13, 2001 at 11:17 pm
This may not be the most efficient way, but it works:
SELECT DISTINCT a.f1, b.detail, c.f2, c.detail
FROM a JOIN b ON a.f1 = b.[id]
JOIN (SELECT a.f2, b.detail
FROM a JOIN...
July 13, 2001 at 10:44 am
Swift kick to the server (if reachable) with a steel-toed boot? Hmmm, I'll keep digging.
K. Brian Kelley
July 12, 2001 at 11:41 pm
Exchange Server 2000 say you? Here's a Q article on that there error:
http://support.microsoft.com/support/kb/articles/Q293/4/22.ASP
K. Brian Kelley
July 12, 2001 at 9:41 pm
I think Steve and Andy have indicated the right paths for what you're trying to do, but to clarify, are you looking to
a) Prevent someone from seeing the information...
July 12, 2001 at 9:17 pm
Prior to Windows 2000:
CDO Library, CDO Rendering Library - for MS Exchange Servers
CDO for NTS - for an SMTP Server (running locally)
As for Windows 2000, CDO for Windows 2000 is...
July 12, 2001 at 9:14 pm
I don't believe CDONTS supports changing of the SMTP Server. I'm looking at the object model right now to refresh my memory and I don't see anything in relation...
July 12, 2001 at 9:54 am
Where I work, we follow a naming convention to what Michael Hotek proposes. Here's the link to the article on his site:
http://www.mssqlserver.com/articles/naming_conventions_p1.asp
K. Brian Kelley
July 11, 2001 at 12:53 pm
Viewing 15 posts - 6,076 through 6,090 (of 6,105 total)