impenetrable

Cool. At least you are past the user creation.

Good luck.

Mostly yes.

If there is corruption in...

andrew gothard (7/21/2014)

---

SQLRNNR (7/17/2014)

---

Jack Corbett (7/17/2014)

---

Sean Lange (7/17/2014)

Sadly I will not. I need to find a way to get to one though. It is a large chunk of...

Wow - 9 years ago even.

Here's a Microsoft document on things to try.

http://support.microsoft.com/kb/283849

Skip down to the section labeled

Steps for trying to repair a damaged database

What are the errors you get when you create your login?

Or are you trying to create a database user directly in the database and not have a login?

Or are you...

LutzM (7/19/2014)

---

Seems like there are some views involved since there's no reference to Tbl1008 in the code you've posted.

Most probably the underlying data structure has changed without notice (as usual...

Deny select doesn't work for the system functions. And you can't deny execute on the functions such as @@servername because it will invoke an error.

I don't see any documentation...

I don't know why you would cursor through to delete a Log one record at a time.

Why not change it to a set-based approach?

I wonder if sql auth is even enabled. 18456 can be thrown (commonly) when sql auth is disabled.

Even with SQL Auth disabled, you can change the sa password. ...

So you ran shrink from the GUI instead of from a command?

Do you know how to "kill" a command? Same command to kill the shrink.

Have you checked for any...

Ok, we all know Mad Max.

But what movies are those other characters from?

Are you trying to shrink out all 300GB of space?

Next question...

Why shrink? This fragments indexes severely and will likely cause the database to need to grow when you defrag...

That is a good idea there.

Another good source of material is the SQL Saturday events. There is good material with...