1. To clarify some points, the restore is from the local server drive. The drive is SAN storage connected via a 2GB fiber optic connection.

2. I had...

GSquared,

I happen to agree that this isn't practical. However, I am still tasked with seeing if it can be done.

Just to clarify the need. This is...

If the database already exists, you will need to first detach the current version before attaching the new files. In order to detach it, all current connections need to...

Steve

I have used that method for years with much success. Lately I have been trying to implement the same functionality using service broker event processing. However, I've not...

You got it right. Just copy the files to the server and than attach the database using sp_attach_db:

EXEC sp_attach_db @dbname = <databasename>,

@filename1 = <full...

So far, the consensus is just what I thought. While there may be some advantages to executing scripts for managing backups, without a specific need not addressed by Maintenance...

Jack,

I absolutely believe in the "limit access" mindset. Unfortunately, the business users in my company do not, which is why I have the dilemma. The business side of...

When using a subquery in the select statement the subquery can only return a single value. One (or more) of your subqueries is returning more than one value. ...

Normajean,

The error is a not very well documented error message. Best guess is that either an I\O bottleneck or CPU\Memory pressure caused a situation where queries were waiting to...

Number 10 reminded of a recently learned lesson. I came in one morning and one of our major applications wasn't working....users could not log in . Of course,...

Microsoft SQL Server 2000

- 8.00.760 which is the version for SP3.

And I only read that article 10 or 15 times yesterday while fighting the...

If you are interested in just SQL Server counters, you can query the sysperfinfo table.  However, you will want to do a little research as some of the values in...

A much easier task would be to use Performance Monitor Alerts.  An alert can be configured to check for any Perfmon Object ( include SQL Objects ) and execute an...

That will work with the given example.  However, it is dependent on the length of the data after ' on ' begin constant.  Should the format of your alert string...