I am second to Ninja as set IDENTITY_INSERT works for a single table at a time and before make it on for other table you have to off it...

hi i would like to mention some point at here

you can do this through single procedure why you want two procedure for that.

you are not following proper naming convention...

Thanks howard,

i got the query, in my DB there are few desing issues are there but can't help as my company is using this structure from long time, although this...

i think you shouldn't inculed master in your code to get the user defined indexes,

can u pls post your complete code, that we can go through and come up...

Iin char it is paddedup with space but in case of varchar it will not.

varchar is a variable length datatype so it will always hold as many bytes at there...

>>I am stucked at Index info... I tried using (select name ,index_id ,OBJECT_ID ,TYPE ,type_desc ,is_unique ,is_primary_key ,fill_factor from ['+@srvname+'].master.sys.indexes'<<

i think here instead of using master u have to use...

it is not clear what is your intention, why u r going for a cursor u can easily find all indexes and and db name.

will you please explain in a...

what backup do you have is it from 2k8 R2 ??

give the details to get help

thanks ninja for your quick reply

it was blocked some of the objects, and the lock was not released, i have restarted sql server services and now i am able to...

thanks ninja for ur quick reply

Session IDUser ProcessLoginDatabaseTask StateCommandApplicationWait Time (ms)Wait TypeWait ResourceBlocked ByHead BlockerTotal CPU (ms)Total Physical I/O (MB)Memory Use (KB)Open TransactionsLogin TimeLast Request Start TimeHost NameNet AddressExecution Context...

as per the information given by you,

you can use where clause instead of top

select id from @table where id<=10

if your requirement is something else and you want to...

thanks carolyn, its really a nice solution i use to do it via UDF.

i think in term of performance also this one is better.

thanks

ghanshyam

its glad that you got your solution, but using identity column is better then doing all this.

if can redesign your table it would be better as per performance and maintainability...

in your updated you can mention where clause with your inserted value of geography_id,country but you have to be sure that combination of these two is unique

if it's not...

can you please little bit more explainotry in your problem the amount of information you are providing is not sufficient for us to understand the problem,

few points we need some...