suser_sname() in the trigger will return the Windows login. Insert that into the field you want to keep it in.

Check the services applet in control panel for the correct name. Be sure it's set to automatic.

Return a table variable instead? Not sure how you get around this. Don't the other procs use the base proc?

will be written to the log, then written as a change in memory and flushed out. However, if you are worried about some hardware issue, if the server crashed between...

If I understand correctly, you'd need dynamic sql to make this work. If you are trying to minimize code and have the proc only run in one db, but reference...

Is this code in a stored procedure or just dynamically submitted? Have you run DBCC CHECKDB to be sure you don't have corrupt apges somewhere.

Is this the only transaction that...

What's SQA? And I have never seen this in working with 2000 querying v7.

Are you sure someone isn't working with this table and removing rows? If someone else can...

You'd have to have some looping mechanism to find the places where /* and */ are, position I mean and then substring them out.

So

create procedure myproc as /* test */...

What's the query?

Connect to SQL with QA

Rename the windows install

issue an

sp_dropserver (old name)

go

sp_addserver (newname), local

And reboot. Should be good to go.

Interesting idea. AFAIK, none of the site owners are bilinugal, so comments in any language are unreadabvle by us. I typically don't review the scripts when they are submitted because...

Using sp_who, which queries the system tables it NOT accessing the system tables. The reason sp_who is available is precisely for this reason. It is guarenteed to work in future...

I'd agree with the above. Load into SQL and then dedup.

There isn't a good way natively. Products like Red-Gates and others allow you to do this fairly easily, but you have to do it. I think some of them do...

You'd need to code something in the DTS package to look for the change in the file.