Hey,

Are you familiar with SQL DMO Libraries ? you can do all the actions of SQL EM using sqldmo libraries. i dont have any code base for the same. just...

Superb. Congrats. Its a real good stuff.

Jeswanth

Hi

I created one More script seems like doing the stuff.

Craete teh Following Scrtipt

/*

Purpose : To get the Column name for a specified table id and the column id

Author : Jeswanth

*/

Create...

Hi Greg,

Thanks a Lot its working. its a really good script. truely usefull.

Jeswanth

Ok frank. Let me check SQL DMO. Wrote some thing using that some time back.

btw i have nothing against Budha or his followers.

Hi Frank

Thank you for the immediate reply. But that will create tables also. I want only Foreign Key Script.

Jeswanth

testing the email .

You should take the backup of the transaction log file soon after the crash and restore after you restored the data backups.

--Jeswanth

Check Sysobjects and syscolumns and see any ideas are coming or not. if its not then let me know.

Hi aaron_myers

its nice to see your reply post after a long time. well this is how some problems get solves.

Every...

Hi All

Thanks for the feed back. let me try these tools now

/-Jeswanth

Hi Verma,

First of all your question is not clear. Give a Criteria on that you are finding the duplicate values. eg. Sample table Structure in which element is duplicating. as...

Hi,

Your Program looks like following

You are getting a lot of records in to a Cursor and each row you are taking and processing and inserting to another temp table.

I suggest...

I feel your sp is consists of lot of unwanted code. and as 5409045121009  said dont mix up DDL in SP as...

Better change the CEO!

You are asking at the qrong place Brendan. this is SQL Server forum.