>Is there an possibility to make an role that can do DBCC commands en have the Create Database role ?

Well, yes there is, but since the software is using sp_detach_db...

>Is there a way to output everything to a text format, and maybe run a compare against the two ?

Try using SET SHOWPLAN_TEXT ON.

>How do I update tables/indexes statistics on...

I guess it depends on how you package your ASP.NET application. A common way to handle this is to have a setup page that the user should navigate to when...

Unfortunately SQL Server does not support row value constructors and assignment. That means it does not support row comparison operators and therefore cannot do row subqueries, as in your example.

For...

That could actually make for a pretty good quiz question, at least if trick questions are accepted.

>We were looking for a smoother way, directly affecting the sysconstraints table (field action), yet this seems hard, and undocumented...)

As Frank and Remi says, this is for a good reason....

I do not know of any specific tool that does that precisely, it sounds more like a general code coverage tool for working through all your code. And that is...

You should use the MSDN Product Feedback center to add new suggestions. Make sure you describe your suggestion in detail. For instance, what counts as a statement? In this...

Have you checked that there is not a firewall blocking access to 1433?

Doh, much better solution of course. Sometimes one should not know too much.

If there is no space available but the files are set to autogrow then you have no problem. As soon as more space is needed SQL Server will grow the...

CREATE TABLE #ind (

PageFID INT

, PagePID INT

, IAMFID INT

, IAMPID INT

, ObjectID INT

, IndexID INT

, PageType...

Schizophrenic?

No problem, glad it helped. Those solutions are often the hardest to find.

There is no way to use only SQL Server authentication mode. However, you can remove the BUILTIN\Administrators group from the logins if you want to stop system admins from gaining...