Depends on your permissions but you can do DROP db.dbo.view just as you can do SELECT * FROM db.dbo.view

No, only one table at a time can have INDENTITY_INSERT ON.

What exactly are you trying to do?

Run the trace without using the profiler. The profiler GUI slaughters performance.

Where separation in 'n' tier applications CLR functions have little use because each component is a specialised resource.

Where the SQL Server is more of a one-stop-shop then the CLR functions...

In the short term I would run a trace.

Other ways are to use the following to write to the Windows event log.

RAISERROR('Procedure name xxxxxx ran',10,1) WITH LOG,NOWAIT

You can have the...

This a question to which the answer is "it depends".

The only way of telling is by using DBCC SHOWCONTIG to see how fragmented the tables are.

If you have tables on...

I learnt to play the piano at the age of 5 and one of the first things they teach is how to hold your hands and wrists.

So far I have...

Perhaps we are going about this the wrong way.

I should like to suggest that Red-Gate make a sample application available to SSC members with the precise intention of getting SSC...

I use the RedGate products and find that they do speed things up.

There is a layout file used SQL Refactor that can be edited to give you the layout you...

I'll look into it Marc. It should be possible but there is one thing I have found with SQL2005 and system tables. Basically you can't query them directly,...

I must admit I am somewhat ambivalent to storing XML in a relational database.

If I am going to store XML data it is because I want to retrieve it in...

From past experience I would say that budget constraints make a proper test hard to carry out in many shops.

You may be able to proove that a backup can be...

Which is which?

Thhe version of BOL I mean not the Bible. I'm not opening up that can of worms!

I don't really have any more to add than what is in the post. I need to pin it down further before I have enough to go into an...

BOL isn't the most accurate set of documentation on the planet!