Forum Replies Created

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

  • RE: import data problem in SQL server 2008

    Brandie Tarvin (7/23/2012)

    ali.mahmoud.habib (7/23/2012)

    PaulB-TheOneAndOnly (7/23/2012)

    Do not use export/import wizard, script your data load - first do your parent tables then your child tables as defined by Referential Integrity constraints.

    An alternative...

    July 23, 2012 at 8:35 am

    #1516274

  • RE: import data problem in SQL server 2008

    PaulB-TheOneAndOnly (7/23/2012)

    Do not use export/import wizard, script your data load - first do your parent tables then your child tables as defined by Referential Integrity constraints.

    An alternative would be to...

    July 23, 2012 at 7:50 am

    #1516234

  • RE: import data problem in SQL server 2008

    PaulB-TheOneAndOnly (7/22/2012)

    ali.mahmoud.habib (7/22/2012)

    I want to import data from one database to another , the destination I don't have permission to resotre a backup file to it, so I have only...

    July 22, 2012 at 6:02 pm

    #1516032

  • RE: get the actual password from aspnet_memberships

    Steve Jones - SSC Editor (6/4/2012)

    You cannot do that. The point of a hash is a one way function applied to a password. It's possible there are multiple passwords that...

    June 4, 2012 at 8:47 am

    #1496530

  • RE: DTS problem

    Greg Charles (3/16/2010)

    sa won't be able to access files since it's a SQL Server login. Just grant permissions on the file to FNS\SYSTEM.DTSRun.

    I created user FNS|System.DTSRUN and give him...

    March 17, 2010 at 5:28 am

    #1135125

  • RE: DTS problem

    drew.allen (3/15/2010)

    ali.mahmoud.habib (3/11/2010)

    Executed as user: FNS\SYSTEM. DTSRun:....

    I don't know why give access denied, while when running it manualy use enterprise manager work very well

    When running it manually, you are using...

    March 15, 2010 at 3:40 pm

    #1134116

  • RE: DTS problem

    Greg Charles (3/11/2010)

    You're probably using Windows Authentication in your Transform Data task. When you run the package it uses your login and you have permission to access the flat...

    March 14, 2010 at 1:48 am

    #1133352

  • RE: Select distinct question

    lmu92 (2/17/2010)

    ali.mahmoud.habib (2/17/2010)

    lmu92 (2/17/2010)

    You could add "ORDER BY MIN(Serial)" to your SELECT clause.

    Serial --> is not included in my select

    Select description from x

    any other idea please

    You might not...

    February 17, 2010 at 9:26 pm

    #1120637

  • RE: Select distinct question

    lmu92 (2/17/2010)

    You could add "ORDER BY MIN(Serial)" to your SELECT clause.

    Serial --> is not included in my select

    Select description from x

    any other idea please

    February 17, 2010 at 3:05 pm

    #1120505

  • RE: Select distinct question

    GSquared (2/17/2010)

    It looks like the only difference is the sequence. Is that correct? If so, you'll need to specify how you want it ordered, otherwise SQL just gives...

    February 17, 2010 at 1:37 pm

    #1120427

  • RE: Question relate to sql profiller

    GilaMonster (7/22/2009)

    The audit login event occurs when someone logs in to SQL. The audit logout event occurs when someone logs out of SQL.

    What do you mean by 'affects performance'?

    I mean...

    July 22, 2009 at 1:17 pm

    #1028634

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