could you be a bit more specific about your scenario?
Recently took and passed the 70-461. I used the book by Itzik Ben-Gan from MS Press. I thought it was a pretty good. Currently I'm studying for the...
Just a wild guess: the column starttime looks like a datetime data type, which is does not have a millisecond accuracy. If this is the column you're...
Personally, I'd start with placing the log and main table data on their own raid sets. For the rest, I can't say that I can completely answer your...
Does the SQL server resource have a dependency on the disk resource?
First off, it is certainly possible to run a cluster on VMWare. Your setup seems fine. How many cluster disks do you have? You should have 1 disk in...
The option to remove files in first-level subfolders is added in SP1.
A lot of questions! About the disks you are going to add for the user database files: it depends on how you configure the SAN whether it makes sense...
We've got a cluster over here running SQL2K5 SP1 with same MDAC version, so that's not it... Do you have other leads, beside the error number? Like...
You can't block based on application name. But there are some alternatives that might be acceptable. One alternative is monitoring. Here, we've had...
SQLSE.rll is part of MDAC. What version of MDAC do you have?
No, it is not stored. Plus, it is irrelevant. You need to have licenses for all servers currently running (either client access licenses or processor...
AFAIK, you can do an unlimited number of installs using the same CD. You still need the proper licenses of course, but this is a different matter. So...
Maybe a dumb question, but did you specify /PAE in the boot.ini?
I've had something similar. Contrary to DTS, in SSIS you have to define the text file, not just the table. It seems redundant to me too. But it will...
You should be able to script most tasks, but the steps you mention are not very detailed. For DTS, use the RUNDTS command. That way, you should be...
Maybe you get timeouts during the growth operation. Growing 10 % on a 200 GB database is 20 Gb, which can take a lot of time. Try changing the...
EXECUTE master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWAREMicrosoftMSSQLServerSQLServerAgent', N'ErrorLogFile' Works for SQL 2000 &...
Basically, I see 3 options: 1) Perform a restore of your last full backup. To do this, you have to make a log backup now, restore the last full...
It seems to me that the heartbeat configuration you describe, is wrong, according to KB article 258750 (Recommended private "Heartbeat" configuration...
Separate names with a comma.
