I'm feeling just a little bit sarcastic this friday night...

http://www.sqlservercentral.com/Forums/Topic922329-146-1.aspx

Would you like fries with that?

This editorial from yesterday may be of interest. http://www.sqlservercentral.com/articles/Editorial/70267/

We're happy to help, but not to do the entire job for you. In addition, this...

but it won't.

If he had not truncated the log, it would, and then it would...

No.

The key fact here is this:

his database was set for full recovery mode and he truncated the log daily after the differential backup as the TL (naturally) was growing...

What are objects 226099846 and 210099789?

SELECT object_name(226099846)

SELECT object_name(210099789)

That error's not repairable. This is a 2005 server? CheckDB has been succeeding until recently? I ask, cause this is usually the result of someone doing ad-hoc direct updates to...

However a loop join to join 16...

This works for me

DECLARE @table sysname, @where VARCHAR(100), @sql NVARCHAR(500), @record_count INT

SET @table = 'sysobjects'

SET @Where = 'xtype = ''u'''

-- Do the work to get the record count from the...

Stefan Krzywicki (5/14/2010)

---

Whenever I do a search I immediately turn off scripts and forum and do the search again. I want to see articles and blogs first and if I...

Apparently he's actually a very nice guy and the...

I would suggest contacting Microsoft's customer support. I have no idea what's happening, I asked a few others if they had any idea, also nothing.

You're updating the entire table, hence the entire table will be locked for the duration of the update statement.

Shivrudra (5/14/2010)

---

In MS-SQL Server all DML statements are:

1.Auto committed

2. Need to be committed with commit command after transaction.

3.Each DML must be preceded with BEGIN TRANSACTION

4 None...

Do you think that EXEC and CAST (@var AS varchar) are allowed?

I would suggest some work on the search and on the organisation of the articles and scripts. To be honest, the site's search seems almost useless, I get better results...