Forum Replies Created

Viewing 15 posts - 76 through 90 (of 139 total)

  • RE: Mirroring question

    Vivien Xing (11/6/2008)


    2. You can use snapshot of the mirrored database for reporting purpose or R/O.

    But if we want the secondary(mirrored db) which will be read only to be used...

  • RE: Restore question!

    Jack Corbett (10/20/2008)


    Looks good to me. The only question I have is do you have the Wednesday 1 pm log backup? If you do you could potentially do...

  • RE: question on data transfer

    MANU (10/3/2008)


    Try scheduling job at some other time. Do one thing capture ping IP address results at the time when the ftp job executes so as to check whether there...

  • RE: question on data transfer

    MANU (10/3/2008)


    Try scheduling job at some other time. Do one thing capture ping IP address results at the time when the ftp job executes so as to check whether there...

  • RE: Transactional replication of views

    steve smith (9/25/2008)


    Perhaps this response will help with your question.

    1. Data is stored in tables.

    2. Views display data stored in tables.

    How do you intend to 'replicate' (not 'remotely...

  • RE: SSIS packages backup

    Thanks for the reply. Per the properties of the SSIS package, the full path of the package shows as "C:\SSISpackage\package1.dtsx", so based on this I think the package is getting...

  • RE: question on sa user

    I do'nt remember what mode was selected during the installation. Usually what mode do we have to select while installing sql 2005? So that I shall be careful in selecting...

  • RE: Remove invalid data from the column

    No it's not the same values, one has the follow:

    {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial;}{\f1\fswiss\fprq2\fcharset128 Arial Unicode MS;}{\f2\fnil\fcharset0 Microsoft Sans Serif;}} {\colortbl ;\red0\green0\blue255;} \viewkind4\uc1\pard\sb100\sa100\cf1\b\f0\fs20 Mechanical \b0\f1\par \f0\fs18\line Department \par \par...

  • RE: t-sql question

    Any ideas please!! Thanks.

  • RE: t-sql question

    This is what I am trying to do:

    IF order EXISTS in the orders table

    Begin

    Insert that order into DuplicateOrders table

    End

    Else --Not existing in orders table, new order

    Check if the...

  • RE: Data loading issue from a particular excel column into a table

    SrikanthSv (8/11/2008)


    When u select the connection and check for the properties you can find a connection string

    so add this tag in the connection string value

    it'll be like

    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data.xls;Extended Properties=Excel...

  • RE: Data loading issue from a particular excel column into a table

    SrikanthSv (8/11/2008)


    Use IMEX =1 in the connection property string of the excel connection

    that'll set the mode to import and all the values will be populated.

    Please let me know where I...

  • RE: Making data secure

    Thanks for your response, actually we have a user's table in the database, whenever a new user wants to get access to that web application that user will be added...

  • RE: Question

    I am sorry for not being clear. I need to know about disaster recovery. Actually we have clustered servers for all our applications. Our networking team is taking care of...

  • RE: Generate output and place in a specific folder

    Steve Jones - Editor (6/2/2008)


    How do you expect this data to get into folders? What type of result set?

    The data from SQL Server can be easily exported using DTS or...

Viewing 15 posts - 76 through 90 (of 139 total)