any help friends??????????

thanks a lot for all the suggestions.

Thanks all

I have :-

SQL Version :- 9.00.3239.00 (MS SQL Server Enterprise Edition (64 bit)

CPU type:- x64

Memory :- 32763 MB

Minimum server memory (in MB) :- 0

Maximum server memory (in MB) ...

No other problems. Its SQL Server who is consuming all those memory, because after hours my CPU usage is almost 1-2%. But increases in day time.

i have the script but all the user in the old database does transfer except this so have to issuse the last command for any orphand user but got error....

any help friends??????

yes that give me some more idea.

Thanks.

but when i restart after installing on the first node. do i still need to install SP3 on the second node, because SQL server will be running on node one...

any ideas friends?

can someone help me please??

So in the last step of the job that I have created has the below steps that will create user.

USE [IBM_PTC]

GO

CREATE USER [IBM\1001dpatric] FOR LOGIN [IBM\1001dpatric]

GO

USE [IBM_PTC]

GO

EXEC sp_addrolemember N'db_datareader',...

yes i have a nightly restore of thidatabase, but what exact steps should i follow to add this login to this database. i need some exact steps since i am...

i am a newbie. i don't know how to give port number

yes