Viewing 15 posts - 76 through 90 (of 1,192 total)
Eirikur Eiriksson (9/3/2016)
😎
Few quick thoughts:
There is no "one size fits all", it all depends on the subject.
As a general rule a table...
September 6, 2016 at 10:43 am
SQLRNNR (8/10/2016)
Brandie Tarvin (8/10/2016)
Sean Lange (8/10/2016)
Brandie Tarvin (8/10/2016)
SQLRNNR (8/9/2016)
Brandie Tarvin (8/9/2016)
I am experiencing that sinking feeling one gets when one realizes an instance of SQL was installed without a sysadmin...
August 11, 2016 at 10:32 am
What have you tried so far?
Hopefully send-mailmessage: https://technet.microsoft.com/en-us/library/hh849925.aspx
July 15, 2016 at 9:05 am
Worked with triggers $true on a 2008 & 2012 instance too.
Maybe check PS & SMO versions?
I don't have any triggers on views though, will give that a test. edit: yep,...
June 3, 2016 at 12:01 pm
Hi Lowell, just tried your script on a 2014 instance with both $ScriptOptions.Triggers = $true & $ScriptOptions.Triggers = $false; both worked as expected.
The trigger scripts are included in the create...
June 3, 2016 at 11:51 am
jasona.work (5/25/2016)
Eirikur Eiriksson (5/25/2016)
Brandie Tarvin (5/25/2016)
Brandie Tarvin (5/25/2016)
<singing>
All the lonely servers. Where do they all come from? All the lonely servers... Where doooo they allllllllllllllllll come from?
Sigh. Wish wish wish...
May 25, 2016 at 10:48 am
Gary Varga (4/28/2016)
Is it wrong to admit that when I saw Disclosure in the cinema I stood up and yelled "Backups, you idiot!!!" in...
April 28, 2016 at 7:46 am
Don't think I can get up there this year... enjoy guys.
April 13, 2016 at 5:15 am
Grant Fritchey (3/3/2016)
It's possible that it chose a Nested Loops ... Just guessing.
That'd be my guess too.
March 4, 2016 at 10:40 am
Steve Jones - SSC Editor (3/2/2016)
Find all backup files for a dbdelete old backup files (delete .baks older than the last 2)
copy backup files to new folder, based on criteria.
Script...
March 3, 2016 at 11:23 am
Jeff Moden (3/2/2016)
Steve Jones - SSC Editor (3/2/2016)
delete old backup files (delete .baks older than the last 2)
copy backup files to new folder, based...
March 3, 2016 at 11:03 am
BWFC (1/15/2016)
I got one of Andy's right!!!!!
Same reaction I had 😀
January 15, 2016 at 7:34 am
Reminds me of the trouble Google got into a few years back when their street view cars were caught snooping WIFI details - wasn't that blamed on a few rogue...
January 11, 2016 at 6:16 am
Alan.B (12/14/2015)
-- THIS:
SELECT t. Col1, t.col2
FROM #t1 t
-- IS THE SAME AS THIS:
SELECT t.[ ] AS Col1, t.col2
FROM #t1 t
No it isn't. 1st one returns contents of columns...
December 14, 2015 at 12:48 pm
It's usually associated with the double-hop authentication problem, what are you running to get the error?
You'll likely find many other posts on SSC dealing with this issue.
December 14, 2015 at 12:38 pm
Viewing 15 posts - 76 through 90 (of 1,192 total)