Viewing 15 posts - 1 through 15 (of 18 total)
Would converting TEXT datetype columns to Varchar(max) save me some space? I have a 40GB table that has 3 Text Columns for notes and some other data that is stuffed...
November 10, 2014 at 10:50 am
Sean Pearce (8/22/2014)Using RAISERROR with a severity level of 20 will disconnect the session immediately.IF (@@SERVERNAME='Prod')BEGINRAISERROR('Incorrect Server', 20, -1) WITH LOG;END;GO
Sean Pearce (8/22/2014)
RAISERROR('Incorrect Server', 20, -1) WITH LOG;
August 22, 2014 at 7:53 am
@jim got it. I'll work with checking the @@ServerName and maybe use the SQLCMD snippet to see if I can come up with a combination that checks before...
August 20, 2014 at 11:31 am
Jack Corbett (8/20/2014)
Another way to do it is to script requiring SQLCMD mode, then you can specify the connection in the script. You...
August 20, 2014 at 11:12 am
Jim Arko (8/20/2014)One thought is to look at @@SERVERNAME. Maybe you could raise an error or something if it doesn't match the name of the dev box?
Jim Arko (8/20/2014)
What I have in...
August 20, 2014 at 11:10 am
Great concept, will give it a shot sometime.
August 11, 2014 at 7:28 am
August 8, 2014 at 8:43 pm
Hey guys, sorry I'm a bit late on this but I had a question in regards the Online re-indexing in Enterprise. Does the ONLINE=ON completely eliminate the possibility of Table...
August 8, 2014 at 6:23 pm
Your code didn't work as is because I'm working in SSRS and I had to tweak a few things but it definitely pointed what I needed to look for....
October 22, 2012 at 1:22 pm
What is the command for BCC and CC , I tried MailCC or MailBCC and it didn't work.
October 22, 2012 at 12:03 pm
will do , appreciate the help guys.
p.s. i'm still a grasshopper 😀
August 18, 2009 at 7:57 am
got it . I will start with this and go from there .
August 17, 2009 at 9:55 am
great , will keep that in mind .. now when you say upgrade advisor that would be the version that comes with sql2008 correct ?
August 17, 2009 at 8:57 am
Jeffrey Williams (8/6/2009)
August 7, 2009 at 7:32 am
could be but I can't think of some process having the backup files locked because i was able to delete a few of them as a test .. but I'm...
August 6, 2009 at 6:15 pm