Yes, however the snapshot is a point in time. It does not capture updates as the mirror changes.

You might need to periodically create a new snapshot to capture changes.

Set up a server side trace that captures activities by DBAs.

There shouldn't be any effect to SQL Server. It's a piece of software running on Windows and it's certified for both versions.

A backup should prevent issues.

Is the server name or...

I'd recommend select * from information_schema.routines

As Carl mentioned, each hot fix includes the fixes of all items before it (all previous hot fixes). This is because the latest build is used to add the new...

Gail has some good advice there.

The practice comes from add/edit/delete of each object, so maybe you want to make a list of the combinations (new user, schema, login, etc.) and...

There is no Windows 2007. There is a Windows 2008, and there will be exams for that.

However, this site is primarily for SQL Server. If you have Windows questions, you...

A CTE also doesn't permanently exist. It's only in the batch code itself. A view exists as a separate object and can be called by anyone. Granted, a stored procedure/UDF...

Which updates exactly did you install and which did you not install?

My Windows edition is on one DVD, so I'm not sure what's missing. Was there any reason give...

I guess I'd disagree with that. Under his leadership the BI group became quite a force and the platform grew by leaps and bounds.

A DBF file is essentially a table. I assume these are from DBase/FoxPro.

You import each one separately. You could write a loop, but how many tables are there and is...

When you are in full recovery mode, you can do log backups.

I think you have to have made at least one full backup for a filegroup backup, but I'd have...

To use it, no. As mentioned, it's close to 2005, but with stuff added on. As you get into new features (PBM, resource governer, compression, etc.), there are things to...

The single quote (apostrophe) is a delimiter in SQL Server. You might need to escape it by passing 2 where there are one. so ...

Select MyID from mytable where MyCol...

Tim,

I tried with one kid at 5, didn't work well, but we tried it.

The other I asked every once in awhile from 5 until he finally got interested last year...