Forum Replies Created

Viewing 15 posts - 166 through 180 (of 320 total)

  • RE: Connecting to a specified MDB

    jason.sultana (11/18/2008)


    Hi all. A collegue of mine has created a Master Database File (.mdb) for SQL Server 2005 and added some data to it via a PHP script. I want...

  • RE: Database Maintenance

    Dinendra Nath Dolai (11/18/2008)


    Hi All,

    I am maintaining a database for a Telecommunication application. This has a very high level of transactions.

    Please suggest me what regular actions should I take to...

  • RE: Maximum size of temporary tablke variable

    arup_kc (11/18/2008)


    Hi John,

    Thanks 4ur reply. I have gone through it. But my question is, there is a limitation of table variable reg. size. I want to know that threshhold size.

    thanks...

  • RE: how to connect sql express 2005 through asp?

    sonashah_2190 (11/16/2008)


    i want to connect sql express through asp 3.0 but unable to do it..

    Please help me!!!

    I am connecting it through system DSN.

    Please tell me the procedure for the connection.

    Thanks,

    normally...

  • RE: A transport-level error has occurred when sending the request to the server.

    Leo Leong (11/18/2008)


    windows 2003 server enterprise x64 Sp2 (clustered w/ active/passive)

    sql server 2005 Sp2

    managed to connect to database from local (on the database server itself) at the beginning.

    however, after 10...

  • RE: Any one can send me answers for these

    venkat.saginath (11/17/2008)


    If the user complaint you that application is running very slow. As

    a DBA where do you start your work ???how do you find where exactly

    the problem is???

    After logshipping configured,users...

  • RE: how to add indexex in a view using sql sever 2005

    lav (11/17/2008)


    i want to add indexes in my view .when use my view i goted time out expire . plz send me solution ......

    thanks & regards

    lav

    may be this will helpful:

    Make...

  • RE: bcackup failed

    yogaanand.me (11/17/2008)


    hi friends

    in my organization we are taking diff backup in every 3 hours

    in night 3'0 clock backup is failing in every day .. we changed backup drive(network drive)

    in sql...

  • RE: A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

    ARUN.M.11 (11/14/2008)


    Hi,

    When I m recreate database then the following error occurred.

    A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - No...

  • RE: script task failing the job

    Panks (11/13/2008)


    i have a script task:

    Dim fileLoc As String

    fileLoc = CStr(Dts.Variables("User::ImportLocation").Value)

    Dim fullFileName As String...

  • RE: doubt on indexes

    nageswara.dhaveji (11/14/2008)


    Hi everybody,

    🙂

    Please tell me how to list out the indexes in a database, on which table and which column the index is created.

    Thanks

    to check the table Employee, use this

    sp_help...

  • RE: Stored procedure

    Nandy (11/14/2008)


    Hi All,

    I have written stored procedure, based on selections I need to check values from the table. Here I will get tablename from the query and I need to...

  • RE: Restoring a SQL Server 6.5 Database dump

    smatu (11/13/2008)


    I am trying to restore a SQL Server 6.5 database dump from one SQL server instance to another. I am unable to perform this task through the GUI...

    Does...

  • RE: database attach/detach

    anam (11/14/2008)


    i have my database with data file in "M:\sql\data" folder and log file in "L:\logs" folder.

    now after detaching the database, i moved across files to another server. i have...

  • RE: Incredibly slow responses if any at all

    Kris (11/12/2008)


    Hi,

    I currently have a dedicated web server and a dedicated SQL server 2005. The specs shouldn't be of real importance at the moment cause I am the only...

Viewing 15 posts - 166 through 180 (of 320 total)