I heard today that by Q4 of 2010 we can expect SP4 for SQL Server 2005, so there is work being done.

Extended Support requires a contract with MS and costs...

Poster: I downloaded a script and it doesn't work. I made a change and have this error "Must declare variable @SomeRandomVar"

Me: It's a syntax error. You must have typo'd a...

Those are still syntax errors. They say that the variable hasn't been declared. Somewhere either the declaration is wrong or the use of the variable has the name typed incorrectly.

Those are syntax errors. You have mistyped something.

Hmm, this thread like cat litter....maybe I can get an analogy there.

Actually this thread provides me with alternating periods of confusion, information, and entertainment.

This will overwrite the backup every day. I suggest you look at our scripts section and get a script that will change the name of the file everyday used for...

copy only backup?

The mirror log files should not be growing. Are they still growing?

I'm a part owner of SQL Share (www.sqlshare.com), and we have had good reviews. You can contract for onsite, or attend a class.

In addition, make an attempt to join the tables together in a query.

We are happy to help, but we should not be doing all the work for you.

Thanks for the update. Everything in the database moves with the backup, though your users might not be linked back to logins.

Use the WITH INIT in the backup command, or don't check "append" in a maintenance plan. You typically then have the files named differently each day. There are lots of...

Does this not work in SQL 2005?

It's old style SQL, not ANSI, so you ought to rewrite it.

Instead of listing each table and then having a comma you would want...

Here you go: http://www.iana.org/assignments/port-numbers

Typically I use something above 50,000 to avoid conflicts.

I think I interviewed Derek one time.

Nice one!