Ah... someone dropped the stored procedure?

Then your best bet is to see if you have a backup you can restore to get the procedure or another copy of the procedure...

Alex, check the connection information and ensure that the database you're pointing at has a procedure named STSS_ReleasedEncasements and the authentication you're using to connect has access to execute it.

Add the user to the db_datareader role.

I'm counting down the days until I can get my service away from Sprint. Their whole network is buggy as well (which probably necessitates the many phone calls to...

The first thing I see is that NOT IN is going to kill your performance. It's a pretty terrible statement.

You're better of doing a left anti-semi join (I think...

Yes.

The service pack checks for installed products and updates them accordingly. When you install a new feature, you'll need to apply service packs accordingly to update that...

Is it coming from your connection?

It could be the process which populates the process info window.

This is awesome.

Great tool. I'm adding this to my shortlist of must have SQL Server tools.

I don't think you could do a SQL Server installation because there are registry keys written into the system, etc...

What you might be able to do is do an attach/detatch...

Boy if this was expanded to "miscellaneous desk crap from any database-related vendor" I think I might win. As it is my wife makes me throw out most of...

I ran into this in a certain scenario where the login at the server level was not properly mapped to the SID of the user in the database. What...

I touched on this problem briefly in an article way back when:

http://www.sqlservercentral.com/columnists/aingold/workingaround2005maintenanceplans.asp

Shameless plug aside, I would actually recommend you open up the plan and add a Maintenance Cleanup...

More likely than not, you can't.

Unless you have some sort of auditing set up it's highly unlikely you'll be able to find out who issued the delete statement. I'd...

When you use EXEC it executes in a different context from the rest of the group. Certain objects can not cross contexts (I forget the exact rules). You...

Can you give an example of what the column data might look like?