If I understand the question, it sure sounds like a similar issue. If your SQL Server is running under the local System account, it might not have access to the...

Echoing Gail, I'd like to get my 2008 skills to an adequate level. Also, I intend to try to present at PASS this year. Other than that, learn, improve, grow...

We ran into a problem recenlty where an app was leaving open connections and open transactions that were filling tempdb. You might look for old open connections, especially since it's...

Don't try to compare what you know to Itzik. I've taken his advanced tsql class twice, read tons of his articles and his books and gone to his lectures at...

Hey Sandy,

We are actually, for the moment, not looking, but only because we took on a consultant after spending a year trying to find a senior level dba. It's...

Reading this made me think of my red-neck, hillbilly inbred cousin who said, and I quote, "If they don't have it at Wal Mart, we just don't buy it."

So, assuming...

EXEC @ReturnValue = procname @param='value'

We use this in a pretty common fashion with the added code:

IF @ReturnValue <> 0

BEGIN

--handle the error

It works under the assumption that the procedure is going...

Normally I'd say "Sure, just create a stored procedure" but since you don't use them... yes, you can do this from a VB app. You simply have to have a...

I'm assuming a regular backup and restore to a different location are off the table?

You could do a snapshot backup which are nearly instantaneous but to restore from one of...

I'd be cautious about using the temp tables because it's going to smack tempdb pretty hard. Since this is basically a paging query (give me page 1 (records 1-300), page...

To get the file names for all 120 log files, you'll need to run some type of query to pull them out of sys.database_files. If you just wanted to truncate...

Just a bit of a gui glitch. You really can not edit those procedures.

Be very careful where you install it. In other words, don't do what I did. I'm going to have to reimage my laptop.

You can also go here to use virtual...

It did irk me to see backups as a myth because we regularly test our backups by restoring for development and as part of training. That's one point that is...

Oh yeah, code reviews... and beatings... I forgot about the reviews.

One other option that occurred to me (besides more beatings) was that you could set up the security in the...