Forum Replies Created

Viewing 15 posts - 181 through 195 (of 1,884 total)

  • RE: Upgrading SQL 2005 Hardware

    Hi,

    Yes, write all errors down or make screenshots.

    Also make sure that your storage is started before you rebooting the server. We did have issues once and now the support enginners...

    Regards,Yelena Varsha

  • RE: Upgrading SQL 2005 Hardware

    Could you post here any error messages?

    From SQL Server log or from Event Logs - anything.

    Regards,Yelena Varsha

  • RE: Transaction Log Issue

    Yes, read this:

    http://support.microsoft.com/kb/555128

    HowTo: Backup to UNC name using Database Maintenance Wizard

    You have to use UNC as \\servername\sharename

    because the mapped drives exist only for the current user when he logged in....

    Regards,Yelena Varsha

  • RE: Problem with Linked Server in SQL 2005

    Normal is when a Linked Server login has permissions, then you can see the tables. I can not see the tables in Management Studio when linking to Oracle or Lotus...

    Regards,Yelena Varsha

  • RE: Convert Unicode Error Log to ASCII

    Cool. Do not copy to the original log name.

    What are you doing with the log?

    Regards,Yelena Varsha

  • RE: Transaction Log Issue

    I would agree with the second opinion that if the file will grow again every night, you should leave it the same size so the resources would not be spent...

    Regards,Yelena Varsha

  • RE: DB - File Storage BI question (I think !)

    It works like this:

    The web application allows users to download a file from the server to their computers. This code vary by application. Users edit files using Microsoft Office installed...

    Regards,Yelena Varsha

  • RE: Upgrading SQL 2005 Hardware

    Hi Gino,

    SQL Server can not start most probably because it could not find system databases.

    Check the registry and modify the path to the startup parameters accordingly after making sure that...

    Regards,Yelena Varsha

  • RE: DB - File Storage BI question (I think !)

    A couple of Project Management applications that I know support this feature as letting the user to download and upload files. Users edit files themselves.

    I would also advise you to...

    Regards,Yelena Varsha

  • RE: Transaction Log Issue

    When you truncate the log, the file stays the same size, it just does not contain much data. You have to shrink it using DBCC SHRINKFILE

    http://msdn2.microsoft.com/en-us/library/ms189493.aspx

    Also read this:

    http://msdn2.microsoft.com/en-us/library/ms178037.aspx

    Let us...

    Regards,Yelena Varsha

  • RE: Rebuild Master

    I would try to restore from the backup first

    Regards,Yelena Varsha

  • RE: SQL agent question

    What happened with the primary command to get the state of the service? I mean, sc (service control) executable?

    You can run it from Command Prompt as

    sc query sqlserveragent

    or you can...

    Regards,Yelena Varsha

  • RE: T-SQL Query

    This will work too - we will parse the string with the month and put it into the temp table. This way you can receive an input from the front...

    Regards,Yelena Varsha

  • RE: Yet another wayto include portability on DTS packages

    This is a GREAT idea with alises.

    The reason I don't use it is that we try to make dev, test and production environment with as different names as possible including...

    Regards,Yelena Varsha

  • RE: Bloated

    We need to archive data properly and let them be accessible.

    My insurance deductibles were archived by the Health Insurance company (one of the biggest ones, don't want to mention the...

    Regards,Yelena Varsha

Viewing 15 posts - 181 through 195 (of 1,884 total)