Did you actually look into this or are you just asking randomly? :doze:

Read BOL (books online), try a few bits and...

homebrew01 (3/18/2009)

---

Jonathan Kehayias (2/10/2009)

I ask myself that same question sometimes. Usually at 2:30am when I am driving to the office to begin a maintenance task like installing SP3 on...

Thanks Perry,...

Ok, we can get to the certification later.

For now run the scrip below on both servers. It will create a user called 'MirrorUser' with a password of 'mirror'. I am...

Is this about a space issue or just wanating to keep the logs small?

If space issue, consider moving the logs to another disk on yout server.

If just trying to...

Hi there,

A couple of things that werent clear to me while reading:

A: are both your instances local (ie INSTANCE1 and INSTANCE2) and are they named or default?

B: Did...

Mike Levan (3/11/2009)

---

recently i installed sql server 2005 enterprise on my machine and in the wizard when asked for instance name i gave " REVDEV" but after completion if installtion...

If your using SQL 2005 you should build these actions into a maintenance plan (SSIS based). This way you can control the flow. I.e the t-log backup wont trigger until...

How did you create the mirror? TSQL or wizard? Are you able to check with defaults ports? Has the port your using been allocated for that traffic?

How did you create the mirror? TSQL or wizard? Are you able to check with defaults ports? Has the port your using been allocated for that traffic?

krishnaraj9 (2/9/2009)

---

PaulB (2/9/2009)

---

Let me help you with a couple of them...

1. While instalation i am getting one error "restart ur system and install again" ?

Server liked the process that much...

PaulB (2/9/2009)

---

Let me help you with a couple of them...

1. While instalation i am getting one error "restart ur system and install again" ?

Server liked the process that much it...

Mike Levan (1/29/2009)

---

Cannot add rows to sysdepends for the current object because it depends on the missing object 'sp_hexadecimal'. The object will still be created.

Cannot add rows to sysdepends for...

Sorry guess yoou do need the NOT, try this, have tested and works 😉

USE [master]

GO

/****** Object: StoredProcedure [dbo].[sp_help_revlogin_specific_name] ...

Sounds like your about there. Gave you the script to be easier (if your new to this, less to explain), wasnt being patronising.

One thing though, if a user has DBO...