Please confirm if the below points are true for full recovery model without changing the recovery model:-

The below query will take the back up transaction log and shrink the log...

database to be Full recovery.

there will be no data loss or minimum data loss.

Well i have gone through the articles mentioned above. Currently there is no transaction back up. database is in full recovery.

Will it be useful if we run the below...

recovery model is full

Thanks for your reply. No of page is 5 Only.

DBCC ChecKDB('DB1') WITH NO_INFOMSGS, ALL_ERRORMSGS

errors:-

Msg 8964, Level 16, State 1, Line 1

Table error: Object ID 553769030, index ID 1, partition ID 72057595610529792, alloc unit ID 72057594055688192 (type LOB data). The...

Table have ID for which cluster index have been defined. there is a field TRNdate, a datetime field which is a non cluster index. Is there any changes required in...

Thanks for the information. can you please describe the partition function in more detail.

http://msdn.microsoft.com/en-us/library/ms189124%28v=SQL.90%29.aspx

This above article defines to estimate table size based on table structure and number of estimated records for the table.

While estimating a table size I found that...

Thanks for your help. Previously i was getting error Database key error. Now i have implemented Successfully.

Thanks

I am looking for if it is possible using sql query.

Thanks

Thanks a lot

Please find the work around which is using Table variables and CTE:-

Hope this will give you the idea what are you looking for.

Create Table TestTable1

(srNo int not null identity(1,1),

EName varchar(10),

DT...

Thanks for your reply for CLR integration which is working fine for me.

Thanks Again.

Regards