thank you very much, i understud

ok.

But when is the database closed? every time the database as no query's for how much time?

ok, i think i understud the article.

One question:

If i stop the engine (that as this problem) and then copy the data file and the log file...

ok. I undestud.

But, why do i need do rebuid indexes if i shrink a database?

That is a great ideia, but i have a problem.

I can not see what enterprise manager will sugest, because this is a script that will be sent to some remote...

yap, the truncate in this case will not work.

What about the shrink?

I need that after the data is deleted , to shrink the database.

But to what size?

Ok, thank you very much for the help.

About the truncate.

If i have the recovery model in Simple mode, do i get any think by making a truncate instead of a...

It's my real database.

I will send a script

But in this case , i really need it.

I have to update several values of a column that as an identity key.

Can i drop the identity key, make the updates...

what is the difference between allocation errors and concistency errors?

the result of the command:

Server: Msg 8929, Level 16, State 1, Line 1

Object ID 2: Errors found in text ID 6750208...

ok.

Thank you very much for your help,

Pedro

Can i lose some data, because of the change of collation?

Thanks,

Pedro

hummm.... tks...

The problem is this:

I have some employees that i do not want that they have permissions on the Master database.

But i need that they run a procedure. Do you...

thanks. You where right.

Ok , thank you very much.

Other question that i have is this:

I'm selecting like below, to know wich APPs are connected to my database. BUT i am having dificulties.

Can you...