IS GRANT can be safely disregarded.

Some times large queries generate those tempdb tables that you are expericencing. If you run dbcc inputbuffer(SPID) it may show the last command or...

the problem with tracking the App that called the procedure is not an easy one because the connection string takes whatever you pass to it

You just discovered the problem with "text" fields

can you change the "named" instance port ?

1433 should be used for the "default" instance.

I have used the proxy_account in the pass successfully and by limiting the windows rights that the account enjoys I don't see problems in using xp_cmdshell.

In 2005 there is...

Really? So you rename a machine and you won't restart it ?

Ok Because of that *same* reason we don't use IDENTITY columns. But if your recovery time allows you to run dbcc checkident, that, is how you do it. We just...

I used to do *full* code reviews also but now with the amount of code that goes/changes daily on my new job that is simple not possible. Developers do their...

Why are you worried about the current_identity value on the replica if it is supposed to be read-only ?

Basicaly you can call bcp from dynamic SQL too so anything you do with BULK INSERT should be possible with BCP. Am I missing something ?

And the trickiest part is that being member of db_backupoperator is not enough because you could have DENY on Backup Database statement on the DB.

no need for inline views just use directly the table:

select v1.[name],v1.[year]+'/'+v2.[year] as period ,v1.number1+v2.number1,v1.number2+v2.number2

from t1 v1

join t1 v2

on v1.[name]=v2.[name] and convert(int,v1.year) = convert(int,v2.year)+1

the content of your function maybe refering to a database that either does not exists or is not online. Can you post the function Definition ?

If you are so concerned about 2000 forum why are you talking about database mirroring ?

Do you have an SQL Server 2000 database mirroring solution? ...

you must cast all sorting columns to the same data type.

try changing :

 when 'job_desc' then job_desc

   else job_id...