I am assuming that dbcc Shrinkdb is not making the log file smaller, right? Or is an error occurring?

If the log is not shrinking, it may be because the partitions...

You're welcome and thanks for the followup. BTW, where did you find this?

Steve Jones

steve@dkranch.net

Nice script. Mind posting this to our "scripts" section?

Steve Jones

steve@dkranch.net

Well, I had a short chat session with nasir afridi and here is some followup:

The DDL for the table:

if exists (select * from sysobjects where id = object_id(N'[dbo].[ProductOwnerInfo]') and OBJECTPROPERTY(id,...

Sorry, not really an Oracle guy. I'd start with Oracle, my company (www.iqdestination.com) also has some lower cost e-Learning options. Some of the other guys here have Oracle systems, maybe...

Please let us know if this works.

Steve Jones

steve@dkranch.net

http://www.sqldts.com/article.asp?nav=1,6,208,7

Steve Jones

steve@dkranch.net

http://forum.snitz.com/

Steve Jones

steve@dkranch.net

don't see a way to access this. To even get a reference to the package, you must have the name to load it. Can you not just set a global...

what a knucklehead. I'd say grasshopper still needs to practice grabbing the stone from your hand

When I go on vacation I dread coming back to fix...

You're welcome. Keep coming back and spread the word to your friends.

Steve Jones

steve@dkranch.net

Check this out:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_0t5x.asp

Bug:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q300385

This also might help:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wss/wss/_cdo_idatasource_saveto.asp

Steve Jones

steve@dkranch.net

You can also do something like this:

http://www.sqlservercentral.com/columnists/sjones/tamestrings6.asp

Steve Jones

steve@dkranch.net

Let us know if that helps. Also, what Service pack is this? (SQL and NT)

Steve Jones

steve@dkranch.net

I think Nigel is on the right track. You likely have some corruption in a system table, but it is probably bad data. If you can try some different things...