Forum Replies Created

Viewing 15 posts - 316 through 330 (of 1,136 total)

  • RE: SPAM from user favourkarume11

    Well Mel sounds like you got rid of the sisters, how about the rest of the village/town/city 😛

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 8:19 am

    #1064092

  • RE: Optimize query that calls a linked server [GA2_LINK]

    can you post the execution plan for the query, if you need help in doing that, check the links in my signature at the bottom of this post.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 8:13 am

    #1064085

  • RE: SPAM from user favourkarume11

    Yep , not impressed, especially if my partner saw these emails. if i wanted messages like these i would have joined an adult dating site.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 7:22 am

    #1064040

  • RE: How to change the owner

    I am assuming that you mean the service account that sql server runs under. if that is the case you can do that using enterprise manager.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 5:35 am

    #1063979

  • RE: Suspect mode

    sql_lock (10/9/2009)

    Firstly, have you run CHECKDB on the data base...

    ALTER DATABASE [DBNAME] SET EMERGENCY;

    GO

    ALTER DATABASE [DBNAME] SET SINGLE_USER;

    GO

    DBCC CHECKDB ([DBNAME], REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;

    GO

    Then check the status

    SELECT state_desc...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 5:30 am

    #1063977

  • RE: Full Time Sr DBA / DBD - Appleton, WI

    Oh I dont know, there is that guy from italy ya know, name is erm Olgi perhaps he could go for it.:-P

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 5:23 am

    #1063976

  • RE: Investing In Your Career

    Brad Allison (10/9/2009)

    Education is very important and I too, am fortunate to work for a company who supports it. We get $10,000 per year for tuition reimbursement on top...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 5:15 am

    #1063972

  • RE: Investing In Your Career

    VALEK (10/9/2009)

    Imagine this.. You work in a medium sized company, using MSSQL2005 and nothing else.

    They are very tight on budget, try to be productive, focused and specialised, unlike government orgs...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 5:13 am

    #1063971

  • RE: Proper way to backup databases

    Only think I would add, is that you if you are doing a full backup every day and tran log backups every 3 hours, you could be looking at more...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 4:10 am

    #1063959

  • RE: Confusing schedule Job status

    Why does it say it failed.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 3:51 am

    #1063951

  • RE: How to practise DBA activities on my own.

    As mentioned in previous post, using the sample databases will help you more than generating your own databases. work with the tutorials that are in place for the adventureworks databases...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 3:18 am

    #1063941

  • RE: Can publisher and subscriber set on same database on same machine by 2 different merge replication?

    Chan Wai Yin (10/9/2009)

    Hi,

    Thank you for reply. Our goal is to make 3 databases on 3 different servers can synchronize with each other when any one of the server is...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 3:13 am

    #1063938

  • RE: Security Strategy

    namnl (10/9/2009)

    I used SQL server 2005, my software logged in database by special user.

    Special user?, I am assuming you mean a sql login, what is the OS of the machine...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 2:56 am

    #1063929

  • RE: Security Strategy

    namnl (10/8/2009)

    Hi every body, I had a security issuse and wish for a help.

    I bought software for customer and this software require local database.

    So, i set up database in...

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 2:13 am

    #1063909

  • RE: BI starter

    venki_1276 (10/8/2009)

    Than'Q for your response,

    I need to learn SSRS.

    Try these links

    http://www.accelebrate.com/sql_training/ssrs_tutorial.htm

    http://msdn.microsoft.com/en-us/library/ms170246(SQL.90).aspx

    http://www.simple-talk.com/sql/reporting-services/beginning-sql-server-2005-reporting-services-part-1/

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

    October 9, 2009 at 2:09 am

    #1063907

Viewing 15 posts - 316 through 330 (of 1,136 total)