Forum Replies Created

Viewing 14 posts - 46 through 59 (of 59 total)

  • RE: SQL SERVER 7.0 on WIN2K -- how long supported?

    Mainstream support is over for SQL 7.0 on December 1, 2005. The original date was moved to this date, because 2005 wasn't ready to release to market. As for how...

  • RE: Hungarian Notation To Be or Not To Be

    Thank you all! This has been a very enlightening discussion, and I now have an interesting wealth of information to hand over. I'd like to thank Joe Celko for his...

  • RE: Help Error: 624, Severity: 20, State: 2

    ouch. I've never seen this, but I'll tell you what I'd be doing if I did.

    I'd run DBCC CHECKDB to see if I had any errors. While that was running,...

  • RE: Missing mdf extension for database file

    I haven't looked it up, but Alter,Database, and File are the three search words for BOL that comes to mind. Or if that doesn't do the trick, then a restore...

  • RE: SP_ATTACH_DB - need to update stats when??

    If you were moving it to another database, I'd say yes. If you are just reattaching the database to the same server and you want to take the time to...

  • RE: Performance Tuning ... Pictures Provided

    Also, if the Pages/sec is usually around 0, that means your server is not having to page to the harddrive to service RAM requests. I'd say this was a good thing....

  • RE: Master Console (MSX)

    The plug-in is much better than the 6.5. But I meant Multi-Server Administration option. In 7.0, it was called Master Console. Not a lot of people seem to use it....

  • RE: What is the best way to learn SQL?

    That would depend on which SQL you mean? Microsoft SQL Server or SQL? One is a Relational Database Management System (RDBMS) and the other one is a programming language (Structured...

  • RE: Do Entry-Level Databasing Jobs Exist ?

    I don't know if anyone would do this today, but I started out at help desk, and tortured the Network guys every chance I got to learn networks. Then I...

  • RE: Exec DTS from a NON-SQL Server?

    Phil,

    Never even thought of either solution. Thank you SO much. Both are suitable for their purposes.

  • RE: Exec DTS from a NON-SQL Server?

    Thank you for answering. However, xp_cmdshell isn't available on the originating server because SQL Server isn't installed. Anyone else have any ideas? Possibly a third-party solution?

  • RE: SP3 Sysprocesses Problem

    Thank you! Now I'm wondering about the memory requirements for my Data Warehousing database. I've got 4 GB, and I still wasn't able to get the code for a long...

  • RE: Unowned resource?

    Can you run the statement outside the SPROCS?

  • RE: Unowned resource?

    I got this on a PROC that ran three SELECT INTO statements to temp tables then did another SELECT with JOINS on 2k SP3. I don't remember if it were...

Viewing 14 posts - 46 through 59 (of 59 total)