No problem

Sounds like you answered your own question in the subject line

What you want to do is do a full backup of the DB...

Sounds like you want to generate SQL scripts, which is inbuilt in SQL Server.

In Enterprise Manager, right click on the DB, expand all tasks and select Generate SQL Scripts.

There's more...

Hi Jenifer,

The short answer is yes, one role would overrule another.  SQL works on the least permissions principle, so you can have a login as a member of a custom...

Hi Karl,

No I haven't found any NETLOGON errors yet but will have a better look to see if there are any other warning messages

Hi Swarn,

I'd agree with the former poster that something like DBGHOST or SQLCOMPARE (and DATACOMPARE) would be, we use SQLCOMPARE extensively in our organisation and have found it to be...

Yep, quite a lot but none saying which server they're comming from, they're using kerberos authentication and I have tracked down a couple of system event logs saying

'The kerberos...

Looks like you need to start the MSDTC service on the server

It kind of depends on whether your audit database is going to be used to track a single DB or multiple DB's.

If it's just the one then I'd tend to...

Setting the DB to single-user mode wont kill off all of the other connections, you need to do that yourself.

If you don't kill their connections and there are other people...

Select @@version on our 64-bit server results in the following

Microsoft SQL Server  2000 - 8.00.760 (Intel IA-64)

 Feb  6 2003 16:07:24

 Copyright (c) 1988-2003 Microsoft Corporation

 Enterprise Edition (64-bit) on Windows...

Double post much

Nope, if you want to restore your DB then you'll need to kill off the connections to it first, either nicely or otherwise (depends on the DB and who's using...

Is the dynamic SQL being ran from inside stored procedures on the sql box or is it coded into the web pages?

If it's the first then it's not going to...

If you have a clustered index (primary key clustered as in your example) sql will always do a clustered index scan rather than a table scan for this sort of...