No idea. All my 2008 stuff is in a VM. Somewhat afraid to drop it on a machine I need 🙂

If anything, I'd guess that there's some issue with the...

There are no free log readers for 2005. It's a lot of investment for someone to decode the log and write the software.

There's no good way to do this in...

So we shouldn't get patches? I speculated that perhaps there weren't any serious bugs, but there are weekly issues being reporting and cumulative, only slightly tested, updates.

I think we should...

Don't select from 127.0.0.1 ( I think localhost resolves to this). The listeners for other instances might not come up. Try the Windows name.

You can't take a backup over the Internet. SQL Server is very intolerant of delays in network traffic and this wouldn't work.

You can back up to disk and then copy...

That does, and as along as a person can be in only one OU, you're ok. Not sure how much you want to do with this, meaning do you want...

That's strange. Do you have SS2k8 on a server? I wonder if it's messed up the counters.

Or it could be an issue with Vista.

Andrew,

If you can describe what you want to achieve, not necessarily what you think you ought to do, we can perhaps give you better advice.

As a start, in this database,...

I'm not sure I'd use profiler for capacity planning. I think System Monitor from Windows would be better.

http://www.mssqltips.com/tip.asp?tip=1267

http://msdn2.microsoft.com/en-us/library/ms978394.aspx

If you have the log (or log backups), you can download Log Rescue from Red Gate and use that.

This is an incredibly general question and almost sounds like homework or an exam question. Please do some research and then ask specific questions about things you don't understand.

The survey had some Amazon GCs as prizes and was put out since we're thinking of adding another component to the QOD mix. Not sure yet if it will be...

It is possible, however you might be better off posting this in a DreamWeaver forum.

If SQL Server is installed, you can use Management Studio in the SQL Server group to...

The colored lines are a display feature. Not something you return in T-SQL.

Security is fairly granular in SQL Server 2005. You can not grant rights or deny rights for many operations.

If you are more specific in your questions, we can help. There...