Forum Replies Created

Viewing 15 posts - 16 through 30 (of 165 total)

  • RE: Synonym in a view with linked server

    Was on the phone with Microsoft for almost 2 hours and Microsoft confirmed it is a bug. They are not going to fix this anytime soon.

    Please be noticed of this...

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: Synonym in a view with linked server

    🙁 hmmm.

    Thats a bad news!

    Why is this synonym having so much problem?

    I hope Microsoft will have some solution for this.

    Anybody else in the same boat as us here?

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: Keeping backup files that is only 2 days old and delete the rest

    Great! working, never knew that was so easy. Thanks all!

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: Keeping backup files that is only 2 days old and delete the rest

    Back ups are done thru some other third party tool. I am not actually responsible for that. But from our side of the team, we just want to have the...

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: Keeping backup files that is only 2 days old and delete the rest

    Sorry, maybe I asked you the wrong way.

    I know that it is in the management studio and maintenance plan task and all that. But I have those files in my...

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: Memory leak in SQL 2005?

    Well, sorry for that. Did not notice it since it was all the way on top. Anyway, what SQL Server edition? (Enterprise? Standard?)

    Also, when I said RAM, how much is...

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: Memory leak in SQL 2005?

    Did you configure your memory properly during installation of SQL 2005?

    1. How much RAM do you have in that server?

    2. What is your server specification?

    3. Also what is your SQL...

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: tempdb growth

    Hi there talentguy, I hope you have resolved your problem with the tempdb growth. I have had the similar problem last weekend and I executed some update statistics statement against...

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: Keeping backup files that is only 2 days old and delete the rest

    WOW, HOW DO YOU THAT?

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: Finding Lock level of a table

    sp_lock does not give me what I want. I need lock level(page level, role level, table level) of all the databases with their tables

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: DBCC Reindex then ??

    That's a very sweet alternative. It just works fine and with no large logs anymore. I am sure I am okay right now. Thanks for giving me all the thoughts.:)

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: DBCC Reindex then ??

    Damn!! Thanks for that.

    Well, i guess I have to stick with the old plan where I have Full Backup and full recovery. But I am definately taking the transactional log...

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: DBCC Reindex then ??

    Thanks for all these answers above. Not only I have made myself clear, but I have reconfigured the way my database was set to now. I do have a full...

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: DBCC Reindex then ??

    Well, this question regarding Reindex has struck something important for to reconsider about my databases. I am taking a fullbackup no matter what. I do have full recovery mode. But,...

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

  • RE: DBCC Reindex then ??

    Sorry. My recovery model is FullRecovery mode. Got distracted by another thread.

    So, am I still safe with the current plan?

    [font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]

Viewing 15 posts - 16 through 30 (of 165 total)