You can't log shipping master database. In order to drop user from destination database (by log shipping), you have to drop the user from your original database and run the...

Double click your maintenance plan --> reporting --> check "write report a text in directory" and run your transaction log backup job. Go to above directory to review the report...

You don't have to change the service account as the folder is in same server as SQL Server. Just find that folder --> property --> security --> permission --> make...

Review your SQL Server errorlog for any errors. How large you TEMPDB is? You may have to allocate more spaces for it. Check you database transaction log file too.

Edited by...

Don't understand your question. Can you post more information?

Your SQL Server Agent service account has to be a domain user account with proper access permission to folder \\St-info\Cordelia\MarkBData\CaMIS output\Outpatient MDS\ and make sure folder exists.

Try to download MDAC 2.6 SP2 from Microsoft and install it first, review dasetup.log in C:\WINNT for successful and then install SQL Server.

Please read this KB article.

http://support.microsoft.com/default.aspx?scid=kb;en-us;811889

Robert,

Do you backup your databases using maintenance plan? If you are, double click the plan, choose reporting tab and check "write report a text file in directory". Once backup job...

To create a set of backups, you typically make a database backup at periodic intervals, such as daily, and transaction log backups at shorter intervals, such as every 30 minutes....

Quoted from BOL.

"SQL Server 2000 autoshrinks databases that have a large amount of free space. Only those databases where the autoshrink option has been set to true are candidates for...

Read following KB articles for trouble shooting of slow query performance.

http://support.microsoft.com/default.aspx?scid=kb;%5Bln%5D;243589

http://support.microsoft.com/default.aspx?scid=kb;en-us;224453

http://support.microsoft.com/default.aspx?scid=kb;en-us;224587

Run "select * from INFORMATION_SCHEMA.VIEW_COLUMN_USAGE where view_name like '%yourviewname%'" from QA and copy, paste the result into Word document and print out.

Right click Diagrams in your database --> New database diagrams --> following wizard to add your table into diagrams. Right click table --> Table View --> Standard --> Print.

Can you try to apply latest service pack see whether you still have such issue? If it doesn't work, Follow the workaround from KB 272220.

"To defragment the text or image...