Thanks

i meant is there a script that can uniquely identify a server through the registry.

1 connect to server with vb.net

2 run script

3 get unique identifier for server/instance based on registry

thanks...

Thanks for the reply, but....

i wanted specific files from backup SETS, not stand alone files, and in TSQL, as i know how to do this in vb

thanks for the answer

i have one last question, if you can : do you know where in the registry is the unique id number of each instance??

chen

Sorry for the inclarity, i will try to explain :

in a backup device there are many backups, and i am looking for a script that will delete specific backups from...

thanks for the reply my bad

This SP will delete the entire device.... i only want to delete those who are expired from it to conserve space. Is there a script for it or do i...

what about the physical file??? i dont see any action to delete it?? what will happens when the DBbackups fill the HD??

i'm talking about sql servers... i have to make a registration for a program that takes the id number from the registry but i don't know how it is with  multuple...

it seems that this is my only way to act

i hoped not to save all the previous db params in the case of a rollback( becauce...

that solutions is probelmatic because it doesn't address the case in which one of the other four commands doesn't work .Then i would have to rollback the alter database as well...

why not in the loading of the asp page, determine what type (unicode or other) it uses and make all conversions client side?? think scalability - what if instead of...

thanks for the reply

i can't send the script as it's problematic to produce it

the format in psuadocode is :

TZ = SQLCONNECTION.createtransaction

comm = sqlconnection.createcommand

comm.transaction = tz

comm.command text = "alter database ........"

comm.executenonquery()

comm.command text =...

i have solved the problem so if it helps any one the solution is that the scripted job as a whole script doesn't work, it need's to be trimmed. if...

Thanks for the replies

The user is the same user, and i dont get any error messeges.... just the open transaction in the SPID counter increments by one

Any suggestios??