If the system share was not created with the same account that the SQL Server service is running under it will not see that share. If it is running...

Thanks for the follow up guys.

I do really enjoy your site, especially since thier isn't alot of non SQL content. I think I'm just in a bad mood today...

I don't feel like it adds much value to the site.

When someone asks a question on this site I would hope that they are looking for the best...

I agree,

It's probably best to keep things simple and have all objects owned by dbo. Sometimes we are forced to make things more complex than they need to be.

DanW

...

Sorry, but I don't care what BOL says.

I don't understand why everyone on this site always quotes it?

What I wrote is 100% accurate. If you want to 'change' an...

I believe that certain built in system stored procs have extra permission checks, like xp_sendmail or sp_addlogin. But the SQL Engine itself is not checking the permission.

Only if you make the user a member of the db_ddladmin database role.

Then they could run the following statement:

create table user2.tablename (pkey int)

DanW

Could you link to all required Access databases from within a single main secured Access file. Have the registry key point to the main Access file and then setup...

I believe the proc will fail unless the user has permission to do whatever is called within the procedure. If you create a second procedure that calls your first...

Yes, this can be done regardless of what BOL says. You can trick the system because it only check the permissions of what the view is selecting, not the...

I believe it's an issue because it prevents you from doing the appropriate security logging. Disabling an account is usefull for historically determining when an account was available. ...

I was refering to the MDAC Version not the SQL Version...

MDAC Released with SQL Server SP2 Version 2.62.7926.1

MDAC Released with MDAC 2.6 SP2 Refresh Version 2.62.7400.1

Notice that the MDAC...

It seems that you're right there is no built in way of disabling a SQL Login. I even tried running an Ad Hoc query against the xstatus column of...

Not sure what the specific issue is but I would suggest using SQL Profiler to capture the statement that is causing the issue. Accourding to Books Online it is...

Damn... sounds like you did everything right.

Does SQL show as SP2 on the problem node?

From the microsoft site it show that the version of the MDAC 2.6 SP2 Refresh has...