HI All,

I tried different scenarios i.e. By using Import wizard and SSIS but it is same issue at finally Imported successfully by using Bulk Insert command

Ex:...

Thanks for u r quick reply , We are not taking log backups...

I think u r trying to add column from designer ?

Add column by using sql script

Ex:

ALTER TABLE Table_Name ADD COLUMN_NAME INT

If u want add column from designer , before...

Nice question..

Are you using which type of replication?

Hi

use this below syntax.

update table1

set field1 = '-'+Field1

--with where condition

update table1

set field1 = '-'+Field1

where field2 =1 0

muthukkumaran Kaliyamoorthy (11/19/2013)

---

PRR.DB (11/19/2013)

---

Hi all,

In My machine i have two instances i.e. one is default and named instance ,

How i can connect named instance by using port number

named...

Good question.. learned new thing

Easy question for end the week...

It is working fine.. thanks Gail Shaw

Thanks for your quick...

Good question

I should be handle this server to client with 2hrs, I have only 2hrs downtime(from now) ,

So i tried so many ways, but it is not.

now it showing remaining...

thanks Kurt W. Zimmerman,It is showing remaining time 2hrs and 30 min ,

Is there any way to get online immediate?

muthukkumaran Kaliyamoorthy (10/29/2013)

---

PRR.DB (10/29/2013)

---

Hi All,

I have taken full backup of database yesterday(with Recovery Model=full ) from sql 2005

and taken differential backup today 5PM(IST)

now i am restored the full backup...