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...

Thanks

@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 that I'm...

Jack Corbett (8/20/2014)

---

Jim has one idea.

Another way to do it is to script requiring SQLCMD mode, then you can specify the connection in the script. You...

Jim,

What I have in...

Great concept, will give it a shot sometime.

sql-lover (8/8/2014)

---

SQLnbe (8/8/2014)

---

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...

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...

Lowell,

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....

Hi,

What is the command for BCC and CC , I tried MailCC or MailBCC and it didn't work.

Thanks

will do , appreciate the help guys.

p.s. i'm still a grasshopper

lee

got it . I will start with this and go from there .

lee

great , will keep that in mind .. now when you say upgrade advisor that would be the version that comes with sql2008 correct ?

thanks

Jeffrey Williams (8/6/2009)

---

That error message is stating that it could not open the backup file, not the database file. That can be caused be several things, for example it...

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...