Luke L (12/6/2010)

I stay away from GoDaddy because of their commercials. To me, they scream "We don't actually know what we're doing and we're hoping you don't either."

.....

Based on my...

The...

Good luck. That's a messy job. Hopefully you'll come out unscathed, unlike me. I stabbed a finger...

You have to reinitialize the subscription, which you can do from backup, but that doesn't mean that you need to move the whole db. You just need to move the...

What are you referring to? please write more information, and explain exactly what you are trying to accomplish.

You cannot setup mirroring to/from SQL Server 2000 instances.

If you have databases...

Please also try to solve this yourself. We are more than willing to help, but we are not here to do your work, or homework.

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...