Forum Replies Created

Viewing 15 posts - 826 through 840 (of 872 total)

  • RE: Auditing

    What type of auditing? Connections? Changes?

    February 7, 2008 at 1:59 pm

    #776178

  • RE: Question about AWE memory usage

    Barrett Owen (2/7/2008)

    Before, SQL Server would slowly build up it's memory usage to the maximum amount it could grab, and it would just hover around there. Now AWE is...

    February 7, 2008 at 1:56 pm

    #776176

  • RE: Compair table structure of two databases

    Another vote for RedGate's SQL Compare. By far the best production out there for comparison and synchronization.

    February 7, 2008 at 1:42 pm

    #776172

  • RE: Snapshot database

    Loner (2/7/2008)

    Can you create the snapshot database on the same server where the original database is?

    If you want the users/other developers to query using the snapshot database, do you have...

    February 7, 2008 at 1:40 pm

    #776171

  • RE: Moving to a new task in DTS?

    Debra Owens (2/6/2008)

    Use work flow task.

    right click on data transform item, select work flow properties, select the item to execute next.:D

    Well, I only want to go that path if the...

    February 6, 2008 at 11:55 am

    #775730

  • RE: SQL Server Backup Software

    I've used LiteSpeed for a little over 2 years, and while it gets the job done, it doesn't offer much in terms of central management capabilities (nice if you have...

    February 5, 2008 at 2:42 pm

    #775349

  • RE: SQL Comparison Report

    Across the top, hit "synchronization wizard".

    February 4, 2008 at 2:38 pm

    #774923

  • RE: Sql servwe 2000 and 2005 in a same server

    GilaMonster (2/3/2008)

    Sure it's possible. 2000 has to be installed first and can be the default or a named instance. SQL 2005 must be installed second and must be a named...

    February 4, 2008 at 2:36 pm

    #774922

  • RE: Index Rebuilds Still Leave Fragmentation

    GilaMonster (1/28/2008)

    How big are the tables in question? How many pages do the indexes take up (visible in sys.dm_db_index_physical_stats)

    Edit: btw, a separate update statistics is not necessary (and may even...

    January 29, 2008 at 2:19 pm

    #773054

  • RE: XP_cmdshell performance

    While I can't really comment on the performance of xp_cmdshell varying between environments (there shouldn't really be any other factors than the horsepower of the machine), I can highly...

    January 29, 2008 at 2:12 pm

    #773049

  • RE: Creating sp_who5, need advice

    Roy,

    What is x aliasing?

    January 25, 2008 at 1:56 pm

    #772014

  • RE: How grant db_owner permission to some objects

    Judy (1/25/2008)

    Actually I created one custom database role, named "db_Custom" and added objects to this new role.

    Users under this role only have "select, update, delete,insert" on objects.

    But users need to...

    January 25, 2008 at 10:28 am

    #771883

  • RE: How grant db_owner permission to some objects

    Judy (1/25/2008)

    Hi all,

    How can I grant one user to have db_owner permission on some tables , but only have db_datareader permission on others tables.

    Thanks

    db_owner is a database role and basically...

    January 25, 2008 at 9:57 am

    #771861

  • RE: Creating sp_who5, need advice

    Steve Jones - Editor (1/25/2008)

    I would have tried it the way you were running it. Not sure there's a way outside a cursor with dbcc inputbuffer. Course there are a...

    January 25, 2008 at 9:56 am

    #771860

  • RE: Extents Allocated > 200

    You might want to run a DBCC UPDATEUSAGE to ensure you're still receiving the correct numbers.

    January 24, 2008 at 11:31 am

    #771432

Viewing 15 posts - 826 through 840 (of 872 total)