Forum Replies Created

Viewing 15 posts - 2,356 through 2,370 (of 2,473 total)

  • RE: Integrated Service 2005 and ADABASE

    SQL2005 IS should be able to pull data from any ODBC compliant data source.

    If you can find an ADABAS ODBC driver for Windows, then IS can get your data.  (ADABAS should...

  • RE: Crystal Reports data access methods (stored procs, etc.)

    One potential problem of option B is that that Crystal may produce sub-optimal SQL to access the database.

    This is a generalisation, but most high-end reporting tools have logic to decide...

  • RE: SQL ROLES?

    We have used the script below to pull off permissions for database roles:

    -- Build statements to replicate authorities for a Database Role

    SELECT

      CASE p.protecttype

      WHEN 205 THEN

        CASE

         ...

  • RE: Apply Hot Fix for SQL 2000 SP3

    I have not applied this fix, but looking at the hotfix components there are definitely server-based components.

    SQL hotfixes are always cumulative, and this hotfix will update your server to level...

  • RE: Calculate distances from given UK postcode

    Don't forget that your calculations will just give you the distance as the crow flies, not the surface travel distance.  The two can be significantly different where a river estuary...

  • RE: Dynamic Disk

    There are some problems with dynamic disks that can hit any machine, not just SQL Server ones.  The problems appear to stem from the (Windows) database that holds details about...

  • RE: tempdb deleted

    I once detached tempdb to see what happens, and how to get things working again.  As far as I can remember, this is what I did...

    1) Start SQL with the...

  • RE: Server h/w upgrade with data already held on SAN (SQL2K SE)

    I would go with the approach of C70070540 (Are you related to R2D2?), with a few tweaks.

    First build the new server with a different name, connect it to the SAN, and...

  • RE: Migrating DTS package of sql sever 2000 to sql server 2005

    The advice I have heard from SQL Server MVPs who have been involved with SQL2005 DTS since alpha-test days is that it is best to re-engineer your DTS, and not...

  • RE: How to save DB diagram, generated in SQL ,in word format?

    It is quite easy to save a database diagram as a .pdf document. 

    This is done by printing the document to a virtual printer that outputs the results as a...

  • RE: Default table permissions

    It sounds like what you want to do is to have a template of security permissions that will be automatically applied to an object when it is created. 

    This is...

  • RE: SQL Server SMTP mail problem (fiber mode)

    Lots of things are not supported or stop working when running in Fiber mode.  A KB search for "Fiber mode" shows some of the issues.

    My suggestion is to turn off Fiber mode...

  • RE: SA PASSWORD

    What justification do the Network people have for needing SA rights?

    If they act as a backup to the DBAs, then SA might be justified.  In our shop, there are enough...

  • RE: c2 audit mode option

    C2 audit mode is based in the C2 definition in the US DOD 5200.28 standard.  This standard is now obsolete and has been replaced be a security evaluation system called...

  • RE: Performance on Windows 2003

    My experience is that there are 2 most likely possibilities:

    1) The W2003 DB server is very badly tuned and is running slowly.  This is unlikely, unless your site has done...

Viewing 15 posts - 2,356 through 2,370 (of 2,473 total)