Viewing 15 posts - 27,481 through 27,495 (of 39,769 total)
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.
August 10, 2008 at 5:04 pm
Set up a server side trace that captures activities by DBAs.
August 10, 2008 at 5:02 pm
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...
August 10, 2008 at 5:02 pm
I'd recommend select * from information_schema.routines
August 10, 2008 at 5:00 pm
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...
August 10, 2008 at 4:59 pm
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...
August 10, 2008 at 4:56 pm
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...
August 10, 2008 at 4:54 pm
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...
August 10, 2008 at 4:49 pm
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...
August 10, 2008 at 4:45 pm
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.
August 10, 2008 at 12:58 pm
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...
August 8, 2008 at 9:22 am
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...
August 8, 2008 at 9:21 am
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...
August 8, 2008 at 9:20 am
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...
August 8, 2008 at 9:16 am
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...
August 8, 2008 at 9:06 am
Viewing 15 posts - 27,481 through 27,495 (of 39,769 total)