SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• processor to instanses

  I have a server with 4 processors. Two instanses of SQL Server 2008 R2 is installed on the server. …

  Erik Hansson

  1 replies

  14 years, 8 months ago

  By: Grant Fritchey

• Differential backup fail

  Hi I am new to SQL Server. I am busy studying for the 70-450 exam and are working in a complete dif…

  pierrelessing

  4 replies

  14 years, 8 months ago

  By: Gail Shaw

• insert/bulk insert into a clustered index, how?

  Im reading up on compression, and the article mentions that you can bulk insert into a clustered in…

  winston Smith

  5 replies

  14 years, 8 months ago

  By: Gail Shaw

• Renamed Server Running DataPump for AS

  Hi all Slightly odd issue here, hope someone can point me in the right direction! We set up an anal…

  RichB

  1 replies

  14 years, 8 months ago

  By: RichB

• Assembly error when running SSIS package

  Hi We are running sql 2008 Enterprise R2. I have created a ssis package to retrive data from our A…

  @DJ

  1 replies

  14 years, 8 months ago

  By: @DJ

• call sql agent job in SQL or batch file and need return job failure or success status

  We have to use a batch file that we had a sqlcmd to start a sql agent job , in the batch file we us…

  sqlfriend

  2 replies

  14 years, 8 months ago

  By: sqlfriend

• Data Collection feature

  Hi, I've got the Data collection feature working on all my servers so when I click on "Data Collect…

  simon.letts

  2 replies

  14 years, 8 months ago

  By: simon.letts

• Issue with Database Mail

  Hi, I have scheduled multiple jobs using Database Mail on our production server. From 2nd of Septem…

  Hakuna Matata

  29 replies

  14 years, 8 months ago

  By: Hakuna Matata

• MONTHS AND QUATER

  I HAVE TABLE SOMETHING LIKE THIS: CREATE TABLE #Parm_Filter ( [Parm] [varchar](50) NULL, [PRMLabe…

  komal145

  5 replies

  14 years, 8 months ago

  By: Jeff Moden

• Clustered Key causing duplicate data error when processing olap cube

  Hi all, I have a Project Table that has primary key made up of two fields CompanyCode + ProjectCode…

  RollestonBandit

  1 replies

  14 years, 8 months ago

  By: RollestonBandit

• monitor free and used space

  Hello all, I was not sure where to post this question at. Thats why i started here. I have a …

  crazylifescary

  4 replies

  14 years, 8 months ago

  By: SQLRNNR

• License for SSMS?

  Hello all, Do I need a license to install SSMS 2008 R2 on my local workstation? I was under the imp…

  Chrissy321

  1 replies

  14 years, 8 months ago

  By: SQLRNNR

• SQL 2008 Memory Consumption report

  Buffer Pages Distribution report is showing a very high number of Stolen pages however everything e…

  nenea_nelu

  2 replies

  14 years, 8 months ago

  By: nenea_nelu

• Using Notification Services on a SQL 2008 server

  Hi We are currently upgrading one our servers from 2005 to 2008. One of the services running on the…

  Anders Hansen

  4 replies

  14 years, 8 months ago

  By: MaryAnnFL

• Syntax problem using SELECT.. IN (@variable)

  Hi Please can you advise the correct syntax when using a variable with a select statement that uses…

  J Livingston SQL

  3 replies

  14 years, 8 months ago

  By: tfifield