Re-indexing logs a lot. If the log needs more space and it cannot grow automatically, that is probably why you're getting the error.

I guess your best approach would be a combination of...

I am also re-creating my jobs (which I have scripted).

So far, the only changes I had to make was on jobs that used sp_sendmail. It can be enabled, but I...

Ok, I tried that and it doesn't show anything for me either. I'll post a solution if I find it.

-mr

What type of events are you capturing? If you select Lock:Acquired, it will show you the ObjectID. You can then get the name from the sysobjects table.

-mr

I have a similar situation. We run different applications and most of them require the users to be db_owner.

What I have done in certain cases is make them members of...

Yeah, I had this problem once. The processes were hanging, so I killed them manually and the problem went away.

Rebooting the server might do it.

Did you try restart the Agent?

Are there any active processes hanging?

You can use DBCC SHOWFILESTATS

The column UsedExtents will give you the information you're looking for. Since there are 64K in an extent, the calculation for used space for data in...

Hi Bob,

I am currently planning a migration myself. I am planning on doing a backup/restore migration.

The db users will be restored but the logins will have to be created separately....

Yes, I downloaded BOL.

Thanks ALZDBA.

Try this:

insert

into B ([ID],[Name])

select

left(firm,charindex

I think there's another issue on this question and it's that the original post was asking for ordering the uppercase letters before the lowercase ones.

That doesn't get solved by...

Or, if available, you could use:

SELECT * FROM @demo ORDER BY Name COLLATE SQL_Latin1_General_Pref_CP850_CI_AS

That would give the uppercase preference.

-mr

Somebody asked the same question earlier today. See the answer here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=354813

-mr

No, he didn't mention. I believe the errors he's looking for are not on the database side though.