Forum Replies Created

Viewing 10 posts - 16 through 25 (of 25 total)

  • RE: How can you link more than 1 database?

    Your right. I could just create a linked server using the other data source option and name it the database I want to link to.

    Rob DeMotsis

    Sr. SQL Server DBA

    Pier 1...

  • RE: DTS Errors

    Can you run it manually? If so, then it is probably a permissions issue.

    Rob DeMotsis

    Sr. SQL Server DBA

    Pier 1 Imports, Inc.

  • RE: SQL Server VS. Oracle

    Andy - We have cross-trained all DBAs in each Database platform. We find that we can take vacations that way.

    Rob DeMotsis

    Sr. SQL Server DBA

    Pier 1 Imports, Inc.

  • RE: Procedure Cache

    I hadn't restarted the service. I was monitoring it when it started getting low, and watched it plummet. I did forget to mention that I am running the Database on...

  • RE: What other dba hats do you wear?

    We currently use Oracle 806, SQL2k, DB2, sysbase, and of course everybody's favorite.....Access.

    Rob DeMotsis

    Sr. SQL Server DBA

    Pier 1 Imports, Inc.

  • RE: SQL Server VS. Oracle

    We find that by using the database platform that the application was written for has fewer headaches. We are a DB2, Oracle, and SQL Server shop. Each database application has...

  • RE: Procedure Cache

    That's great information. I vaguely remember seeing something on it before. After looking into the stored procedures more closely, I found that there are only a few Stored Procs that...

  • RE: Procedure Cache

    Why yes they are.

  • RE: Written table documentation

    We have evaluated several different tools available on the market today and have found one that we truly like. The suite of products is from Embarcadero it includes ER/Studio, DBArtisan,...

  • RE: Error while trying to reattach a databse in SQl 2k

    When I try that, I get another error message

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

    Could not open new database 'Pier1_Mart'. CREATE DATABASE is aborted.

    Device activation error. The physical...

Viewing 10 posts - 16 through 25 (of 25 total)