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...

Differential base... And so I learn a new term (that I arguably should have know before this).

Thank you again, Gail. You are a star.

I know that. The chain that was broken was between the differential and the...

jk_in_San_Diego (12/5/2013)

---

Once upon a time, in the dark ages of printed textbooks and such, plagarism was not only frowned upon, it was cause for immediate dismissal or expulsion from university.

To...

Samuel Vella (12/5/2013)

---

Brandie Tarvin (12/5/2013)

---

One thing most people don't realize is that quoting an author's work, and attributing it properly, might not be plagiarism but it is still copyright infringement....