Forum Replies Created

Viewing 13 posts - 1 through 13 (of 13 total)

  • RE: Dynamic Grouping in SSRS Reports

    Hi Andy

    Although I am not new to SSRS I still find things a bit puzzling sometimes, mainly the terminology. I felt your tutorial was very good, however, would it...

  • RE: Access form fileds update

    Thank you PrrofOfLife I will try that scenario

  • RE: SQL 2005 instances

    Nakul Vachhrajani (4/4/2011)


    The SQL Server Configuration Manager will help you get rid of the alias.

    As far as pointing out code issues, yes, Profiler is one of the tools that you...

  • RE: SQL 2005 instances

    Nakul Vachhrajani (4/4/2011)


    No wonder you cannot find DB1 as a separate server - both DB1 and DB2 are aliases of each other!

    Is there anyway we can get rid of this...

  • RE: SQL 2005 instances

    Gianluca Sartori (4/4/2011)


    Well thats it, from what I find they are both the same database instance.

    Does DB1 server have a process named "sqlserver.exe"? If not, no SQL Server instance is...

  • RE: SQL 2005 instances

    Nakul Vachhrajani (4/4/2011)


    Is DB1 a mirror of DB2? Go into SSMS -> connect to DB1 & 2, navigate out to Server Objects->Endpoints->Mirroring endpoints.

    Mirroring Endpoints show blank

    The other possibility is that...

  • RE: SQL 2005 instances

    Gianluca Sartori (4/4/2011)


    OK, let's start from the obvious: if there's a SQL Server you can connect to on DB1, there must be an instance of SQL Server running. I don't...

  • RE: SQL 2005 instances

    Gianluca Sartori (4/4/2011)


    We have two instances on our SQL 2005 setup, DB1 and DB2 to name them. Each instance have the exact same databases / tables. When data...

  • RE: Transaction Log

    Is it safe to run CHECKPOINT anytime?

  • RE: Transaction Log

    I beleive we are. Would it be sensible to apply a job to issue a CHECKPOINT every so often?

  • RE: SQL 2005 Transaction Logs

    The DB is 43gb. I have now managed to shrink the LOG file, thanks to your instructions and it went down to 100mb.

    I did not have the room to...

  • RE: SQL Agent90.exe

    Thank you all for your help...it now makes sense

  • RE: SQL Agent90.exe

    Yes your right...2005...slip of the keyboard.

    Sorry, these are images running in the Windows Task Manager. For each instance there is an aimage running...is this normal?

Viewing 13 posts - 1 through 13 (of 13 total)