There shouldn't be any impact, because no one should be using 'sa'. But if anything is using 'sa', it will fail.

When I first started at this company, 'sa' was...

Doesn't look like you have any free space to shrink.

Did you "Enable Mail Profile" ?

Frequent transaction log backups can help manage log growth.

AP = Accounts Payable

They are a specialized group in our company for hacking into certain products 🙂

How much free space is in the .MDF and .LDF ?

I had Redgate for a 14 day trial. I was able to crack it and use it permanently by generating a PO and then following the steps through our AP...

Is that the message in the job history ? Are there error logs being written out ?

In what way are you unable to shrink ?

Why do you want to shrink ?

It looks like you...

I think the idea is that although Windows has "marked" it as deleted and available for re-use, a recovery tool can read the sectors marked as deleted and rebuild the...

Did you check the Recycle Bin ? The little bit that I know is that you should refrain from doing any writes on the affected drive so that a recovery...

You could search your SPs for the table name. It won't tell you if the SPs are used, but can be helpful in general.

select name, crdate, CHARINDEX('TableName', definition),substring(definition,CHARINDEX('TableName', definition)-25,150)...

This topic has been covered many times. Search "Delete Duplicate", and get pages of threads such as these with different methods.

http://www.sqlservercentral.com/Forums/Topic652644-338-1.aspx

http://www.sqlservercentral.com/Forums/Topic825096-338-1.aspx

http://www.sqlservercentral.com/Forums/Topic403032-338-1.aspx

A job has started that requires a lot of CPU