Because we always have SQLAgent running, I've just implemented an extra job to check and launch the sox-trace proc.

This job is scheduled to start whenever sqlagent starts.

I've kept the startup...

Red Gate has a free "SQL Log Rescue" for SQL2000 !

Very nice !

maybe it's worth to mention that MS has a free migration assistant for Oracle to SQL2005.

I don't know if it supports the Oracle 7.3

As stated in Greg's blog, many times we just overlook the fact that most of the time, a CIX is not choosen for a special reason, but just to have...

Just to add .. MS has released a nice article "Comparing Tables Organized with Clustered Indexes versus Heaps" in the sql2005 best practises.

you can find it at http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/clusivsh.mspx

...I don't find CLR functions difficult but I do worry about the appropriateness of their use in the SQL layer....

Indeed, this is the biggest concern

Thanks for the reply.

Their biggest issue was it not being available using the connection wizard.

The workaround is creating a connection and selecting the .Net connectiontype for odbc.

So also the...

Yes, you are correct.

you could use profiler to see what is causing your db to startup again...

I'd prefer the positive way.

So I'd prefer "Is the sun shining" above "Is the sun not shining"

Also keep in mind queries may deliver...

did you try sp_spaceused ? (check bol)

have a look at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=372987#bm373380

With sql2005 you have the advantage of using varchar(max) for concatenating this kind of text-columns.

declare @countsql nvarchar(max)

set @countsql = N'select count(*) from ' + @TableName '

...

I would say it's a proc execution followed by two selects showing the outputparameters in two resultsets of one row with one column and that column is named joehack

use an inner join

e.g.

select @ORDDOCID = '00001'

      insert into B(ORDDOCID,