http://msdn.microsoft.com/en-us/library/ms188283.aspx

You need to grant membership to one of these roles.

MJ

http://sqlserveradvisor.blogspot.com/2009/02/microsoft-included-fnvirtualfilestats.html#

HTH!

MJ

Is FullTextSearch service running under the Network Service account?

Check this-->http://www.sqlservercentral.com/Forums/Topic309073-146-1.aspx

MJ

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/sql2005symmetricencryption/2291/

MJ

Regarding your second point read

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/2d7cc40a-47e8-4419-9b2b-7c69f700e806.htm

MJ

SELECT

name, description,suser_sname(ownersid)

FROM

msdb.dbo.sysdtspackages90

Try the above code from http://sqlblogcasts.com/blogs/acalvett/.

MJ

AlexSQLForums,

See how your answers are acting as a FULL GLASS OF MILK for a thirsty crow so kindly don't waste your time answering him.

Thank you,

Manu

Some infor regarding rowmodctr:

It counts the total number of inserted, deleted, or updated rows since the last time statistics were updated for the table.

0 = Index is partitioned when indid...

Try to run the transaction log copy job command under query analyzer and see if it copies the files or not. Seems to be a permission issue altogether.

Also, while executing...

You can simply restore msdb from a backup that you have made as long as no one is using it. That really means to just stop the SQL Server...

If your db crashes for whatever reason, you have to backup your transaction log so that you can do point in time recovery. This last backup is called Tail log...

I know you will ask this question,why you didn't ask them to close the connections properly?

Give us their email id's we will order them to close it.....LOL

MJ

Is your job owner an non-sysadmin account? Try changing it tosa and see if it works.

MJ

You can setup the database on the secondary server manually by using RESTORE DATABASE with an undo file. Then in the log shipping setup, you tell it that the database...

Another thing that has worked for me when shrinking when there truly is free space - expand the file by a little bit and then run the command that Jeff...