SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SSIS Data Flow Script doesn't execute PostExecute()

  I am using OpenRowSet to read a single row from an Excel spreadsheet and update the value of a pack…

  nano2nd

  5 replies

  14 years ago

  By: RBarryYoung

• Enter variables for SSIS package when run from Bat file

  Hi All, I have several strored procedures that are run by our Finance team that provide data that n…

  clarmatt73

  1 replies

  14 years ago

  By: RBarryYoung

• Virtual Server and SQL 2008 R2 disconnecting

  I am currently working on a problem where people are getting disconnected from SQL server. There d…

  tarastop

  4 replies

  14 years ago

  By: benjamin.reyes

• Installation error with SQL2008 R2

  While installing SQL2008 R2, I got the error: MsiGetProductInfo failed to retrieve ProductVersion f…

  Dung Dinh

  4 replies

  14 years ago

  By: Dung Dinh

• does ss2008 maintain an internal timestamp of data updates?

  Does SS2008 maintain an internal timestamp of data updates? For example, if I wanted to select the …

  sqlguy-736318

  10 replies

  14 years ago

  By: ScottPletcher

• Help me understand vendor provide calendar table

  Anyone like a good mystery? I am trying to query a vendor provided calendar structure. Running prof…

  Chrissy321

  10 replies

  14 years ago

  By: Chrissy321

• CPU usage in percentage

  Is there any query to know CPU utlisation of server?

  Alone

  1 replies

  14 years ago

  By: Ant-Green

• schema view in sql server

  Hi Is there a way of viewing the tables in management studio by schema? Id like to be able to expan…

  erics44

  3 replies

  14 years ago

  By: John Mitchell-245523

• Where to find subscription error log

  I want to see error log of my scheduled report. Below are the scenarios: Scenario 1: Let’s conside…

  rakesh_itcvrce

  4 replies

  14 years ago

  By: Geoff A

• Update the description property of a table in SQL Server

  Hello My problem is the following: I have a table (table A) that has several columns and each one …

  apostolis.karayiannis

  5 replies

  14 years ago

  By: vikingDBA

• How to get rid of old logs?

  Hi, When I open the Log File Viewer in my Management Studio, I have to wait a long time before all …

  Raymond van Laake

  1 replies

  14 years ago

  By: Ant-Green

• sys.dm_os_performance_counters - free space in tempdb (kb)

  Hi All Just a quick one to say how is the Free Space in TempDB (KB) metric under sys.dm_os_performa…

  Ant-Green

  1 replies

  14 years ago

  By: Ant-Green

• Need help to write query for the mentioned scenario in SQL Server 2008

  I have a table like this, IDFileCountFileSizeCountry 12150X 29500A 22100B 23200C 21…

  rakesh_itcvrce

  3 replies

  14 years ago

  By: vinu512

• Difference between 2008 and 2012 at ssis level?

  Hi, What are difference between 2008 and 2012 at ssis?

  SriSudha

  1 replies

  14 years ago

  By: Jay Pete

• import a txt file in sqlserver

  hi, is it possible to import a text file in sql server? in fact i have a list of data in a text for…

  marclas

  8 replies

  14 years ago

  By: Jeff Moden