SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Partitions

  I have couple questions regarding the partitions. 1.If a table is partitioned where Can i see how i…

  sql_novice_2007

  5 replies

  14 years, 7 months ago

  By: colin.Leversuch-Roberts

• pick unique record from a dim table

  i have a dim table having efct_start_dt and efct_end_dt and strategy_id.i want to pick up the recor…

  duggal.priyanka06

  9 replies

  14 years, 7 months ago

  By: duggal.priyanka06

• Replication Issue

  When we open the logreader screen to see the log reader status and whenever we click the close butt…

  azhar.iqbal499

  1 replies

  14 years, 7 months ago

  By: SQLforU

• SQL Server 2008 BI suite

  I'm downloading SQL Server 2008 from here: How to obtain the latest service pack for SQL Server 200…

  Goonch1

  2 replies

  14 years, 7 months ago

  By: SQLforU

• books or other resources for learning SSIS, SSAS, SSRS, etc.

  I'm not a DBA, but I've used SQL Server a bit the last couple of years. It's always just been SSMS…

  stevet 20325

  2 replies

  14 years, 7 months ago

  By: SQLforU

• DTS Editing problem

  I have a developer who has the development tools for SQL 2008 installed on his machine. He also ha…

  Kenneth.Fisher

  10 replies

  14 years, 7 months ago

  By: sql_dba123

• Working with Inserted and Deleted Recordsets

  Since the 'inserted' and 'deleted' record sets include all records touched by an INSERT, UPDATE or …

  david.holley

  7 replies

  14 years, 7 months ago

  By: david.holley

• DB_Owner cannot insert

  I have a user who is a db_owner on a database. However, when he tries to insert to a table, it fail…

  jimmycjen

  9 replies

  14 years, 7 months ago

  By: jimmycjen

• ssis question about connection

  I'm doing a test on my local for a ssis pacakge. My question is if it cannot find the configuration…

  sqlfriend

  1 replies

  14 years, 7 months ago

  By: Martin Schoombee

• user must change password at next login greyed out

  Hi Folks, I have a 2008 sql server and want to make my user to change password at next login. But w…

  AppSup_dba

  5 replies

  14 years, 7 months ago

  By: AppSup_dba

• Audit Trail / Logging Specific Changes on a Column by Column Basis

  I need to create an audit trail that easily identifies changes to a record. Part of the purpose of …

  david.holley

  28 replies

  14 years, 7 months ago

  By: david.holley

• Need t-sql script to backup a sql 2005 sp2 database with compression

  Need t-sql script to backup a sql 2005 sp2 database with compression. This is not working on SQL 2…

  Express12

  3 replies

  14 years, 7 months ago

  By: Express12

• replication issu es

  We finally get them to purge their data. The issue you had on the weekend of the 6th was that they …

  niravbhat

  3 replies

  14 years, 7 months ago

  By: Roy Ernest

• Change Tracking

  I have have just become a dba after being promoted and have been left a few solutions that I would …

  SSS_Dave

  4 replies

  14 years, 7 months ago

  By: SSS_Dave

• Getting NULL for Object Name when trying to decode sys.dm_tran_locks.resource_associated_entity_id

  I am getting a lot of NULL values for object name ([Parent Object] column in SQL below) when queryi…

  Marios Philippopoulos

  13 replies

  14 years, 7 months ago

  By: Aiello DBA