Forum Replies Created

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

  • RE: Temp Db drive crashed

    Actually I do not have those mdf and ldf files to put back

  • RE: Updating Publication

    Thanks Roy for your comments. But will the data get in sync with the approach you mentioned? I tried but the problem, data is not getting in sync.

    Ziljan

  • RE: Server hanged while generating Snapshot

    Thank you so much for your response. Backup and Restore seems like a good idea but I have to add new articles to the publication, and hence generate a new...

  • RE: SQL server not taking assigned memory

    Thanks Mauro and Brandie for your comments. The server is 64 bit and the OS is recognizing the memory. It showing what the system has.

    Thanks again.

  • RE: Index Fragmentation Problem

    ALTER INDEX

    REBUILD WITH (ONLINE = ON)

    actually helped to defragment most of indexes in my databases, but when I tried this query in one of my database,...

  • RE: Emailling result set.

    Thank you so much for your reply.

    I tried to use the script but it gave me the following error.

    Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 42

    profile name is...

  • RE: Unable to launch Activity Monitor

    Probably you might have too many SQL connections, and it has been able to load all the connections, so it is timing out.

    try SP_who2 gives you same information.

  • RE: SQL Server 2005 SP3

    Micorsoft SQL Server 2005 SP3 will be available pretty soon.

  • RE: Attach big database

    Thanks for the valuable comments.

  • RE: Database Blocking

    Chirag, could you provide me little more detail on figuring out blocking by using activity monitor?

    Thanks

  • RE: Database Blocking

    Can activity Monitor be handy in detecting the blocking? If so how?

    Thanks

  • RE: Log File

    Thank You again for clearing some misunderstandings.

    So, can I conclude that the only way to resolve the growing log is to take T log back up which truncates the...

  • RE: Log File

    Thank you so much for your time and effort. Like most of you said taking transaction log back up truncates the inactive portion of log and shrinks the t log...

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