I have pulled out the transaction SID, and have mapped it to the user, by using SELECT SUSER_SNAME(0x0X0X00000000000XXXXXXXXXXXXXXXXXX);

and have found that alter login was run by which user, as myself...

Hi Rajesh....

If you are asking how to add a local account to view the linked server tables then you need to check out option Impersonate....anyways please find below points from...

Make sure that they both are of same edition.

i mean SQL server 2000 be ENT edition then SQL 2005 should also be ENT edition.

well i need to monitor growth of both log and data files.i need to maintain record

not that sure but this might help

http://www.red-gate.com/products/sql_backup/walkthrough.htm

I guess you can create a separate database or file group and DTS the objects out there, which can later be backed up.

i guess DB mail would be usefull.......

Thanks one and all

thanks....

http://www.microsoft.com/technet/prodtechnol/sql/2005/bkupssas.mspx

do u jav access to "admin tools--event viwer" if u do look at the log noted down at that time when agent aws stopped hope that might help u

database is getting into prod for first time.

plz help me

"I want to restore the backup on a database on a different server without copying the backup to the server"

When i face this satuation i would take care that second server...

Thanks greg

http://www.microsoft.com/sql/editions/enterprise/sysreqs.mspx

These might be of help

KB: http://support.microsoft.com/kb/288577

http://support.microsoft.com/kb/326485

Discussion:

https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=738574&SiteID=17