Thanks for posting your solution Paul!

cast is real handy for moving one datatype to another.

Wes

for those who want to know...

http://support.microsoft.com/support/kb/articles/Q306/0/34.ASP

this was the error we were having. All is well now. We did this in test and it worked. We will roll it...

I personally liked netIQ for our MS-SQL boxes. With the new version you should be able to monitor all your boxes UNIX or MS alike. There is alot of flexability...

You can always make the db under sa and then give the customer dbo rights if they need them. We have some of the same issues here. Let us know...

I'm not sure I understand the question completly. One, if you run an A/A setup you are really running two sql servers that can fail over to each other. Thats...

I've used NetIQ and HP Openview to do this for us. Both will restart sql server if it dies and the box is still running. Other that that I would...

not that I have seen. I go out to MS-SQL website at least once a week.

Sorry, Correction If it is an enterprise lic you are covered for multiple instances. We just got tagged here for running standard and multiple inst on a single box. So,...

One, If you are worried about lic problems be aware that every instance has to be lic properly per proc or per seat just like any other sql server. So,...

sure.... It falls right in line with my work schedule you know 24x7.

Wes

and this ask for a port like 1433? or is it a RPC port?

Wes

The session expires and doesn't re-auth properly. they will have to log out of the application and possibly their machine. The client program should detect for an open state and...

We set up a fed cluster in the lab with 5 pc's it is pretty simple to setup its making sure all your data that you need is local to...

There is no "quick" tuneing for a EMC SAN. There are ways you can spread out the data among several spindles to increase performance. I would talk to your local...

I fyou go into the client network utility there is a place to remove all other protocols besides TCP/IP and then set that to 1433. As far as the cluster...