Forum Replies Created

Viewing 15 posts - 151 through 165 (of 230 total)

  • RE: Collation

    no. Just "English(United States)"

  • RE: Collation

    I am setting the collation at the database level.

    The above suggestion does not exist correct?

  • RE: Collation

    that does not exist guys.

  • RE: SQL Server 2000 Enterprise Edition on SAN

    I want to track how many I/O SQL Server only is doing?

    and how long for each I/O.

  • RE: #Temp Tables

    is there any literature on this?

  • RE: #Temp Tables

    I am wondering if the local Temp table destruction takes a while depending on system load, thus delaying SP:Completed END TIME.

  • RE: #Temp Tables

    what i need to know is when that stored proc ends, does SQL Server 2000 then take up much time to destroy this temporary table object, thus making the stored...

  • RE: password

    whay do you mean "move the passwords directly".

    I have a Peopleosft Databases with 400 Users.

  • RE: Off site Backup Server

    So is it O.K. to restore User databases to another server(a standby server) FROM a 2000 Enterprise Edition to a 2000 Standard Edition without bringing over the Master?

    (Just the login...

  • RE: Off site Backup Server

    Nightly Replication at the O.S. level - ARCServer.

  • RE: single user mode

    I do the command propmt switch to go to single user mode. At this point who is in the database server? (My Domain Account???)

  • RE: single user mode

    It connects in Single User mode, but when I go to EM I cannot get in.

  • RE: single user mode

    the switches I entered are good.

    No one is in the database.

    ???

  • RE: Collations on SQL Server 2000

    woo. this reads bad. I will fix it.

  • RE: I/O

    USE MASTER

    GO

    DECLARE @get_date_and_time DATETIME

    SET @get_date_and_time = GETDATE( )

    WAITFOR DELAY '00:00:05'

    SELECT SUM(physical_io) FROM sysprocesses WHERE last_batch > @get_date_and_time

    -- BUT, physical_io is cumulative. I need total I/O for last 5 seconds...

Viewing 15 posts - 151 through 165 (of 230 total)