Great topic!

About half of the company I work for works from home. I've been working from home for over 5 years now, full time.

I love it but there are definitely...

Damn you Steve! I was just about to post a rant about how I didn't agree, what a bad idea that was and what about ANSI standards.

Chris.

Thanks Lester, I ended up re-writing it so that it would insert into those tables and it worked great.

Lester,

Great idea. I need a script that does this. Has it been run/tested against SQL Server 2005? When I run this script it fails b/c the restore headeronly command returns...

Hey Mark,

I figured as much. If I were absolutely stuck I would try a few things. (The first is preferred)

You could write your own backup database job. Just put the...

Thanks, that makes a big difference over the one you posted earlier.

I do not know what caused your error to start, but what I can tell you is that this...

Mark,

Is that version correct? I can't find it listed anywhere.

Chris.

Why do you want to access it via ODBC?

This database is by default not visible through SSMS. Here's an article about how to access it: http://weblogs.sqlteam.com/mladenp/archive/2007/03/12/60132.aspx

Chris.

Hi There,

You should be able to replicate between Enterprise and Standard if you like. You should also have no problems moving the databases between editions.

Chris.

I think the disk defrag is probably a coincidence. What service pack of SQL Server are you running? I had that same problem after applying SP1 to one of my...

Hi,

Are you running a 32 or 64 bit OS/SQL Server combination? Related to your question but not answering it directly. (That was already done)

If you're using 32 bit, you...

Hi,

Which version and edition of SQL server are you using?

The online/offline option is only available in SQL Server 2005 Enterprise Edition.

Chris.

I may be missing some details on things you've tried but as I read your posts, you moved the the tempdb data file from some other drive, to another location...

What else do you have on the Y: drive? Other dbs? Can you move the Tempdb log file somewhere else?

It sounds like the Y: drive is fairly busy.

Chris.

Yep, I've used that a lot.