Not that I know of. What are you trying to do?

Andy

A clustered index means that the table is actually sorted based on the index criteria. Since the data IS the index, it's only possible to have one clustered index per...

Thats not a bad idea, though a bit of overhead to generate them all. Code generator would ease the pain.

Andy

I'd agree that the future of Access is unclear. I love it as a tool for ad hoc data work, never been fond of it for apps. I've used Access...

So far I have not seen any great books on DMO. This one is ok:

http://www1.fatbrain.com/asp/bookinfo/bookinfo.asp?theisbn=1861002807&vm=

MSDN had a pretty good article:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmag00/html/sqldmo0501.asp

And I also have several articles right here on the site...

A universal browse function sounds interesting (and yes, we may have to try it!), but when you try to make a proc all things to all users, you lose the...

Paras,

I've put together some sample code for you, but if I can offer some advice - until you understand the difference between logins, users, and roles, you're headed for trouble....

Good eye on the Top 0 - I was trying to just get an alternative posted quickly and obviously didnt test well enough.

I'll grant your point that my example doesnt...

Cool, counting you and Sean, that makes 2 in the audience for sure!

Andy

I think that when you EXEC it runs under the security context of the caller, not the trigger - not 100% sure of that, have to test.

Could you descibe briefly...

I cant remember the number of users MSDE will allow, I'd dbl check that just to be safe. If you use MSDE an upgrade to SQL is as painless as...

Using SQL Roles - not a complicated idea, but one pretty often ignored from what I've seen!

BTW, if you haven't found at yet, PASS will be rescheduled.

Andy

I received email from PASS yesterday asking if I was still going to be able to attend - they are polling speakers first to see if they have critical mass...

Jon has an article with a different solution posted here:

http://www.sqlservercentral.com/columnists/jwiner/returningasubsetofarecordset.asp

Be sure to check out the discussion associated with the article - some other ideas are presented there.

Andy

Its always between 10 & 6 somewhere!