Thanks Larry,

It turned out that after a reboot everything seems to be working great. Not sure what hung but we are watching a set of trials on our development platform...

I just upgraded my BOL to the new SP3 version.

Prior to upgrading the title bar was "SQL Server Books Online" and the version indication on the Getting Started --> Microsoft...

@@servername returns server name

login information can be returned by the following. Note, each returns a slightly different piece of information. Each one is useful depending on what you are looking...

OK much research on the question has resulted in the following...

I do have a SQL Server 2000 version of BOL installed on my machine. (SQL 2K is the only version...

Frank,

I tried to find what version of BOL I am running here and was unable to do so.. If you can find out how - I will determine my installed...

Frank,

I followed your directions to the page you quoted by going to the Index Tab of BOL and going to stroed procedures --> parameters --> and the specifying a Data...

So answer "F" bang head on desk for not remembering that Advanced can't support that much RAM.....somedays you bite the world - somedays the world bites back....