Thank you.Done

LMT

I always go to the file option and execute the shrinking of the specific file.First I move the data, then I delete the data file, or I shrink till...

right click on job - properties

click on the arrows - Move Step after you acivate the step that you want.

For priority - Start step - pick up the step...

thank you I will too

LMt

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

Thank you Allen

how about the latest Q815495 security patch?

did somebody apply it?

lmt

My DBCC came out with 7 consistency errors

I am running dbcc checkdb with REPAIR_REBUILD option

Thank you

lavinia

I am running DBCC now and I am waiting for the putcome.

I have a 100 G database and the recovery will be a headache.

Do you suggest a...

please help

try this:

path to.. dtsrun" /Server_name/user_name/P password/N name of DTS/G unique id in{} of the DTS

Thank you very much

LMT

Just a comment:

- indexed views DO NOT use the view's index IF the base table have good indexes on it.It will use the table indexes, so you earn...

is member_id a primary key or a part of the primary key?

From may exp. when I call the primary keys in the select statement, SQL engine uses the index...

I can be in control over this.

So I plan to dissipate ALL public power especially after I read "lockdown script", very inspiring from http://www.sqlsecurity.com

read the script (that...

Thank you.

Is there an article regarding the public group ?

lmt