Is there a limit to the number of connections that can be made by a single account or from a single location with Unisys? Also, could be a limitation within...

Just keep in mind to test 2.7 with the components as a few things were removed and may inadvertently cause issues. If they test clean then have the developers also...

Or use FoxPro to puul the data and break into individual files based on file size. By keeping a count on the ADO recordset when moving thru it you will...

It can be done my referencing tha name of the role instead.

Ex. I created a role vowner and put a user measme in it.

When I do

CREATE VIEW vw_test1 AS

SELECT...

First off I have thought about this quite a bit. The answer is for the sake of performance always (especially with SQL) look for a relation method. However, that said...

Follow Brian's advice and either rebuild the server or restore from a system backup or ghost image. I had another developer try to remove by hand and got nothing but...

You apparently downloaded the non-MSDE version of the SP.

Goto http://www.microsoft.com/sql/downloads/2000/sp2.asp and pick the appropriate language you need. On the next page you will find it is the third download...

I just got a copy and will be running on my test environment. It does have encrytion. Any thing specific you are curious about as I will be testing for...

Check constraints are highly recommended always over FK constraints for specifically for performance, especially in high transaction environments. Check constraints are easy to alter and like anything you should always...

Yes there are some major errors in the original documentation.

Check the Event Viewer Logs. I know I have seen this before but cannot rmemeber what the details were. But I do beleive there is additional info related to this...

Checked it out and nope it is not allowed. Like I said I hadn't tried it just a thought.

The only other thing that could do it would be to use...

What specifically are you doing and what are the expected results?

Do however keep in mind that size and overhead for checking the data with that solution.

It would be better if you just disallow edits after initial edit any. Inserts only,...

sp_refreshview

From BOL

Refreshes the metadata for the specified view. Persistent metadata for a view can become outdated because of changes to the underlying objects upon which the view depends.