Forum Replies Created

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

  • RE: Query Error Message

    Execute this "EXEC sp_MSdbuserpriv  N'ver'"

    If same error occurs refer to: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3BQ327424

    Although it refers to SQL Ser 7 it may be relevant to you.

    If it does not give back a...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Deleted Login still has rights to DB

    Watch out for Domain Administrators too. Often, they are included int he Administrators group.

     


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Idiots guide to Cluster Management

    You could look at :

    http://www.nwnetworks.com/cluster.html

    (and I think you might need to know about installation and creation of clusters, which will enlighten you about how the disks are viewed from...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: copying UDFs and ud dataTypes

    Or....

    Using EM, copy (right click on existing UDF), move on over to Master/UDF's. Right Click "Create new UDF" clear the code window and paste into the code window.

    When EM does...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: UDF returns table - how to use it in stored procedure

    You need to supply the full code (SP & UDF).

    If the ParseString udf returns a table you may have to think differently.

    DB


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: MS-Query to return results to excel (SQL syntax help needed)

    Remove the two pctupuser's in the SQL statement and OK it. They'll come back - so that's a no

    Your Database name is "pctupuser" and the table/s owner name is "pctupuser"...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Upgrade to MDAC 2.8 or not?

    MDAC is not upwards compatible ?

    I have been using it since it came out and have not experienced any issues.

    We recently released a new GIS system into our SOE and...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: OPENQUERY Problem

    Try defining a linked server without a space in the name.

     


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Client Safety Option

    Well how about that ? You live and learn hey ? (Go Aussie)

     


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Connection Time Out

    And you still will have only 30 seconds.

     


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: xp_fixeddrives

    XP_FIXEDDRIVES does see the shared drives in a cluster here. The drive configuration may be an issue - I think XP_FIXEDDRIVES only returns info on Fixed hard drives.

    Do you have...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Importing FIle with extension .CPT in SQL 2000 server

    And I'm pretty sure you can't import a Corel Photopaint file into SQL Server (ho hoh ho)

     


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: copying a billion row lines

    Done about 8 million text/integer using BCP which was fairly fast and painless, used the Import Data Wizard for a 3 million row table - which was a bad thing...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Connection Time Out

    Don't know about Analysis Services but you only have 30 seconds, and only ever 30 seconds in EM for your query to return data.

    If you have an affection for the...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: update from Oracle -> SQL Server 2000

    Ala Books On Line:

    OPENQUERY

    Executes the specified pass-through query on the given linked server, which is an OLE DB data source. The OPENQUERY function can be referenced in...


    The systems fine with no users loggged in. Can we keep it that way ?br>

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