I have some old servers, well, not old, maybe 4-5 yrs old, that used to host SSC. A couple 2U DELLs, RAID, etc. However they're like 1.4GHz CPUs. I tried...

Sorry, forgot the http. It's fixed now.

that's the full URL of the host you could put in your browser address bar.

If you are very new to SQL Server and don't understand these, use SSMS to perform a backup or restore of a database. You can right click the database and...

AFAIK, there isn't a way to do this. You could print the query

Update TABLE set FIELD1 = 1;

print 'Update TABLE set FIELD1 = 1;'

Update TABLE set FIELD2 = 2;

print 'Update...

There isn't such a thing as "unrestricted" in computing. There are always limits. My guess is the dev team puts in the max number as a way to just have...

Just an FYI, since THE THREAD is so heavily visited. We've started our own ASK site at http://ask.sqlservercentral.com. Not my idea, and I'm not sure how we'll sync up points/rating...

You can run in simple mode, but you cannot recover to a point in time other than your full backups. If that's important, then you do need to be sure...

The only thing I might add is be sure the backups (data and log) are going to drives separate from where you data (mdf/ndf) files are. If something happens to...

Does this help:

http://msdn.microsoft.com/en-us/library/bb326385.aspx

http://msdn.microsoft.com/en-us/library/bb326385.aspx

you might want to read this: http://www.sqlservercentral.com/articles/64582/

Are you pointing to a remote drive? I'm not sure you can do that in the maint plan, or that you want to do this. If there's any network hiccup,...

I'm not sure that people think being paid average wages is being used. There are plenty of people that would like to make more money, but feel they get paid...

This sounds either like a bug, an obscure one, or someone has seriously screwed with permissions in your system.

Do you have an MSDN or TechNet subscription? I might burn a...

I've altered the question to say SQL 2005. However varchar(max) wasn't available before that version. We typically don't make up functions in the questions, only the answers 😉

I was at Arlington this summer, took my son, visited a friend. Section 59, plot 1192. It is indeed sobering.