SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Should transaction log backups' file extension be .TRN or .BAK

  Or can you explain the difference? I use .BAK for db backups and .TRN for trans. backups. Also -d…

  SkyBox

  6 replies

  14 years, 10 months ago

  By: Suresh B.

• Suggestions for deleting large amount of records from a live, high-availability table

  I have a database, specifically ASPState, which the prior DBA moved over from another server withou…

  TheGreenShepherd

  10 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• How to modify a table outside of the current transaction ? ( with rollback and using linked server )

  Hi I have read somewhere that is is possible to define a loopback linked server ( pointing to the s…

  Tomasz M

  3 replies

  14 years, 10 months ago

  By: Paul White

• how can we use 'select' statement inside an 'Insert' Statement

  Hi Folks.... Need your suggestions..... I have a table named 'Transfer' which contains 680 rows/rec…

  tinnusqlserver

  7 replies

  14 years, 10 months ago

  By: Paul White

• Service Broker - duplicate message error

  I'm developing my first remote service broker project and I'm having a transient issue that I can't…

  Chad Crawford

  10 replies

  14 years, 10 months ago

  By: Evil Kraig F

• DATEADD FUNCTION

  Hi guys I have a simple query which generates a general activity table in SSRS 2008. In order to so…

  ByronOne

  11 replies

  14 years, 10 months ago

  By: Jeffrey Williams

• SQL 2008 - SSIS

  I am loading a number of .txt files into a table through SSIS using Looping (load all the files in …

  balasach82

  4 replies

  14 years, 10 months ago

  By: CGSJohnson

• connections

  Hi, we are using SQL Server 2008 version for our production server. right now we are auditing faile…

  hbk_sql

  1 replies

  14 years, 10 months ago

  By: Welsh Corgi

• Tracking Database Log File Sizes

  This forum has been very helpful to me over the last 2 years, so I thought I'd attempt to return th…

  Gail Wanabee

  7 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• Can't create a view inside and IF block?

  So, I have a database object creation/update script that has a problem with creating a view inside …

  buddy__a

  6 replies

  14 years, 10 months ago

  By: Michael Valentine Jones

• connect sql 2008R2 Express (x64) with 32 bit office, can it be done?

  USING Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Express Edition with Advanced Servic…

  Ian_McCann

  9 replies

  14 years, 10 months ago

  By: Ian_McCann

• collation

  I just notice in one of our database, some tables are in collation: Latin1_General_CI_AS Some table…

  sqlfriend

  10 replies

  14 years, 10 months ago

  By: Duncan Pryde

• issues with connecting to server for first time

  Here is what happened I have successfully installed SQL server 2008 on m…

  neeth

  5 replies

  14 years, 10 months ago

  By: neeth

• NEED: SQL Load Generator Tool?

  Hi, I need a tool which generates load on a sample database. Since I have the schema, I need to gi…

  asterman_3

  6 replies

  14 years, 10 months ago

  By: Ninja's_RGR'us

• security events in sql server 2008

  can we capture below security events in SQL Server 2008 connections to sql server logoffs and disco…

  HBK_4700

  2 replies

  14 years, 10 months ago

  By: HBK_4700