Hi,

Thanks a lot for correcting me, what i mean to say was i need a exact replica of the live DB to be put on with some other name.

With Regards

Hi,

Thanks for the input. So taking the backup and restoring will be the best way.

Through Maintenance plan i am aware of taking a backup, but how to restore the same...

Hey,

Thank you very much for the reply, but correct me if i am wrong. When i pass the owner and procedure name which has been encrypted, i am not...

Hi,

Thanks for the reply

Yes I would like to schedule this, how to go with this.

Select CreationDate,Name From [Database-A].[UserName].InfoA Ta INNER JOIN [Database-B].[UserName].InfoB Tb

ON Ta.id=Tb.id

Is this what you require?

let me know if you are helpfull with the above Query, if this...

I havent tried it , i will try that and let you know if i have any problem. Thanks a lot for the instant reply.

One more thing can i use...

Yes I did, but even trying all the options, ending up with no result

Thanks again, i will get back to you, with specifying the size of log files and mdf files for the DB

With Regards

Dakshina Murthy

Thanks for the instant and very usefull reply.

I have a doubt, please dont mind if it is a stupid question or a silly question, because i am new to all...

No , it runs in the same user and for the same db for which the other job (Steps) run. I am using SQL server 2000 SQL Mail not SQL...

Yes i am sending an attaching which sends the results of a query which may have a size of 3 MB or even more.

Here is the script which i am...

Thanks a lot for all your reply.

Thanks a lot for all your reply.

Thanks a lot for all your reply.