I guess I am confused by what you are terming "running status"  Does this mean the job complete/fail??  IF yes you can check sysjobhistory.....

you can also (not the best idea) build your own.  Windows OS comes with several different ways of checking SC.exe being one of them...

Why cant you check sp_who2 to see what is running??

I assume that you are attempting to login with a SQL account?  Sounds like the server is in Windows Mode only and will not allow SQL accounts.

There is a thread...

I have done it before.  You have to write your entire statement to a variable and then use sp_executeSQL to process it.

With that said IF I knew then what I...

Have you tried adding -E to the osql statement (trusted connection) or         -Uuserid -Ppassword

please see posts to same question at:

http://www.sqlservercentral.com/forums/post.aspx?forumid=145&messageid=152133

Why can you not create the Foreign keys on a new table and then drop the old AFTER changing the view?

Again the problem is as follows

1. NEW Data loaded monthly
2. 100% uptime
3. Access...

Another way to skin same cat is to create a UDF that will return the value you are seeking...

Yes,

1. Create a table and store the global variable in it
2. Create a UDF and return the global variable

OK how bout this way to skin the cat.

NEW Table PER MONTH.  Why?  Glad you asked...

• You only show NEW data
• You modify the view monthly (I assume manually)
• The NEW data arrives...

Believe it or not they are MS papered in VB, SQL, ASP, etc... MCSE, MCAD, ...

Another GREAT reason why PAPER alone is not a good reason to hire...

I would get with a server engineer that is responsible for that cluster and ask for their help.  Opening Outlook on PASSIVE will buy you $0.00.  The SQL instance won't...

To help ease Frank's pain..

I am tasked with "enhancing" several of our VB6 applications.  the one I am currently playing with has the following:

• written by 3rd party contract company
• ALL variables...

Dorothy,

You need to ensure that Outlook is ALWAYS open regardless of which node is currently ACTIVE.  An oldie that got re-introduced with Windows 2K3.  If you want to move...