• September 14, 2005 14 Sep'05

    Lessons Learned: Working with Oracle stored procedures, applications and data

    Whether you're trying to execute an Oracle stored procedure on SQL Server or move data from one DBMS to another, you'll find troubleshooting advice in this collection of short lessons by Kevin Kline, our resident SQL Server Monitoring/Administration...  Continue Reading

  • September 13, 2005 13 Sep'05

    Fast Guide: Stored procedures

    Stored procedures can be executed quickly inside your database server, saving you the time it would take to do the same work on a client. In the second part of our stored procedure series of fast guides, we offer stored procedures to help you with ...  Continue Reading

  • September 13, 2005 13 Sep'05

    When to avoid using Enterprise Manager

    If you need to make a quick-and-dirty change to data in a relatively small table, SQL Server Enterprise Manager will get the job done. But if your column contains more than 1,024 characters -- take your editing needs elsewhere.  Continue Reading

  • September 13, 2005 13 Sep'05

    Query to return database name

    Global function DB_NAME() allows you to return the name of a database that a process is connected to. SQL Server 2005 expert Adam Machanic offers a sample query in this response.  Continue Reading

  • September 13, 2005 13 Sep'05

    Licensing concerns when upgrading SQL Server

    If you decide to upgrade SQL Server 2000 Standard Edition to Enterprise Edition, you may see subtle changes in your licensing agreement. Expert Kevin Kline offers licensing information in this response.  Continue Reading

  • September 13, 2005 13 Sep'05

    Fast Guide: Undocumented stored procedures

    Stored procedures can help you control access, preserve data integrity and improve productivity, yet you may not be tapping into all the routines that ship with SQL Server. Here we highlight some particularly useful undocumented stored procedures, ...  Continue Reading

  • September 12, 2005 12 Sep'05

    Unspecified error after upgrading to Service Pack 4

    If you had trouble viewing information using SQL Server 2000's General Database Wizard after upgrading to Service Pack 4, Monitoring and Administration expert Kevin Kline offers a simple way to fix the problem.  Continue Reading