Are the network protocols enabled in the target server.

why not use sp_msforeachtable . Search this site for more info.

I believe you could do this using complex T-SQL but even that would consume memory. Using...

Whats the amount of data that we are dealing with?

Where LEFT (col,4) like or equal to LEFT(@Var,4)

You can substitute the value 4 by an appropriate value.

Nandy (11/18/2008)

---

Hi All,

I have used the cursor in the stored procedure to delete the data from the table. I'm deleting the data from table where I used the same table...

Amit Gupta (11/17/2008)

---

When i am restore diff backup then database not set standby or norecovery.

me want programatically set norecovery first and then restore then again set with recovery. when i...

I suggest you created temp tables with identity columns. Insert your data in order and then select the data by joining on the identity columns.

Hi

Delete the records in batches. Look up this site for more info.

Hi

You will have to extended procedures for this. Check out these extended procedures on the net

xp_create_subdir ,xp_dirtree.

Amit Gupta (11/17/2008)

---

I have a problem , we take a differential backup and restore in another server

daily through DTS with schedule time but i am not getting right way? so...

I dont think so. You would miss all the constraints/Fkey relationships that can be used. Your code could become...

Read up on DDL triggers. They can help.

Hi

Test this before actual use.

-- Take students who have even a single passstatus as 'N'. ---Update studentpassstatus with CASE

-- those students as 'N' and other students as 'Y'

UPDATE #Student...

i thought the third option was the right answer.