Recent content by TheSQL

Hey - the drop and recreate worked. Looks like something was just buggered up in the metadata. Thanks much for your help.

Sorry, I should have specified, it's SQL 2005. Evidently for SQL 05: Is there an 05 equivalent? I was going to try dropping and recreating the functions in the interim....I'll let you know how that fares as well. Thanks for your help so far!

Maintenance plan history. Run through Query Analyzer, I get the following: DBCC results for 'ProductionDB'. Service Broker Msg 9675, State 1: Message Types analyzed: 14. Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. Service Broker Msg 9667, State 1: Services analyzed: 3...

The full text of the error is as follows. I don't see any repair levels - am I missing something? Executing the query "DBCC CHECKDB WITH NO_INFOMSGS " failed with the following error: "Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1723361404,referenced_minor_id=1) of row...

Hello, I'm encountering an error using DBCC CHECKDB on a specific database. The error test is as follows: Executing the query "DBCC CHECKDB WITH NO_INFOMSGS " failed with the following error: "Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1723361404,referenced_minor_id=1) of...

That was good for a laugh. I spent about an hour reading all of the responses to this post the other night. It's a pretty good debate, presenting some lucid (and not-so-lucid) points about the pros and cons of each, for whoever may be interested. Enjoy. Though my lawyer advised me not to...

In SQL 2005 the syntax would be: SELECT [name] TblName, modify_date FROM sys.tables SQLSister is right. It can't be done in 2000, unless I'm grossly mistaken.

George beat me to it. ;-)

CREATE TABLE TblRowCount(TblName varchar(255) NOT NULL, RowsCounted int NOT NULL) sp_MSforeachtable @command1="INSERT TblRowCount SELECT '?' TableName,count(*) from ?" SELECT * FROM TblRowCount You could do it without the create table bit, but I'm assuming that you want to do something...

I'm working with a database wherein someone has created two indexes on exactly the same column. The column is the primary key - the first index is clustered, the second is non-clustered. Both are single-column indices. I'm trying to think of a valid reason why you would need two indices on...

Not at all minor - good point. It's easy to forget which forum you're posting into!

Based upon your example, it looks like you're trying to delete all but the max area, for a given parcel. Is that correct? Running on that assumption, this would work. (We're using MyTable because I didn't see a table name). DELETE MyTable FROM MyTable LEFT OUTER JOIN (SELECT Parcel...

Let's say that A, B, and C are the key columns.... INSERT INTO ABC SELECT * FROM DEF LEFT OUTER JOIN ABC ON DEF.A = ABC.A AND DEF.B = ABC.B AND DEF.C = ABC.C WHERE ABC.A IS NULL ABC.A will only be null where the keys don't match (ex. where the record isn't already inserted). Hope this helps.

Hi Ettienne, Thanks for the quick response! It's not normal for the upgrade to force revenue recognition, in my experience. Have you run into the forced recognition before? I could always have the revenue and billings processed prior to running the upgrade, if I was a little more confident...

Has anyone done a PJC upgrade to 5.4 yet? We're working on one right now - the upgrade is mangling the data...messing around with project statuses, clearing out WIP...all sorts of nasties. Thinking it's <groan><rolleyes>data corruption</groan></rolleyes>, but it would be nice to know how...