Forum Replies Created

Viewing 15 posts - 1,831 through 1,845 (of 2,436 total)

  • RE: QuickShift

    A quick google search ( http://www.google.com/search?hl=en&q=+QuickShift+for+SQL+Server&nbsp turns uop a number of hits ... the first hit is from a very reputable site:

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Using BCP for import

    I'd just make sure that NULL-ability, constraints and referential integrity are matched as well. Even with a perfect bcp format file and clean data, if the other things are not...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: MSX - Multiserver Jobs from Master to Target

    Multiple DBA's supporting multiple SQL Servers ... hmmm ... MSX is still your best bet. Each DBA can script their own JOBs and just select the 'target' servers. System maintenance...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Script to Database

    You also must take into account windows user and directory/file pasmissions that are granted to the SQL Server Service (and possible the SQL Server Agent services as well. Also, let...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Login failed for user ''''xxx''''. Reason: Not associated with a trusted SQL

    Let's start with a few questions ... Is the SQL Server a member of a domain ? Is the computer you are currently logged into when executing the command a...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: intermittent backup failures

    The only other advice I have is to update your MDAC ... I believe the latest version is something like 2.8 SP2 ... this will require a reboot of the...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Limit a SQL Server account

    This sounds like a perfect opportunity to explore SRS - SQL Reporting Services. The high CPU demand reports can be generated during off hours and rendered on demand whilst smaller...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Initial size of TEMPDB in a large environment?

    Whether you use EM or Transactl-SQL setting the size, growth factors and limits for growth works exactly just like any other user database on your server. There is a small difference on the...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Windows Authentication with EM

    REMEDY ? As in Help Desk Tracking ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: failover clustering without MSCS

    Just what are "AD issues" ??? If you've got a Domain, I see no reason why you should not be able to cluster servers and then install a SQL Server...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: intermittent backup failures

    Are you using VERIFY ? If you are, try turning VERIFY off in youe maintenance plan. If the failures stop, you are being bitten by an MDAC "bug" - which...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Tuning of the SQL Server database page sizes and cache sizes

    Chris, you neglected to mention 'Sybase' ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Generic Script to Drop and Recreate Indexes

    If the data load volume is high and the table is truncated before the load each time, dropping and recreating indexes after the load may be the ticket. However, you...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Server Registration via SQL DMO

    When the script is complete could you post it ? This would become an invaluable tool for SQL DBAs everywhere due to present EM limitations.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • RE: Problem with Login info

    Here's an invaluable reference for the system tables (while they still exist):

    http://www.microsoft.com/sql/techinfo/productdoc/2000/systables.mspx

     

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Viewing 15 posts - 1,831 through 1,845 (of 2,436 total)