Forum Replies Created

Viewing 7 posts - 61 through 67 (of 67 total)

  • RE: Super user in SQL SERVER 2000


    Here's a series of scripts I use to check who's eating up the resources....

  • RE: shrinking a transaction log

    Maybe there is an uncommited transaction in the log. IF this is stored near the end of the log file, then shirinking the file will only chop off the bit...

  • RE: Active/Active Cluster

    See Knowledge Base Article 329329 - PRB: Windows Server 2003 Support for SQL Server 2000

    Apparently SQL2K SP2 and before are not supported on WS2003, and on trying to install SQL2K...

  • RE: Reading a system variable with TSQL


    -- Capture the output in the table

    INSERT #CMDResults

    EXECUTE master.dbo.xp_cmdshell 'ECHO %sql_backup_drive%'


    This just returned a row in the temp table with the contents '%sql_backup_drive%'

    replacing ECHO %sql_backup_drive% with SET sql_backup_drive should...

  • RE: Index left(MyField,10)





    alter table authors add mvgtest as substring(au_lname,1,10)


    create index mvgIndex on Authors (mvgtest)


    Server: Msg 1911, Level 16, State 2, Line 1

    Column name...

  • RE: Index left(MyField,10)

    You could try adding a computed column consisting of the first 10 characters of the index field and indexing on the computed column.

    According to BOL, this is allowed as long...

  • RE: SQL 2000 SP3


    I can remember having that with 1 customer but seem to remember also that i just switched the view off of TaskPad...

Viewing 7 posts - 61 through 67 (of 67 total)