Forum Replies Created

Viewing 15 posts - 826 through 840 (of 1,136 total)

  • RE: Failed Maintenance Task

    pheww..

    How many errors have you actually got in those logs.

    I would suggest that you run a manual dbcc checkdb on those databases and see what it returns now.

    I have seen...

    --------------------------------------------------------------------------------------
    [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]

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (9/10/2009)


    Classic bad question. Feeling charitable though, ill take a stab at it.

    http://www.sqlservercentral.com/Forums/Topic785337-1291-1.aspx

    What can i say, patience of a saint, if you are always this charitable. There 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]

  • RE: need help running a query to get the current date

    You need to find out what database product that this application is using. the simba driver is a generic driver.

    --------------------------------------------------------------------------------------
    [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]

  • RE: What is a small/medium/large size infrastructure of sql servers to administer

    Paul Monaghan (9/10/2009)


    Hi,

    At my current company I'm one of those 'involuntary DBAs'. Someone who has be thrust into the role as there was a need for it...any they didn't want...

    --------------------------------------------------------------------------------------
    [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]

  • RE: can't add maintenance plan after changing password

    Hilda (9/9/2009)


    I changed the passwords for two accounts: the machine_name\Administrator and the account that it was used to create some databases (i.e. "dbuser").

    One of the things I don't...

    --------------------------------------------------------------------------------------
    [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]

  • RE: Reporting Services version?

    Vishal Singh (9/10/2009)


    Execute xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\Microsoft SQL Server\Reporting Services','Version'

    http://technet.microsoft.com/en-us/library/bb630446.aspx

    HTH

    bear in mine that, the op said the database engine is not installed. checking the web page is easier

    --------------------------------------------------------------------------------------
    [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]

  • RE: EXEC master.dbo.xp_cmdshell 'SET'

    Silverfox (9/10/2009)


    naresh1253 (9/10/2009)


    actually my requirement is as below...

    I have a list of SQL servers, I need to connect to each one of them and get the following details.

    1. The OS...

    --------------------------------------------------------------------------------------
    [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]

  • RE: EXEC master.dbo.xp_cmdshell 'SET'

    naresh1253 (9/10/2009)


    actually my requirement is as below...

    I have a list of SQL servers, I need to connect to each one of them and get the following details.

    1. The OS they...

    --------------------------------------------------------------------------------------
    [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]

  • RE: EXEC master.dbo.xp_cmdshell 'SET'

    I think you will find that, depending on the account you are running it under it will return nothing.

    Are you just after the dns and username, or do you specifically...

    --------------------------------------------------------------------------------------
    [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]

  • RE: EXEC master.dbo.xp_cmdshell 'SET'

    naresh1253 (9/10/2009)


    I am executing below script in SSMS

    EXEC master.dbo.xp_cmdshell 'SET'

    strangely it shows all the values except that what i want...

    USERDNSDOMAIN

    USERDOMAIN

    USERNAME

    but when i run the same in command prompt i.e

    1. open...

    --------------------------------------------------------------------------------------
    [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]

  • RE: SSIS Problem With Checkpoint Settings

    Mike (9/9/2009)


    What can be the cause for the following scenario?

    SSIS package executed by a job fails with the following error

    "The package is configured to always restart from a checkpoint, but...

    --------------------------------------------------------------------------------------
    [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]

  • RE: Reporting Services version?

    gmamata7 (9/10/2009)


    Hi,

    I have installed SQL Server 2005 EE Reporting Services(NO Database Engine has installed.Now how can we make sure that the version of the report server?

    I know for database engine...

    --------------------------------------------------------------------------------------
    [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]

  • RE: SQL Server 2005 Cluster setup questions

    dinky (9/9/2009)


    Env: Windows Server 2003

    SQL Server 2005 Standard - 2 node cluster

    Dell SAN

    I have 2 filegroups (100 gb and 200 GB) for the db and need to setup Active Active...

    --------------------------------------------------------------------------------------
    [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]

  • RE: Am I the only DBA

    Jeff Moden (9/9/2009)


    Shall we know the real name of such a hard working individual that spends time rearranging people's last names to be offensive words? I did initially try...

    --------------------------------------------------------------------------------------
    [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]

  • RE: replication

    ramyours2003 (9/9/2009)


    how to troubleshoot the replication ?

    what are the general issues when replication fails , iam in production side can any one suggest how to handle when a replication...

    --------------------------------------------------------------------------------------
    [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]

Viewing 15 posts - 826 through 840 (of 1,136 total)