SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• issues installing security update for sql server 2008 R2 (KB2494088)

  Windows update tries to install the update and fails. Ive manually downloaded it ( 64bit as my inst…

  winston Smith

  4 replies

  14 years, 4 months ago

  By: Devendrakumar

• sp_lock showing locks with resource [encryption_scan]

  Hi All Just been diagnosing a bit of blocking on live, all resolved which is great. When running sp…

  Ant-Green

  3 replies

  14 years, 4 months ago

  By: Ant-Green

• varaibles in SQL Server

  please, can any body tell me how to declare and use variables, in a query any where u want.. pleas…

  madeeha.rehman5

  4 replies

  14 years, 4 months ago

  By: Devendrakumar

• can't login to new install of SQL 2008 x64 via SSMS

  I have performed a fresh install of SQL 2008 x64 on a fresh install of Server 2008 R2 x64 in an AD…

  tpcolson

  2 replies

  14 years, 4 months ago

  By: Ant-Green

• SQL Server 2005 to 2008 Migration.

  hi, i m going to migrate from sql server 2005 to sql server 2008 (SP3) what is prerequisite? please…

  Dhirju

  4 replies

  14 years, 4 months ago

  By: Dhirju

• Horizontal display

  Hi guys and girls I presently have a table for which the data is displayed as the following: G …

  frdrckmitchell7

  1 replies

  14 years, 4 months ago

  By: Ant-Green

• How to check data synchronization in tables both at Publisher and subscriber.

  We have configured transactional replication and We want to run a query that Will tell us the synch…

  azhar.iqbal499

  2 replies

  14 years, 4 months ago

  By: Suresh B.

• ssis package

  hi i am having 3 sub package..when my 1st package run success then only 2nd package will run..now m…

  sql Anand

  1 replies

  14 years, 4 months ago

  By: Koen Verbeeck

• Update only connection information in ssis package

  Update only connection information in ssis package Hi, I have created ssis package from code itself…

  swapnil.d13

  1 replies

  14 years, 4 months ago

  By: Suresh B.

• SQL Server 2008 - adding a node to a Win 2k8 cluster

  I'm trying to lab up SQL Server 2008 in a 2-node Windows 2008 cluster. I've got the Windows cluster…

  Matt Cherwin

  9 replies

  14 years, 4 months ago

  By: Hesselberg

• how to we create ssis package for database failover

  can please help me how can we create SSIS package on database failover. Thank you in advance.

  ARUN KUMAR AGUNURU

  1 replies

  14 years, 4 months ago

  By: okbangas

• SQL query to replace part of field in PHPMyAdmin

  Hi, I have a table called 'wp_postmeta' (WordPress) which contains a column called 'meta_value'. A …

  johnnada80

  1 replies

  14 years, 4 months ago

  By: johnnada80

• sp_cursoropen very slow on 1 table on 1 server but other tables/servers are ok

  This is a very wierd, major performance issue so any help/pointers, grately appreciated. We migrati…

  sotn

  15 replies

  14 years, 4 months ago

  By: sotn

• how to group and rank (with reset)

  How do I calculate the ranking and grouping column as shown below based on the following: acd …

  sjsubscribe

  11 replies

  14 years, 4 months ago

  By: Jeff Moden

• Formating numbers

  hi, I am trying to migrate a database from firebird to sqlserver So I translate stored procedures a…

  amigoface

  19 replies

  14 years, 4 months ago

  By: ScottPletcher