abdullah.olaniyan (2/3/2009)

---

Hello People, this is my first post and i'm completely new to SQL Server 2000.

I have an HP laptop with Vista installed on it. Now under program files in...

Imke Cronje (2/4/2009)

---

Would enabling the AWE memory for SQL Server solve this problem? Currently the SQL service is using 1.7GB of memory and there is 4GB of memory on the...

I think you have to use dynamic SQL to achieve this.

CREATE PROCEDURE test_user

@input_login CHAR(8), @input_pass CHAR(10)

WITH EXECUTE AS 'AdminUser'

AS

BEGIN

DECLARE @cmd nvarchar(2000)

SET @cmd = 'CREATE LOGIN ' + @input_login...

scott_lotus (2/3/2009)

---

mirroring does seem sensible to me. but 2 points (basically my inital 2 problems)L

1. im using an a/p cluster, if one db can do into recovery mode for 30...

Have you seen this http://support.microsoft.com/kb/960161

Looks like CU1 fixes your problem.

fred.coleman (2/3/2009)

---

Thanks this looks exactly what I need as a strating point. If I add details from sysschedules, it should do the trick, I'll let you know how I get...

I have never done it from SQL 7.0 to 2005 but...

I think it would really help if you let us know what problems you get.

Do you have problems installing SP3 on the cluster or are you talking about problems...

This one might be something for you:

http://www.optiver.nl/working-at-optiver/job/3401/Database%20Administrator/

Good luck

Very good article.

What do you get if you run a SELECT query from Query Analyzer? Just because EM doesn't return any data does not necessary mean that the table is empty.

scott_lotus (2/3/2009)

---

thanks again for the reply.

So whats the difference between LOG SHIPPING and TRANSACTIONAL REPLICATION then if both use the transaction log to keep the second database up to date...

I miss one thing in this whole discussion.

Why would you want to have 20 ldf files????

That makes no sense at all. 20 ndf's I can understand but having so...

Ok, I got it right and I don't really want to complain about the question. In fact I think it's a pretty good question.

But what I find strange is that...

srimkumarp (2/2/2009)

---

Hi All,

Recently we had upgraded one of my SQL Server 2005 standard edition running on MS Win 2005 Standarad Edition pack 2.

using as a application server.

version :-Microsoft...