Thanks for all who given such important information..

Actually, I was thinking to do the same but I was not having such informtion etc..

Once again thanks for sharing.

Best Regards

hI,

HOW TO CREATE THE LOGIN ONTO THE LIVE DATABASE AFTER THE DATABASE RESTORATION

1.Open Query Analyzer into the backup server.

2.Select your database name.

3. Type the following query.

-------------------------------------------------------------------------------------

print ''

print '-- Script for...

Hi Lakhani,

Thank you so much for your great link...

I will work on clone server & I will get back to you soon.

Best Regards

Hi Grasshoper,

I restored database in new clone server & I can access it via "sa" user only, but when I run that script to restore users from live to clone...

Hi Joseph,

Thanks for guidence...

You are 100% right.

Best Regards

Hi,

Kindly can you help me for the follownig question...

Whenever a user inserts a record into database(sqlserver), i want to write one trigger such that it fires on a particular date(suppose...

Hi Grasshopper

Simple solution for your problem is shrink the log file for all databases.

Use the following link supplies by David Bird  in this forum

"Shrink Log file...

Hi All,

Today I received this script from this group to shrik the log file, I test it on my backup server which works excellent. before It was my log file...

Hi Phil,

Thank u so much for your kind info.

Firstly I will start Administration of SQL Server 2000 then MCDBA and so on etc...

I was in confussion that what will be future of...

Hi All,

Kindly can you please suggest me for the following doubts.

What's the future of SQL Server 2000 Administration & MCDBA.

Does it required for students to upgrade their edition from SQL Server...

Test Msg