I've made a couple of assumptions... calling your table or view "TRX" and assuming that the [record] field is unique. You can try something along the lines of:

select [Record],[Type],[In],[Out],
   ...

David,

I don't think log shipping every 15 minutes is all that unreasonable provided a decent pipe is used.  Log shipping at that frequency will only impose a several K overhead...

Being lazy, I usually just edit such jobs and change the owner to sa.

Before doing the tricky bits, have you profiled the statements that are timing out and run index tuning wizard against them?

I think I may have got this right by assuming the references to "physical database name" and "logical database name" were supposed to be "physical file names" and "logical file names"...

Do you notice any improvement from specifying port number (1433?) rather than dynaically determining the sql server port?

Try:

  dbcc showcontig with tableresults, all_indexes

If triggered by an INSERT there'll be no rows in the DELETED table.

I guess one way is to run SQLSERVR.EXE -f -m and grab the single connection immediately with Query Analyzer.

At this stage Task Manager's Processes tab whould show something like 20 in...

well... um... er...   I don't really know what those parms do.  I guess the first says the depth you want to go down...

Phill,

xp_dirtree combined with xp_getfiledetails may do the job for you.

eg. EXECUTE master.dbo.xp_dirtree N'C:\TEMP\', 1, 1

one of the columns returned will say whether the entry is a subdirectory or a file.

To...

Yes, it's encrypted in the master database with the internal pwdencrypt function.  It's a one-way encryption (there's no pwddecrypt function).

Note: if you have registration settings for Enterprise Manager that use standard...

is your database set to autoclose?

James,

If your product database is not too big and the varchar/text fields aren't too big and the searches can be satisfied with LIKE clauses then that could be the way...

I can't beleive 9 people (so far) have chosen that answer.