Forum Replies Created

Viewing 15 posts - 49,501 through 49,515 (of 49,552 total)

  • RE: How can I copy the same package to another server ?

    Or if you can't access the second server from the first

    Package->Save As

    Change the location drop-down to 'Structured storage file'. That way you can save the dts package to the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 17, 2004 at 12:48 am

    #523454

  • RE: Changing collation of an existing server

    What you can try (no guarentee) is to change the collation of the model database. Since that is used as a template for new databases, in theory any new databases...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 15, 2004 at 12:20 am

    #523103

  • RE: Log reader - Cannot execute sp_replcmds Timout expired

    Thanks, I'll bear that in mind if this happens again.

    I had to remove the replication this morning, as I was no closer to a resolution than yesterday and the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 14, 2004 at 7:43 am

    #522954

  • RE: Attach DB with corrupt .ldf?

    What error did you get? Did SQL refuse to attach the db, attach but mark as suspect?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 14, 2004 at 5:55 am

    #522923

  • RE: NTFS Rights For Reporting Services Virutal Directories

    Check IIS and see if it allows anonymous access

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 14, 2004 at 1:00 am

    #522883

  • RE: Categories for QoD

    Thanks. That's great

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 14, 2004 at 12:53 am

    #522882

  • RE: relate job to DTS name

    I don't think you can. I spent a day or so looking into exactly that issue. That long string of numbers and letters is a one way hash of the...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 14, 2004 at 12:41 am

    #522880

  • RE: Attach DB with corrupt .ldf?

    Detach the database, delete or move the ldf and then from ent manager attach database. The dialog will note that the ldf is missing. Click OK and db will be...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 14, 2004 at 12:35 am

    #522879

  • RE: Transactional Replication error

    Could you give us more information? It this an existing replication setup? Are you configuring replication for the first time on these servers? If so, what have you done so...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 13, 2004 at 3:47 am

    #522705

  • RE: Question of the Day for 10 Sep 2004

    Wouldn't that also pick up instances of #mytable created by other users?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 10, 2004 at 1:51 am

    #522455

  • RE: displaying the result set coming from a temp table in a stored proc

    How are you initially creating the temp table?

    CREATE TABLE #myTable (...)

    or

    SELECT ...

    INTO #myTable

    I've had some problems with the SELECT ... INTO #temp before. Try explicitly declaring the table if you're...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 6, 2004 at 11:46 pm

    #521906

  • RE: Table last updated??

    Not unless you've got some form of datetime field that's set to the current date on an update.

    Timestamp columns are updated whenever a record is changed, but I don't think...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 6, 2004 at 11:38 pm

    #521904

  • RE: Push replication, firewall, woe is me

    Try an anonymous pull subscription. It's what I've had to do with a firewall between my distributor and subscriber.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 6, 2004 at 12:27 am

    #521809

  • RE: Is there any way to insure a WHERE clause will be executed in its EXACT order?

    Not elegant, but should work

    SELECT *

    FROM (Select * FROM TestWhereOrder WHERE TypeCode = 'N') NumericTests

    WHERE TestWhereOrderID = 100

    AND cast(Code as int) = 100

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    September 1, 2004 at 12:23 am

    #521303

  • RE: Printing the Structure of Table

    Create a database diagram with just that table. You can specify exactly what the diagram shows (just column names, names and types, etc)

    You can print the database diagram

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    August 19, 2004 at 12:58 am

    #519702

Viewing 15 posts - 49,501 through 49,515 (of 49,552 total)