I wonder if something went wrong in my installation.  I'm using the evaluation version.  I installed it on my laptop, uninstalled it, then 2000 enterprise mgr quit working so I reinstalled...

I also like this query to determine which cluster node an instance is running on.  This shows the logins that are connected to master db.  Look at the 'host name'...

Well, without foreign keys I'd say you don't have any referential integrity to check.  I assume your RI is enforced by appliction code.

I'd say your options are to check your...

Not sure what you mean my 'searching options'.  Are you referring to ways to select data from tables?  Or ways to search for things in SQL Server?

Very good.  Thx

I'd like it for all databases on the server, but there are only 9, so executing sp_helprolemember 9 times is not a problem.  Thanks

If your SQL box is part of a cluster, go into Cluster Administrator, right click the properties for the SQL Server resource and make it dependent on all disks you...

Also, if you only need the 'user' part of 'domain\user' -

select right (system_user,len(system_user) -charindex ('\',system_user)) 

Thanks Joe.  I tried that and it worked great.  Yes, I needed to leave the old key unchanged if there is no input value to change it to.

I had never...

I, like the last poster, come from a mainframe, procedural background, so I automatically think that way. 

Recently someone came to me with the need to change many employee IDs,...

I have to ask the question - why do you care which row contains the first occurance of a value? 

in a relational database the order of rows in a...

I would suggest creating 8 indexes, one for each of those columns.  However the users query, SQL should use one of those indexes. 

If you know that they will frequently...

Have you looked in Event Viewer on the server?  Look in the Application Log.  Sometimes you'll get more descriptive info there.

Point to Master in QA and execute this.

select * from :: fn_virtualservernodes ()

That gives you the physical names of the cluster nodes.

-Ken

The previous suggestion is what we use.  You don't have to export and apply registry files.  You just set up the registrations on a central server and have all the...