Unfortunately, no.  For you to admin the cluster you need to be admin.

If that is your criteria THEN

DISALLOW ANYONE the ability to CREATE anything and leave that to the Administrator ONLY.  That is the only way to do this that I...

Have you tried

SELECT t1.Whse, COUNT(*) FROM

  (SELECT DISTINCT Whse, Batch FROM NameOfTableHere) t1 GROUP BY Whse  ????

Well, this was fun.  This was kind of like taking a test.  I take the data given provide a result and the only person that likes it is Frank

What if your SQL server fails over or fails period.  With the Admin tool you can go in and see where the resources are.  Otherwise <throw dart at wall and...

DECLARE @StartDate CHAR(10)

DECLARE @EndDate CHAR(10)

SET @StartDate = '01/01/2005'

SET @EndDate = '31/01/2005'

SET @StartDate = RIGHT(@StartDate, 4) + '/' + SUBSTRING(@StartDate, 4, 3) + LEFT(@StartDate, 2)

SET @EndDate =   RIGHT(@EndDate, 4)...

I don't think so.  Why do you want to DISALLOW someone from DROP of an object they CREATE?

AFAIK possible YES, practical NO.  You will need to research BOL, microsoft site (probably even here) for the list of specific dll's, ini's, possible registry entries to make this possible.

What are you trying to accomplish?  If you can provide that we may be able to help you better.

We have this problem as well.  What we have done is created a script that removes all users (except for sa) and re-adds the correct ones. of course this still needs a...

If you just want the indexes, PKs, etc...  Just uncheck the DROP\CREATE tables check boxes

Why not call usp_Umbrella which inside would do:

EXEC usp_Maintenance1

EXEC usp_Maintenance2

etc..... 

Well, (based off of this) you are NOT stupid or crazy (of course NOT medical professional if you think you may be please contact local doctors

Without knowing HOW you set up the table (indexes, row count, etc..) it is impossible for us to even GUESS.

However, IF you hit CTRL+L inside QA it will provide you...

1 of 2 options are the easiest

#1  LINK the SQL table in the Access database and then create a query there to load data

#2  Research LINKED SERVER in BOL and...