See Finding roles granted to users and group(2) thread for full text ( I had some trouble posting the thread ).

oups!!!

Thank you,

Unfortunetly my last good backup is from a month ago :0(. My maintenance was failling and I overlooked it ( my mistake ). On top of that I mistakly...

Ok I'll rephrase that.

Once you have issued the command to restore what is the first thing SQL Server does? Does it truncate the log file?

Is there any way to recover...

I will repost my question with a different title

Ok I think I have a probleme with the way server B was installed.

Server A has SQL_latin_General_CP1_C1_AS collation and Server B has SQL_latin_General_CP437_C1_AS ( withc I presume is case sensitive...

I agree with Frank

Their should be a way to UPDATE our score and set our new total .

I answered that their was a syntax error

I knew that CR would get the first statement empty and return no rows. I figured...

Thanks for your replies.

For your information I need to rename db in test environement. So no need for references to be modified.

I rename DB with version and increment with each release....

Gary,

In the case of replication, how would you replicate new tables added.

How can you replicate new tables, roles and users ?

Thanks

Thank you all for your input!!!

This forum as proven to be very effective I will continue posting question and hopefully one day change my...

Hey!!! just a tought

ISNULL ( check_expression , replacement_value )

I personnaly did not try it.

This is the filegroups that this table belongs to.