Forum Replies Created

Viewing 15 posts - 811 through 825 (of 3,366 total)

  • RE: Can less RAM cause SSIS Package to run slower?

    dndaughtery (11/18/2009)

    Thats true. I now use a 32 bit machine and was using a 64 bit machine before.

    So yep it is a platform issue now you know why most production...

    November 18, 2009 at 3:11 pm

    #1081252

  • RE: Does Visual studio 2005 required for SQL Server 2005

    gmamata7 (11/18/2009)

    Hi,

    I'm installing SQL Server 2005 and at the end of installation I have noticed Visual studio 2005 in ALL Programs list. So this Visual studio 2005 is required?...

    November 18, 2009 at 3:08 pm

    #1081250

  • RE: Can less RAM cause SSIS Package to run slower?

    dndaughtery (11/18/2009)

    I am used to working on a machine with a 2.9 gig processor and 64 Gig of RAM. I am now working on a machine with a 2 Gig...

    November 18, 2009 at 3:05 pm

    #1081246

  • RE: Data replication ASP/XML Solution needed

    Nick Kernick (11/18/2009)

    right im being totally thick here. I dont want to "open" up an sql services to the internet

    i have had servers totally ruined by people hacking into sql...

    November 18, 2009 at 10:32 am

    #1081061

  • RE: This SqlTransaction has completed; it is no longer usable.

    Gianluca Sartori (11/18/2009)

    It might not be the right answer, but check your code for DDL operations inside of TRY/CATCH blocks. Even if your code runs perfectly without a transaction when...

    November 18, 2009 at 10:05 am

    #1081037

  • RE: Data replication ASP/XML Solution needed

    Nick Kernick (11/18/2009)

    Thanks for your reply, however iam new to this

    The servers sit on the internet in their own little world. They dont talk to each other.

    and dont think they...

    November 18, 2009 at 9:50 am

    #1081016

  • RE: Data replication ASP/XML Solution needed

    You can convert the User instances to server instances and use other SQL Server in your network to create replication using the two as subscribers. The Express can be...

    November 18, 2009 at 9:29 am

    #1080998

  • RE: Script to Change Collation of User Database

    lokhande.deepali (11/18/2009)

    Hello,

    Is their is any Script to change collation of user database ?

    The process Which I know;

    First Backup the User database

    1.creation of new database with required collation (create...

    November 18, 2009 at 9:17 am

    #1080986

  • RE: How to connect to an Oracle database

    TNSNAMES.ORA is a Network Configuration file in the location C:\Oracle\product\11.1.0\client_2etwork\admin (Per my Server where Oracle 11 Client is installed) that stores the Host Name, Protocol and Port for the Oracle...

    November 17, 2009 at 2:20 pm

    #1080544

  • RE: How to connect to an Oracle database

    Bru Medishetty (11/17/2009)

    klineandking (11/17/2009)

    i also wanted to know what the TNSNAMES.ORA means or what it does in your reply to my post, what is it for?

    TNSNAMES.ORA is a Network Configuration...

    November 17, 2009 at 11:19 am

    #1080416

  • RE: How to connect to an Oracle database

    klineandking (11/17/2009)

    Hey people can someone tell me how to make a connection to an Oracle database in SSIS thank you

    Oracle require Oracle client installed for all development tasks and make...

    November 17, 2009 at 10:17 am

    #1080386

  • RE: Configuring case sensitive and UTF-16

    agil (11/17/2009)

    Hello,

    Thanks so much for your help.

    my database lenguage is english

    regards.

    Here are the collation definition when Microsoft says Expression it means collation in your queries which is new to SQL...

    November 17, 2009 at 9:00 am

    #1080323

  • RE: master database access for NT User

    am-244616 (11/16/2009)

    Master database is the default database for this login.

    The Master database is one of the system databases there should be no default login to it because system admin role...

    November 16, 2009 at 9:19 pm

    #1080016

  • RE: master database access for NT User

    AlexSQLForums (11/16/2009)

    am-244616 (11/16/2009)

    Guys,

    I see the following error in the event viewer and sql server logs every min

    Login failed for user 'NT-DOMAIN\services'. Reason: Failed to open the explicitly specified database....

    November 16, 2009 at 4:58 pm

    #1079972

  • RE: Authentication, web.config, database on another server

    halifaxdal (11/16/2009)

    halifaxdal (11/16/2009)

    From your side, you would specify integrated security connection strings from within your app.

    connectionString="Data Source=XX.XX.XX.;Initial Catalog=SomeDatabase;Integrated Security=True"

    But where do I specify the group? web.config?

    Thanks.

    You can add the...

    November 16, 2009 at 4:37 pm

    #1079968

Viewing 15 posts - 811 through 825 (of 3,366 total)