I don't think so, since restarting services is an OS-level event rather than an application level event.

You'd have to have security auditing configured on Windows & check the Security Event...

If you have an Enterprise Edition CD then it won't install the database engine etc. You need Standard, Workgroup or Developer Edition (see Books Online: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/09bcf20b-0a40-4131-907f-b61479d5e4d8.htm)

Likely to be what Steve put.

If you have another DBMS or tools on the server (notably Oracle) you may need to put the full path to the SQL...

Try this:

[font="Courier New"]if not exists (select name from sys.objects where type_desc = 'DEFAULT_CONSTRAINT' and name = 'DF_AID_AGENCY_STAFF_CSR')

ALTER TABLE dbo.AID_AGENCY_STAFF ADD CONSTRAINT DF_AID_AGENCY_STAFF_CSR DEFAULT 0 FOR CSR

[/font]

Quick and dirty, run this from an SSMS query window (connected to the DB engine):

[font="Courier New"]declare @table1 table (id tinyint identity (1,1), data sysname)

declare @count smallint,

...

Presumably the database being restored is from another server? Otherwise your user would already exist if you were restoring a database that was already present on your server (assuming...

What do you mean by transition?

The status of a database can be gained from DATABASEPROPERTYEX:

[font="Courier New"]select name, databasepropertyex(name, 'Status')

from master.sys.databases

[/font]

This will return one of: ONLINE, OFFLINE, RESTORING, RECOVERING, SUSPECT, EMERGENCY

for...

Best practice would be to stop the web services before rebooting the SQL Server then restart them afterwards. You're basically yanking the rug out from under the app's feet.

At...

Do you mean transaction failure or a failure to restore one of the transaction logs? Or a failure to ftp one of the transaction logs?

You could setup a log...

Run these commands to generate add & drop scripts for the devices you have already. The add scripts have the new drive letter.

[font="Courier New"]select 'exec sp_addumpdevice ''disk'', ''' +...

Not sure about the permissions thing, but is this on SQL 2005? Because trace 1 is a default trace that SQL Server 2005 always runs and needs to be...

Has it been working?

When did it stop working?

What changed between when it was working and when it stopped working?

Can you do an nslookup on the SQL server name?

Can...

Along with the size of the database, I'd ask about growth rates as well.

With authentication, make sure the application is not storing the password in plain-text in a config file...

It strikes me that the other group doing the migration is getting an SQL Server error and they know little to nothing about SQL Server. If you are expected...

Try this (assumes you have a query window open to the SQL instance in question). It's from a documentation script I found and allows for instances:

[font="Courier New"]-- the value...