My comments were in regards to restoring the master database on 2005, but I assume the same GUI issues would occur for user databases.  I only referred to SQLQuery as...

I never had to in 2000 and the documentation for 2005 indicates the GUI should work for master, but unfortunately the GUI appears to not work. 

As an FYI, hope...

We are unable to use the GUI to restore the master database, however restoring through SQLQuery ("query analyzer") does work.  The trick is to make sure the GUI is not...

Please disregard.  I resolved the problem.  Chalk it up to lack of sleep.

Dave

I have no VB skills.  When you say "Type cscript //H:Cscript. This will make cscript the default so that to run a vbscript all you need to type is the...

I'm still confused as to why it's needed.  In BOL under " New Information - SQL Server 2000 SP3." is a chart indicating that members of db_owner can execute the "Restore"...

I forgot to mention I am not using "WITH REPLACE".  In SQL 2000 I only need to grant dbcreator if the database is being replaced.  Not sure why 2005 would...

Thats good to know.  Thanks. 

I just ran a test on a 3GHz PC with 1MB of RAM and Trend, Cisco Security Agent and a product called Altiris all disabled.  The...

SP1 appeared to take about 10 minutes for me today.  From what I've been reading from other people yesterday and today it sounds like 30 - 35 minutes is not...

It turns out our Cisco Security Agent (CSA) was blocking the application and not reporting this to the Event Viewer log.  A rule has been written for CSA to not...

I spoke with Microsoft and it turns out the documentation is out of date.  All I needed to do was run setup.exe from the Server folder.

Thanks,    Dave

Why do the number of spindles for tempdb have to be equal to or greater than the number of available spindles on the data drive?  If tempdb is on it's...

Here's the actual code.   One look and you'll know why the developer is experiencing performance problems.

September 29, 2006 at 7:49 am