Please...

As stated this shouldn't be run from Query Analyzer. It should be run from a command prompt on the machine's console which has the file on it. If...

The syntax should be:

There's no error message listed. What's the error?

You should stop all clustered services before restarting the clustered service. Why do you want to restart the cluster service?

Anything which uses SMO will only return running instances, which are not set to hidden.

If you want to find all the instances on the AD domain, hidden or not you can use the code which Aaron and I put together for my book "Securing...

Yes that is correct. When the database is restored the file will be laid down as one large block, assuming that there is nothing else on the disk and...

Have you tried using the ISNUMERIC function.

"WHERE ISNUMERIC(YourColumn) = 1"

The function isn't perfect as characters that are used for money ($,.) are counted as valid, but it'll get you most...

That's a problem with SQL Server Management Studio running out of memory. How much RAM is on the machine you are running management studio on? How much data...

System.OutofMemoryException is a .NET error message. Are you using a CLR procedure or function in your query? How are you running the query?

I need to see the execution plan of the stored procedure being run, not written to the database.

Sounds like there is a problem with the indexes on the table. Can you post the execution plan?

My blog is owned by Tech Target as it is hosted on their site. I can ask them about syndicating here as well, but as SSC is a competing...

It's a single table in the default file group. The file group has two files, each of which is on it's own LUN. The LUNs are each created...