HI Gail,

"Transaction log entries are considered active until the data pages that were modified by that transaction have been written to disk. Once that occurs, the log entries are considered...

Thanks Paul R and Paul W for giving a deep insight.

First of all the article points to the Rollback'd transaction as a whole, not the Rollback statements.

And the intention of...

Many Thanks for your reply...

Just change the collation of the database using Alter Database statement.

This should change the collation of all Tables and columns to the new collation unless

there is an explicity specification...

you could have tried with Sync_Method='concurrent' for SP_Addpublication stored procedure which will not lock the publicaiton table during snapshot

Any help please

Thanks all who responded.

Auditing (profiler trace) seems to be a better option for me.

How about if assign the 'CONTROL SERVER' permission to the DBA's and "Deny Select" on all user tables in the database?

This will allow the DBA to do all Administration task...

NO, this is not the one required here.

I can't encrypt the entire data in the database which will require the changes to application code as well.

I am talkin abt segregation...

As the code didn't display properly updating it correct as below

Begin transaciton

--update tablename set column2=1 where column1=56

-----lots of select code in between no DML

select * from tablename where column1=56

----- lots...

I have two things to tell here

You would not be able to shrink the log file unless you truncate it. When the sys.databases "log_reuse_wait_dec" coulmn status is "LOG_BACKUP", then you...

Still not clear.

See the words from BOL

For snapshot or transactional publications, articles can be dropped with no special considerations prior to subscriptions being created. If an article is dropped after...

I dont see any issue. I had scripted out the sql 2000 relication --> restored the databases in sql 2005 --> set the compatibility level to 90 then applied the...

All the above answeres make sense of having one log file per database.

Transaction log file is optimised for sequential write, and hence get best performance if have only one trnasaction...

xtype column in syscolumns refer to the type id of each datatype or user defined datatype. xtype maps to system_type_id column in sys.types table.

sys.types view contains all information abount datatypes...