Thnk you all. simple thing great help

tx

Great! I was looking for this for a while.

Is there any way of getting the list of the DTS in a server? from which we can get all the dts...

I have a data in my database i want to transfer them to my customers database. but i cant just backup and resotre the database due some other reasons. Only...

well, I want an SP to be created in different DB, Sorry I could have mention this earlier.

Well, I have implemented the mulptiple instance envirment arround one month back.Upto now it didn't cause any issue.

thankx you both,

but the my problem is i have a lengthey script. if I need any changes to be done then I have to modify the sp again

so my requirement...

thankx frank,

I have already written a UDF, I wanted to find out whether there is a simple function.

Anyway I will countine as it is

that is one aspect

are there any performance issues?

Thankx. Simpe thing Great Help

Use attach Database option from the enterprise manager

ok,

this is it.

I need to get the user inputs for the post code formats and phone no format. depending on that I need to create scripts for the check constraints.

how to get that. is there any place where i can download this.

thankx, blessing

First one is now ok.

But second one is a problem,as these databases are out of my control which are already created.

yes u can do a force insert as well.

for futher details look in BOL for identity