Yes. Please post this to the appropriate forum for your SQL version under Business Intelligence or General. This is not the proper forum for this quesiton.

Chris Wooding (4/1/2014)

---

Granting execute on the schema has worked in other databases. Is it because this user is part of domain users and therefore only using those permissions rather than...

Odd question. Is there perhaps a database trigger that is rolling back any attempts at A) Executing this proc, or B) deleting data from this (or all) tables?

I think Lowell's on the right track here. It seems the jumping around has a lot to do with your issues.

If you are able to impersonate the login using this...

Is there any other information in the error you're seeing?

I've run into this issue when the procedure is doing activity that requires higher level permissions (such as Truncate Table), but...

I started off using 1024, but the math still doesn't work out correctly for what I'm seeing. (FYI: I got the 128 from a couple of different blog posts. Here's...

The subfolder properties don't tell me if compression is on for them. I experimented...

Ah. I think it didn't uncompress the subfolders. The root allows me to restore the database files there just fine.

So, nevermind. Thanks for reading.

Thanks.

Well, it's MS Access actually. We have linked tables and macros pulling data but we're about to retire a server and move to a new one. So the process works...

Given that the service account should be in sysusers, and that page you referenced updates based on userID, I would say that yes, you can do exactly what you're thinking...

I did notice that Object Explorer and the...

GAH. Dup post...

Lowell (1/10/2014)

---

I believe there was another recent thread that said scheduled jobs that are executing use "Microsoft SQL Server Management Studio", i believe, which was very misleading, since it's not...

To add to what Gail said, the ONLY 2 reasons you should consider shrinking TempDB would be:

1) A runaway query that has caused TempDB to grow exponentially beyond the usual...