I agree with Gail, please submit this elsewhere. This is an ASP.NET issue, not a SQL Server issue. On SQL Server, you have protection if you have a PK that...

The steps on production are the same as on test. That's why you test and learn on test servers. So you know exactly what to do.

You have permissions errors occurring. How are you trying to open the file? I mean what are you trying to do here?

Create a new db

copy the current one over there, moving all the schema and data.

It shouldn't matter, but are you just running this script, or is someone changing this in the GUI? It's possible that there is a bug in the script being generated....

I completely agree with Ed here. Not really a useful tool, IMHO.

If this is because you are selling software, you would be better off writing a "do not touch" clause...

There's no random order applied. The order that the columns are defined in is the order that is used. This works fine on SQL Server 2008:

CREATE TABLE MyTable (col1 INT,...

First, read this: http://msdn.microsoft.com/en-US/library/ms143504%28v=SQL.90%29.aspx#Use_startup_accounts

You can use a domain account, a local account, or a built in account. I'm not sure what "this account" is.

The NETWORK SERVICE account doesn't necessarily...

Your data is stored as a string, so you cannot do math operations on it. You would need a script to change the account numbers as strings.

you can use substring...

Door

replaced my garage door opener this weekend. And it works!

I pinged a few people for you, and edited to remove your phone number. Not a great idea to post that publicly.

First, it depends on how you have connections. Most applications make a connection, run a query(ies) and then disconnect. Through web pages, typically you have many more people on the...

The system databases are:

master, model, msdb, tempdb, ReportServer, ReportServerDB

You can identify them with an IN clause

...WHERE name not in ('master', 'model', 'msdb', 'tempdb', 'ReportServer', 'ReportServerDB')

Mirroring doesn't affect the log, with the exception that the log is needed to send the data to the mirror database.

If you don't need full recovery mode, why not just...

There isn't a good way. Since the user can change the name in the connection string of the application, there is nothing you can do here to prevent it. What...