Then DDL trigger is your only choice mate; in production environments I support. No one does change on production servers, they all go through the dba team.

At the end...

Rohit Chitre-274613 (8/18/2010)

---

I am trying to configure mirroring using script.Everything went fine until I tried to configure the partner on the Principle using following command

Alter database AdventureWorks set partner =...

Heh, I find how Microsoft does downloads for these "special" requests abit annoying. I have made the same mistake before, but after downloading these "special" patches again and...

Could you please try redownloading?

The log you posted .. has this..

So either you posted the wrong...

Jeff actually that does work without double quotes (just did it today :P); no issues :D. But I usually put -SServerName\InstanceName and avoid using "-" in my server names...

Database mirroring can be configured in warm-stand-by or hot-stand-by mode; in either case, for database mirroring to grantee that no transactions have been missed it requires FULL recovery mode.

In database...

Is the end-point state started?

if you check SYS.database_mirroring_endpoints check state_desc; if not started. use "Alter Endpoint" statement to start it.

When the application tries to connect to restored database it is on same server or a different server? Also are you using SQL Logins or Windows authentication?

What is the...

You can check out your other SQL installs and try to hack the reg for the Shared memory protocol at ..

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\SuperSocketNetLib

But best recommended process is uninstall SQL and...

edvard 19773 (8/17/2010)

---

I have tried to use the SQLCMD from a DOS window.

Used this command line:

SQLCMD -U SA -P [Strong password] -S EDVARDDELL-PC\EASYPLAN

When I click 'Enter', I get a:

1>

Telling me,...

If a developer is trying to sneak that by me, first thing as DBA I will revoke all his access and escalate it with manager. So kudos to you for...

There is your problem then, SQL Protocols never got installed. Only way I know of installing them is installing SQL Server properly. I suppose there is a way...

kk I should have caught this sooner heh, sorry. two issues one you are installing x86 update on x64. Not possible. To you are installing wrong update,...

You can try using database snapshots, once the database has been restored to a state. Create a database snapshot, then allow user to do their work. If issues...

If this is a new build then it makes sense because you might have noticed right after SP3 install was finished it would have brought up the provising tool. ...