SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Transactional replication settings

  Hi, In my understanding, when you issue a large update or insert transaction on the publisher, it g…

  Roust_m

  2 replies

  14 years, 6 months ago

  By: M&M

• Stored Procedure Needed that Calls a Batch File/SSIS Package

  We are running SQL Server 2008. I created an SSIS package that runs on the file system of our netw…

  Anonymous

  3 replies

  14 years, 6 months ago

  By: Anonymous

• Trace File Naming Convention

  Hello, I'm a junior DBA and am trying to filter out specific event classes from the default trace f…

  basketman94

  2 replies

  14 years, 6 months ago

  By: basketman94

• Query on Check constraints

  The SQL server allows us to add multiple Check constraints for the same column in a table. I have a…

  hunt

  6 replies

  14 years, 6 months ago

  By: Lowell

• Need to change time on SQL server, how will this affect transactions?

  I have a SQL server that serves a intense webshop with ~3500 transactions every hour 24/7. I need t…

  martin-711967

  1 replies

  14 years, 6 months ago

  By: Gail Shaw

• Partitioned Table - is index aligned if different FG/scheme, but same Function?

  According to http://technet.microsoft.com/en-us/library/ms187526.aspx, "SQL Server does not align t…

  michael bourgon

  3 replies

  14 years, 6 months ago

  By: GSquared

• DB mail - Table in HTML Body - Adjust Font size

  A query result is shown as a table in html format in the Outlook mail. I can modify the header size…

  balasach82

  8 replies

  14 years, 6 months ago

  By: balasach82

• SQL SERVER Agent tool

  Hi All, In my one of production server i am not able to schedule backup reason is The SQL Agen…

  saidapurs

  5 replies

  14 years, 6 months ago

  By: nigel.

• using bcp for export query result to dbf file

  hi all. I use this code for export query result to xls file: bcp "use MaliGilan0622; select * from …

  elham_azizi_62

  1 replies

  14 years, 6 months ago

  By: OomBoom

• Backup Compression LiteSpeed Vs 2008 R2 Standard Edition

  We are migrating to sql 2008R2 standard edition which does have backup compression option.Currently…

  curious_sqldba

  6 replies

  14 years, 6 months ago

  By: Perry Whittle

• Making a Named Instance listen on a certain port.

  Hello, I just read an artical on configuring SQL Server to listen multiple ports and this was done …

  Duran

  11 replies

  14 years, 6 months ago

  By: govindarajan69

• Count of Records from different tables

  Hi , I need to get the count of records , where columns are from different tables.Below is my…

  komal145

  2 replies

  14 years, 6 months ago

  By: shivendrakumaryadav60

• a datafile manually restored, db yet inaccessible

  Hi, I'm using SQL Server 2008 on Windows 2003 Server. I've the done the following: 1. I opened SQL …

  ahmed_b72

  1 replies

  14 years, 6 months ago

  By: ahmed_b72

• Need to synch up data between LIVE and move to TEST/DEV - but need to preserve schema diffs on TEST/DEV

  We have our Dev, Test, and Live environments. We want to update Dev and Test to have current data f…

  Maxer

  8 replies

  14 years, 6 months ago

  By: Jo Pattyn

• Recursive Query

  Hello: in sql server 2008 r2 i have a table 'Table_One' ,this table have 3 fields : 1 - Id, 2 - Nam…

  Eskandari

  1 replies

  14 years, 6 months ago

  By: Nils Gustav Stråbø