yeah, that would be gr8 if you upload the modified utility.

thx

I would say use a Vbs to read the names of all the files in the directory, then just use fso object for renaming the files.

That's gr8!...Please share the code.

create proc usp_update_emp_data

(

@tblName nvarchar(512), --Table Name

@colNameVal varchar(1024), --Column & Value pairs. Eg: Name='john',Age=32

@empID varchar(6) ...

I have a doubt, do you want to achieve this through T-SQL...

Can also use "SELECT trigger_nestlevel()" if it suits your requirements...

To be sure that it does not happen, disable firing of triggers within the scope of the first tigger.

See BOL for exact code.

What if there is no identity column is the table...???

The approch i take in such situations is to pass a specific string from GUI to SP, then look for that specific string in SP and if found, just dont...

Can you please paste the macro code in here...I guess it would be great to learn its functionality.

try this...

- The connection to sql server is correct in DTS package, Try

using sql server Auth. with 'sa' user.

may be it helps...

May be this helps:

http://support.microsoft.com/?kbid=262681

Reshu

7.  Entities: Did he ask something related to ER Diagrams?...

Tables are also called entities.

I agree that we can use split functions to get the data from the passed string.

Just a better way of doing it would be to pass a XML string and...

I am afraid there is only this as the error message.

Ok let me know one thing, if i try to restore backup to a different machine which has no logins/users...