Two ways spring to mind.

1) When the application sets the deleted flag to 'Y', why doesn't it set the deleted date as well as part of the same transaction?  This...

Try this:

select top 10 * from information_schema.routines

where routine_type = 'procedure'

and then refine to get the fields/data you want.

What error message do you get when the browser won't connect?

Can you still ping external addresses?

If you stop the SQL Server service, does it fix the problem ... are you...

In the interests of referential integrity, you'll probably need two delete statements.  The first will delete the relevant invoice lines and the second their corresponding header records.

(Not sure quite why...

You need to use aliases ... effectively creating two instances of the TeamList table and then using them as if you had two separate (but identical) tables ...

select team1.teamname,...

Query Analyzer (one of the SQL Server client tools) is the standard development environment for views, stored procs etc.

Not so sure that many guys in this forum think that EM...

If the answer to Jeff's question is that column 1 is unique and ascending (as it appears from your example), I still can't think of a quick way of doing this ......

In my opinion, it would be much tidier and easier to manage all of this if you keep all of the data in SQL Server rather than mixing your db...

Good question and one which I've considered in the past.  Seems to me that you have to limit direct access to the database (keep the only authorised users / roles...

Wow, that's a busy server – Terminal Services, SQL Server, C# development, SQL Server development and SQL Server admin!

As EM and QA work well from other PCs/servers, why don't you just...

I think you are summing across the entire resultset – so you will get the same numbers every time.  You need something more along these lines:

SELECT Merchant.MerchantId, Merchant.MerchantName, DefinedPaymentDistribution.DistributionName, PaymentType.PaymentTypeName,

Check out this link – it may help you out.

http://www.sqlservercentral.com/columnists/sjones/tamethosestringspart7.asp

There's probably a really elegant way of doing this. This isn't it, but it works 

select '$' + convert(varchar(30), cast(amount as money),1) as Formatted_Cash ...

replacing 'amount' with...

I think I would go down the multiple job steps route.  If any of the jobs fails, you'll be able to identify more quickly exactly where the process is going...

This will get you some of the way - it works in the current database, so you'd need to iterate round all the dbs you need to check.

SELECT table_catalog, table_name,...