ACCESS DENIED is usually a permissions error.  Can you open up \\wwcd\test\filename.xls outside of Query Analyzer?

I agree with RGR'us.  It sounds like you would be better served using one column to make this work.  Otherwise, you would have to program this into the table triggers. ...

No maintenance plan?? Does that mean that there has not been a backup of you DB in 18 months...Ouch!  I agree with Vladan.  The most common cause of EM hanging...

You should not have to re-build your non-clustered indexes manually upon rebuilding your clustered indexes.  If you issue a DROP index statement on a clustered index, SQL Server will automatically...

If your select statement cannot find a match, then SQL Server will not execute the line following the IF Exists statement.  You may want to place a BEGIN after your...

Ah, a fellow Progress/SQL Server guy....I thought I was the only one!  At my last job, I was a DBA for Progress, SQL Server, and Oracle.  I have not had...

Leave your stored procedure as-is.  Change your application to first determine if the user is a customer or a worker.  If it is a customer, leave your logic alone and...

It is difficult to fully analyze these queries without knowing which indexes you already have on your tables.  One thing I would recommend doing is taking these queries, placing them...

Enterprise Manager is not the best place to make this type of change.  You've proved this by capturing the actions that EM performs on your table simply by changing the...

If it is a VB6 exe, it doesn't matter if you have VB or .net loaded on your workstation.  Everything the application needs to run should be included in the exe...

It could be an issue associated with the user rights of your SQL Server account.  See MS KB:

http://support.microsoft.com/default.aspx?scid=kb;en-us;840219

I like fhanlon's idea of scripting osql commands into .bat files.  This not only makes it easy for your operators, it allows you to control the process.  Using a .bat...

Can you post your whole Stored Procedure?

You may want to try to look through sp_who and sp_who2.  I think there is plenty of logic built into those guys that you could strip out and use to...

I don't know if named pipes uses different ports, but an easy way to determine this would be to have someone watch your firewall as connection attempts are made.  This...