Forum Replies Created

Viewing 15 posts - 33,361 through 33,375 (of 39,736 total)

  • RE: Weird database name in error log

    That is strange. Never seen that. The Autoclose will result in this message, but not sure why you'd see this with no dbs having those names.

    Check master.dbo.sysdatabases to see if...

  • RE: scripting out DDL for a blank database schema

    I've usually had EM script fine, but I'm not sure if I've done hundreds of tables. I usually have everything in one script.

    One thing you could do to debug...

  • RE: Decisions, Decisions

    Thanks for all the comments. I think I'm leaning towards a Nokia. I don't do a lot of email/data entry/web, so not sure I want a Windows Mobile, but I'll...

  • RE: SQL and Mc Afee

    Try connecting with Data Sources in control panel and see if you can get a test connection to work.

    Also, how are you specifying credentials. Which server name is going in?

  • RE: Database Boot Page and MinLSN

    Karim,

    I think you might be the smartest DBA in a few months if you keep this up

    The boot page, I suspect, is what...

  • RE: Stored procedure modified date

    Is this SQL 2005? I thought they fixed this but perhaps not.

    In SQL 2000, there definitely is no way to determine this. I used to schedule a script to load...

  • RE: Log Shipping Error

    No idea here. You might need to call PSS, but I suspect they'll tell you SP4.

  • RE: How does SQL Server 2000 decide when to grow the DB?

    I'm not 100% sure, but it seems that it grows when it needs the space. In other words, you can't set it to be at xx% left. If you always...

  • RE: Migration from 6.5 to 2000

    Also, are you running your server in 6.5 mode or 2000 mode?

  • RE: CPU Utilization

    WMI is probably the best way. If you cannot get access, can you setup PerfMon to get this information and log it?

  • RE: QA DBA

    I've never had a QA DBA, but I suspect it would be someone to apply the T-SQL (DDL and DML ) changes to QA and then production. Examine the code,...

  • RE: Backup fails when trying to remove old backup files

    I'd guess some type of backup grabbing the file. Any delay would cause SQL to fail as it's very intolerant of delays.

  • RE: Need to create a "fancy" Database Diagram

    Don't know any free ones. If you have Office Pro, Visio will work.

    Paint I guess

  • RE: query problem

    select a.orderid

    from ordermaster a

    inner join orderdetails b

    on a.pk_orderid = b.fk_orderid

    where b.orderamount (select sum( c.orderamount)

    ...

  • RE: CPU Utilization

    You can store perfmon output to a file and look at that.

    What are you trying to accomplish?

Viewing 15 posts - 33,361 through 33,375 (of 39,736 total)