You might want to look at COM+. It supports role based security and provides some methods you can use in your code to check role membership. You don't have to...

I use VB primarily, some Access, HTML. Probably will move to .Net shortly.

Andy

Not sure I agree about setting a max size, maybe because Im in a small company and can run a looser ship! One thing I do though is keep a...

Sorry, I guess Im still not clear - does it matter how big it is? That's the whole point of sp_refreshview, you can run the alter and when it's done...

Are you doing select * or explicitly naming all the tables? How big can the script possibly be?

Andy

If you've got a query that works it is often easier to create it as a view, then run the report on the view. This has the added plus of...

Check out the view called infoschemacolumns.

Andy

Pretty much everything is in the box. Log shipping only comes with Enterprise edition, but there are scripts for SQL7 that would do the same thing for you.

Andy

You could use a view that returned asterisks, but then you couldnt query on it! How many of your users need access to this info? If you handle setting the...

Typical latencies are 1-3 seconds unless the box is heavily loaded - and that could be either the publisher or subscriber. Nothing wrong with transactional replication, but you probably want...

SQL rarely deallocates memory once it has it. Does it happen gradually or all at once?

Andy

There is not. EM is probably your best choice for simple browsing.

Andy

Chuck, thanks for signing up! I'll try to get a team set up over the next day or so and post the # here.

Andy

I don't do much Access development but a mask can be easily implemented via code in the keydown or keypress event of a control. Doesn't matter where the data is...

Did you try running the alter view statement first?

Andy