Thanks

But I got this Below error

Msg 208, Level 16, State 1, Line 7

Invalid object name 'dbo.Tally'.

I cant understand why u using the above table name..

Many Thanks, I have changed My DB plan with your Ways,

1)Changed the setting of LDF growth % to MB

2)Take the Full back up of Log frequently

Great Help, Here after I wont change the Recovery Mode, But with in a week My LDF grow wtih 90 gb, But In our Datacenter given us only 120 Gb...

Many thanks I have finished that..

Great output, but i want to update that column , please help me, i am trying this way but not success

UPDATE TABLE_1 SET COUNT_1 =

(

SELECT TOP 1 COUNT(1) ...

Thanks a lot for valuable solutions ....

The first problem I overcame by using the Alter table with rebuild partition all now bulk update is going..

But the second problem ?

Hi In veiw the sq server wont allow to use the declarations,

Hi Cox

Thanks for your valuable suggestions.

I would like to clarify some necessary informations for the below reported issue in the implementation of Database Mirroring

in our network,

Both the servers (Principal and...

Your instance might be using begin transactions or use your select query with(nolock),

and try with DBCC opentran is there any active transactions being in process and kill them by...

Many thanks,

can we mirror the database from sql 2008 r2 data center to sql server 2008 sp 2

Many thanks,

Actually what am trying to do is ,

I have number of xml file with same template, i want to load my master metadata table , but i dont have a...

Sorry for incon.

If i tried with this format not working

SELECT * INTO ##TEMP

FROM

T_SP_UPDATE_ITEM_DETAILS '139',30,'TB'

Error

Msg 102, Level 15, State 1, Line 3

Incorrect syntax near '139'.

please tell me

THank u ...

Create one table like result in your database with exact output column , insert the values row by row (in your sub procedures used by cursor.) ,

finally end...