Forum Replies Created

Viewing 15 posts - 856 through 870 (of 1,179 total)

  • RE: Script to change Port number

    You can also run setup.exe file with /qn or /qb option while installation.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Logshipping - Question

    I guess you have missed something.

    refer following link for more detail.

    ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/2d7cc40a-47e8-4419-9b2b-7c69f700e806.htm

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Script to change Port number

    I doubt if chaning port is possible with T-SQL.

    Yes, it could be possible to edit the registry settings and do the change but I do not recomend.

    Not sure about your...

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Point In time

    check this out:

    http://msdn.microsoft.com/en-us/library/ms190982(SQL.90).aspx

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: how much RAM(memory) used by sql server 2005

    What SQL Server 2005 Edition are you using?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Who uses Windows authentication only?

    We are using Windows auth only. It is more secure. If you are using windows auth than your application should be more powerful security feature or settings.

    You need to create...

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: identifying agent job based on blocking spid

    Hello Winston,

    Is blocking is temporary?

    Are you facing any deadlock problem?

    check this view:

    sys.dm_tran_locks

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Adding new data file

    Yes, you are heading into right direction. It will work.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: replication information

    As a broad level here is the list of sp which are related to replication; you can use as per your requirement.

    http://msdn.microsoft.com/en-us/library/ms174364.aspx

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: How to implement Disaster recovery for SSRS?

    for SSRS you can think about Mirroring if possible in your scenario.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: logspace

    You can also use standard report "Disk Usage". Which will also give you requried info.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Best way to load changing Master data

    You can also think about the third party database designing / data-modeling tool which will make your task easy.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Relating job operators to Database mail profile

    You can create the various Operators in SQL 2005 and assign the specific job to send mail to related operator when the job fails.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Distribution database

    Check first of all that Replication is working fine. What is the latency of replication of the data?

    Also check if db has grown to 59 GB what is the free...

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • RE: Collation Conflict

    Hello Zombi,

    Thank you for more clarification and making your question understand 🙂

    As far as I know there should not be any problem unless and untill you are using ENGLISH language...

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 15 posts - 856 through 870 (of 1,179 total)