You might as well try DB Visualizer. It works great with most RDBMS.

Thanks.

Bru Medishetty (1/7/2010)

---

You can start creating databases one by one until it...

If you only have single instances on both the Active nodes then you only...

Major difference being the downtime associated with applying patches on a Standalone server.

Thanks..

Just to add my take on becoming a master, I guess one needs to follow on things told by Gail,Steve,TheSQLGuru and any other SQL Expert that I fail to mention...

Mike01 (1/6/2010)

---

I have a Cascade delete foreign key set up on table A that references table B. I also have a proc that performs a delete on Table B....

I didn't knew rebooting Production was that damn easy..:w00t:

If I know my manager correctly, he would just shoot me in my arse ➡ with his .5 Caliber gun if I...

krayknot (1/5/2010)

---

sanketahir1985 (1/5/2010)

---

as Shawn Melton said

1. check for free space on drive where tempdb is stored

&

2. Try to truncate log of tempdb only if no users are using tempdb...

A better way of doing it without using CTE or Update statement is as below.

insert into dbo.Employee(id,name,pg,street,city,state)

select a.id,'Alex',a.pg,b.street,b.city,b.state

from

dbo.qualification a

join

dbo.address b

on

a.id = b.id

This should be what you need..

Hope this helps...

Thanks jcdyntek. It works well for me.

Lowell, I checked all the chars to be Ascii 160, so I am good there. Thanks for bringing it to my attention though..

Thanks Gsqaured..I ran the query below for the record with phonecode = 54 for which I got the error as

select ASCII(substring(phonecode,3,1)) from dbo.Codes

where id = 11

And the result was 160...

freeman.e.l (12/23/2009)

---

Two simple options:

1: use sp_who, and kill to kill processes that block your backup

The database will halt the processing of anything you kill.

2: perform backup in single user mode:...

Pavel..your query returns result in the format I needed. I need to use it to do the inserts now..will follow up with you guys if I get stuck somewhere 😉

Thanks..

Ryan, I tried your query, it works good, but the format I need is different. I am posting your result set as attached along with the desired format from your...

Thanks Ryan and Turner..I will try out both and let you guys know which one works for me.

As I have in excess of 20K records that i need to split...