Alternatively you can run this:

USE [master]

GO

/****** Object: StoredProcedure [dbo].[sp_help_revlogin_specific_name] Script Date: 01/27/2009 15:51:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[sp_help_revlogin_specific_name] @login_name sysname = NULL AS

DECLARE @name...

Hi there,

Assuming that the two databases already exits and that the user is a domain user (DOMAIN\USERNAME), this will work:

USE [master]

CREATE LOGIN [{YOUR-DOMAIN}\{user}] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

USE [{db-name-1}]

CREATE USER [{YOUR-DOMAIN}\{user}]...

That worked brilliantly MANU, thanks.

I had seen that posting yesterday, but the restore option was greyed ourt, so...

Hey Steve,

Both, error i get is:

Msg 3724, Level 16, State 3, Line 1

Cannot drop the database...

Hey All,

Just to update you, we have found a way around this issue. Turns out we dont need to role back single inserts within the trigger.

We tried all we could...

Jack,

Where should the COMMIT in the code be? the developer reckons at the start of the trigger (before the SAVE), but I thought at the bottom of the TRY.

Are either...

Hey Jack,

Hoped this would reach you. Will pass on to the developer and get him test.

just write a batch to check on the services, you will have to hard code but should be fine after that.

Cant remember the sytax but the util comes from...

Hey there,

I found an article a while back which is incredible. You can change the collation of a db and re-format the data in situ. So in your case...

And message the correct forum.

Phillip Oyog (1/15/2009)

---

Hello,

This is my first post ever on SqlServerCentral so bear with me. We have a high-availability mirror set up in our office running on Windows 2003 srvr...

Phillip Oyog (1/15/2009)

---

Hello,

This is my first post ever on SqlServerCentral so bear with me. We have a high-availability mirror set up in our office running on Windows 2003 srvr...

Did you select to 'initialize' your subscription? Sometimes this step can stall if your account does not have sufficient rights on both servers.

Agreed.

I'm just looked at the article and those b*ggers have renamed it to 2008. Even Google says its 2005. Oh well, I guess it jsut works the same way in...

Hii David,

I think we both misunderstood and some point. What you can do is run a SQLCLI command to rebuild the system databases. This is generally used to recover from...