Ben,

Might be worth trying "CLUSTER ... GROUP ... /OFFLINE" from the command line.

Sorry, I don't have a "test" cluster available to confirm whether this is viable.

Cheers,

- Mark

Brian,

Thank you, thank you, thank you!

I'd given up up on searches of sqlservercentral, but now that I can google it's great.

Cheers,

- Mark

I entirely agree. There is no way I'd create a clustered index on a volatile key such as LAST_ORDER_DT. This is something you just don't do with SQL 7.0/2000,...

Not a dumb question. Through straight T-SQL, SQL will only let you do a limited set of ALTERations to a table (add/delete columns, etc) that will keep the existing...

I agree with the other sentiments. Please do post again, and thanks for a controversial question. Certainly beats the hell out of some of Keith's questions, which I'd...

Stored Procedures? Oh, come on... that answer's just plain silly. Where in BOL does it state that the ability to append a number to a stored proc name...

It sounds like an alias someone's given to a derived table in a complex query. It's not a SQL keyword AFAIK.

In what context is it used?

Cheers,

- Mark

A possibility is that you have a Client Network Utility entry on the server where the Alias is "Servername\Instancename" but the Server is "Servername" (or server IP) and port either...

Someone's created a table called "c:\temp\sales.txt". It's just an object in your database with an operating-system-like name. It can be done like:

create table [c:\temp\sales.txt]

(...

quote:

---

I created a dummy DB and this userid appeared it it with rights to access it !!!!!

All I did was a create...

Cannot you use CASE?

Eg.

SELECT CASE WHEN <condition> THEN <result1> ELSE <result2> END

Cheers,

- Mark

quote:

---

I'll do that, as it's easy to add the DROP_EXISTING clause to the script it produces.

---