Viewing 15 posts - 4,171 through 4,185 (of 7,167 total)
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
I am not convinced you want an actual IDENTITY column given your comments. Can you please provide the CREATE TABLE statement and an example of the data as you want...
May 4, 2012 at 9:55 am
Viewing 15 posts - 4,171 through 4,185 (of 7,167 total)