Viewing 15 posts - 1,351 through 1,365 (of 1,583 total)
If you have a database with Bulk/Full logging enabled you should schedule transaction log backups to run regularly, this will help keep them clean so-to-speak. If you haven't already...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2011 at 11:57 am
There's really no difference in using the GUI over TSQL other than it writes the TSQL for you. For instance, with the GUI you can click a checkbox to...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2011 at 11:49 am
I'm very familiar with Jeff, Gail, and many countless others. My comment was more of a personal joke to Sean because a few weeks back he made a comment...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 7, 2011 at 4:09 pm
Hey Sean, does Jeff send you some sort of royalty checks in the mail from time-to-time? 😉
(heh, heh)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 7, 2011 at 3:22 pm
Well Duh, Sorry Sean...I only read the first part of your post when I went off and replied. It's going to be a long week...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 7, 2011 at 2:03 pm
You could also pass in the parameter (sort column) into the actual procedure itself (similar to how the infamous sp_whom2 stired-procedure works. It uses a little dynamic SQL but...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 7, 2011 at 2:02 pm
Thanks Lowell (and everyone). I went into the msdb db and added a the development group to the mail profile and it worked!
Issue resolved.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 7, 2011 at 11:18 am
Viiki.seth, yes the service account has the proper permissions.
Patrick, the article was good and don't know how I missed that when i searched for it on this site 🙂 ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 7, 2011 at 10:07 am
My destination already is OLE DB... has anyone found a solution?
I am running this under SQL 2006 Standard, SP2, on a Windows 2008 Server Enterprise - 64-bit
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 2, 2011 at 3:56 pm
Cannot open backup device \\server1\d$\backup\TLshipping\testdb.bak.Operating system Error 5(access denied).
I've had issues before using the admin shares like that across servers. Get rid of it. Create an actual...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 21, 2011 at 9:30 am
Actually, from one of the links on the page I offered there's a link to an example of exactly what you need to do to implement it:
It's pretty straight-forward
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 20, 2011 at 3:50 pm
Without using a 3rd party tool or triggers I don't think you have much left to work with. In futhering what Sean has said: http://msdn.microsoft.com/en-us/library/bb522489.aspx
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 20, 2011 at 3:32 pm
Good god yes, as SQL RNNRPointed out, keep track of any and all emails to your boss about the process! When things come up that will take you away...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 17, 2011 at 6:11 pm
Transactional Replication should run all the time...as it is by default, but if you do schedule it somehow there shouldn't be an issue with it running into one another. ...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 17, 2011 at 3:35 pm
Wait several days before you send anything...
Re-evalute the things that make you say:
I am already beyond frustrated with myself in not handling this as well as I could
and put together...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
October 17, 2011 at 3:29 pm
Viewing 15 posts - 1,351 through 1,365 (of 1,583 total)