Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TheSQL

    DBCC CHECKDB Errors

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

    DBCC CHECKDB Errors

    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!
  3. TheSQL

    DBCC CHECKDB Errors

    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...
  4. TheSQL

    DBCC CHECKDB Errors

    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...
  5. TheSQL

    DBCC CHECKDB Errors

    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...
  6. TheSQL

    New to SQL

    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...
  7. TheSQL

    Table schema modified date

    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.
  8. TheSQL

    count(*)

    George beat me to it. ;-)
  9. TheSQL

    count(*)

    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...
  10. TheSQL

    Dueling Indices

    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...
  11. TheSQL

    Querying out the largest value?

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

    Querying out the largest value?

    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...
  13. TheSQL

    Something like Select Distinct on multiple keys

    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.
  14. TheSQL

    PJC Upgrade to 5.4

    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...
  15. TheSQL

    PJC Upgrade to 5.4

    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...
  16. TheSQL

    Explanation as to how this function works

    S/B Under Tables or Views.
  17. TheSQL

    Explanation as to how this function works

    Action isn't a system table or view name, so it's an object that's been created in the database. You should qualify it(ex [Action]) to avoid confusion. Action is a property used in SQL-DMO backups...I'm not sure if it's used anywhere else. Generally, the statement is deleting records from the...
  18. TheSQL

    Combining two tables effectively

    SELECT rb.Number, rb.StartTime --Add in whatever else you want to select FROM room_bookings rb WHERE rb.Number IN (SELECT NUMBER FROM booking_clashes) Hope this helps.
  19. TheSQL

    Query Browser Equivilant

    What does query browser do? I would imagine it's where you create and issue queries? The equivalent would be SQL Query Analyzer.
  20. TheSQL

    transaction log management

    You need to stop whatever application is accessing the database from connecting to it. Then issue the "BACKUP LOG MyDB WITH TRUNCATE_ONLY" command...that will set a checkpoint in the log, after which DBCC shrinkfile should shrink the log for you as expected. I find that the GUI works less...

Part and Inventory Search

Back
Top