Michael Earl (1/9/2009)

---

Dugi (1/9/2009)

---

Use this Script to find the Tables without any Primary Keys or Clustered Indexes!

SELECT c.name, b.name

FROM sys.tables b

INNER JOIN sys.schemas c ON b.schema_id = c.schema_id...

jameslester78 (1/9/2009)

---

oh, when i look in my system...

Did you try the 2 little code above!?

Use this Script to find the Tables without any Primary Keys or Clustered Indexes!

SELECT c.name, b.name

FROM sys.tables b

INNER JOIN sys.schemas c ON b.schema_id = c.schema_id

WHERE b.type =...

Let say your table has 100 rec and the ID column withvalues 1,2,3,4,5...100

so you write

SELECT * FROM TABLE WHERE ID IN (2,3,24,1)

Post more info for your problem!

:hehe:

Don't do double post just edit the post!

All reply should post here

http://www.sqlservercentral.com/Forums/Topic633185-338-1.aspx

Don't do double post!

================================================================================

Yes the system databases in SQL Server 2005...

Anybody has info aobut that or anybody has success!?!:w00t:

Ooooppsss I didn't see the "r" ...ok try with replace option during restoration !

umer (1/8/2009)

---

can anyone guide me how can i restore database backup of name "cbs_test" to new database "rmsdb" i have created backup of old database and when i try to...

Gaurav (1/8/2009)

---

Thanks for your reply

I was able to merge two table however the final table has no more primary key and also in my database there is a relationship...

ahall13 (1/8/2009)

---

wow fast responses thanks, those examples are perfect.. is there any reson I would have a problem calling a KEY? for example I can select staff_id fine...

or you can try like this:

NEW OR your table is TAB1

OLD OR the table with old values is TAB2

the code should be like this:

UPDATE TAB1

SET new_amount = T2.old_amount

FORM TAB1 T1,...

If you want the best and the correct solution, post the structure of the tables and some sample data!!