Viewing 15 posts - 12,601 through 12,615 (of 14,953 total)
Take a look at these two articles:
http://www.sqlservercentral.com/articles/Auditing/63247/
http://www.sqlservercentral.com/articles/Auditing/63248/
And this discussion thread:
http://www.sqlservercentral.com/Forums/Topic536927-145-2.aspx
There's a lot of data about auditing and triggers in those. You should be able to come up with something...
July 25, 2008 at 10:00 am
Glad I could help.
July 25, 2008 at 9:52 am
Probably the better way to do this is to have the update proc called by the front end do the messaging. If you absolutely have to have it in...
July 25, 2008 at 9:51 am
SQL Mail isn't the same as DB Mail, if I remember correctly.
How are the jobs trying to send the e-mail? How were they set up?
July 25, 2008 at 9:44 am
Means there's something at that point in the import document that's too big for the field it's going into.
July 25, 2008 at 9:43 am
Val Byref (7/24/2008)
July 25, 2008 at 9:39 am
SQL Server. Did it with the wizard in Management Studio.
Disk mirroring wouldn't be a test of the truncate command.
July 25, 2008 at 9:31 am
After you set the value for @WeekEnd, do something like this:
if datepart(month, @WeekStart) < datepart(month, @WeekEnd)
select @WeekEnd = dateadd(day, -1 * datepart(day, @WeekEnd), @WeekEnd) + 1
That'll give you...
July 25, 2008 at 9:29 am
Model isn't really a system database. It's a template for user databases.
That's why I say that one should be fine.
MSDB, I wouldn't do a backup/restore, I'd do an insert...select...
July 25, 2008 at 9:25 am
I've tested the syntax of the command I suggested, through xp_cmdshell, and it works.
If the folder name has spaces in it, it needs to be in double-quotes.
You also need to...
July 25, 2008 at 9:15 am
Just the difference in RAM alone will often result in much slower performance on that machine.
What types of CPUs do they have? Is either one dual-core (or more)?
July 25, 2008 at 9:06 am
Without the code you've got so far, it's hard to tell you what to fix, so I'm kind of guessing here.
Can't you modify the query to exclude data after the...
July 24, 2008 at 3:46 pm
Model should be fine. I'd be careful about Master. MSDB should be fine.
Why not install Standard, copy the databases over, then do an in-place upgrade? Is that...
July 24, 2008 at 3:40 pm
The main difference is that the output parameters will only get the last value passed to them, if you have more than one row that fits the Where clause, while...
July 24, 2008 at 3:29 pm
Viewing 15 posts - 12,601 through 12,615 (of 14,953 total)