Forum Replies Created

Viewing 15 posts - 6,511 through 6,525 (of 7,164 total)

  • RE: Staging FIXML Data into SQL 2008

    You're welcome. I am happy you have a path towards a solution 🙂

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 28, 2011 at 8:01 am

    #1317274

  • RE: Staging FIXML Data into SQL 2008

    Ghanta (4/28/2011)

    Thanks a lot OPC. So is there a way I can query the data and create the destination table for it? And then use your 2nd approach? Data is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 28, 2011 at 7:32 am

    #1317248

  • RE: Role/User/StoredProc/Functions/ExecuteAS/TVF

    Ukon (4/28/2011)

    Good Morning:

    Ok, I read the articles you posted. I have one issue. In the article: http://www.databasejournal.com/features/mssql/article.php/10894_2246271_2/Managing-Users-Permissions-on-SQL-Server.htm

    there was the following statement:

    The DENY statement is used to deny a permission from...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 28, 2011 at 7:21 am

    #1317237

  • RE: freebcp and Named FIFO.

    Good to know...thanks for posting back.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 28, 2011 at 7:11 am

    #1317230

  • RE: freebcp and Named FIFO.

    abygaikwad17 (4/28/2011)

    I am running freebcp from Linux machine and I have installed SQL Server on Windows. I am trying to use freebcp to import data into SQL Server. I just...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 28, 2011 at 7:01 am

    #1317222

  • RE: Staging FIXML Data into SQL 2008

    Ghanta (4/27/2011)

    I do not have XSD or table created.. this is an ad-hoc file and we do not have schema for it... what should be the fastest way to load...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 27, 2011 at 11:05 pm

    #1317031

  • RE: freebcp and Named FIFO.

    LutzM (4/27/2011)

    opc.three (4/27/2011)

    FreeBCP leverages FreeTDS which is one of the few drivers out there that supports communicating with SQL Server from *x systems...use of it does not imply SQL Server...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 27, 2011 at 5:00 pm

    #1316969

  • RE: freebcp and Named FIFO.

    FreeBCP leverages FreeTDS which is one of the few drivers out there that supports communicating with SQL Server from *x systems...use of it does not imply SQL Server is running...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 27, 2011 at 4:20 pm

    #1316956

  • RE: Firing events from Script Component

    Using a Script task to dump text to the console is not front-and-center in SSIS because that's not what the SSIS design team had in mind in terms of logging...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 27, 2011 at 3:54 pm

    #1316947

  • RE: SQL Server Replication alternatives

    Also submitted for your reading pleasure...here is a high-level overview of a fictional situation Microsoft conjured to illustrate an ideal application of Merge Replication technology. The fictional company's situation is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 27, 2011 at 3:34 pm

    #1316940

  • RE: SQL Server Replication alternatives

    Rog Saber (4/27/2011)

    We have a customer which connects to our servers through Citrix. However, they have a major concern that the facilities in which they want to run our applications,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 27, 2011 at 3:05 pm

    #1316923

  • RE: Staging FIXML Data into SQL 2008

    Do you have an XSD to go with the XML?

    Do you have tables in SQL Server created to import the data into?

    The Bulk XML Loader tool included in SQLXML will...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 27, 2011 at 2:48 pm

    #1316912

  • RE: Role/User/StoredProc/Functions/ExecuteAS/TVF

    Ukon (4/27/2011)

    Hello again, and thank you for your reply. I see your point, however, there are also recommendations that data should only be accessible to users via parameterized stored procedures...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 27, 2011 at 1:39 pm

    #1316864

  • RE: freebcp and Named FIFO.

    FreeBCP? Are you on Linux or Unix?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 27, 2011 at 1:24 pm

    #1316846

  • RE: Role/User/StoredProc/Functions/ExecuteAS/TVF

    Ukon (4/27/2011)

    Hello. For db security, I understand the following:

    Currently this is on sql 2005 going to 2008 r2 shortly, so if there are changes that are available only in...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    April 27, 2011 at 12:48 pm

    #1316824

Viewing 15 posts - 6,511 through 6,525 (of 7,164 total)