Viewing 15 posts - 4,171 through 4,185 (of 7,168 total)
PaulB-TheOneAndOnly (5/6/2012)
SQL_ME_RICH (5/4/2012)
The other consideration was their desire for speed over the accuracy of the data. Yes - you read that correctly. :crazy:
:w00t: Yes, absolutely crazy. Nothing...
May 7, 2012 at 12:31 pm
The company where I am currently will only apply Service Packs, reasoning that Hotfixes, bunches of hotfixes like CUs and QFEs are only unit tested, i.e. that Microsoft only guarantees...
May 7, 2012 at 12:10 pm
Odd...this works fine on my system:
function x($ComputerName, $GroupName)
{
Get-WmiObject `
-ComputerName $ComputerName `
...
May 7, 2012 at 11:49 am
pamozer (5/7/2012)
Msg 50000, Level 16, State 1, Procedure tr_Insert_Email, Line 71profile name is not valid
Msg 3616, Level 16, State 1, Line 1
Transaction doomed in trigger. Batch has been aborted.
Well there...
May 7, 2012 at 11:01 am
What do you get with a CATCH block like this:
BEGIN CATCH;
DECLARE @err_str VARCHAR(2048),
...
May 7, 2012 at 10:17 am
As Lowell said. Severity 16 errors do not automatically rollback your transaction (unless XACT_ABORT is ON) and are catch-able. It is possible you are running into a fatal error (Severity...
May 7, 2012 at 10:10 am
pamozer (5/7/2012)
May 7, 2012 at 9:59 am
Lowell (5/5/2012)
sp_senddb_mail Is a service broker; it's already asyncronous
+1
There is no sense in wrapping DB mail with a SB queue IMO.
If you don't want to mess with permissions at all...
May 7, 2012 at 9:23 am
george sibbald (5/6/2012)
May 6, 2012 at 2:42 pm
Good call George. I cannot think of any reason why you couldn't use Windows login though. You may need to use a proxy too, depending on what the jobs need...
May 5, 2012 at 3:12 pm
Jeff Moden (5/4/2012)
opc.three (5/3/2012)
May 4, 2012 at 10:27 pm
Perry Whittle (5/4/2012)
May 4, 2012 at 8:54 pm
Try putting a back-tick in front of the $ sign, to escape it.
May 4, 2012 at 5:16 pm
Or, you could create a new schema to place your views into and have it owned by the same entity as your table's schema. This would allow you to grant...
May 4, 2012 at 5:12 pm
Perry Whittle (5/4/2012)
n00bDBA (5/4/2012)
Just got a NAS share for SQL backups and i wanted to look at the file allocation and disk alignment for it. Doing the normal...
May 4, 2012 at 1:12 pm
Viewing 15 posts - 4,171 through 4,185 (of 7,168 total)