SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Stored procedure lost while migrating to new server

  We recently migrated a database from one server to another. I asked the DBA to move the database to…

  Ray Cacciatore

  3 replies

  14 years, 8 months ago

  By: Ray Cacciatore

• SSIS - ForEachLoop contains DF that fails at times. How can I keep iterating through loop?!

  Hello, A while back some folks on this forum helped me created a really good tool. I have a SSIS p…

  WebTechie

  1 replies

  14 years, 8 months ago

  By: MyDoggieJessie

• CONTAINSTABLE function not returning expected result

  We have a bizarre issue regarding the CONSTAINSTABLE function in SQL Server 2008 R2. We are attempt…

  Adam Kreul

  1 replies

  14 years, 8 months ago

  By: Adam Kreul

• Decryptbykey from inside of a view

  I am trying to create a view that will select fields from a table that has column-level encryption …

  DBAHeels

  8 replies

  14 years, 8 months ago

  By: DBAHeels

• How to receive the notification when subscription expires in transactional replication ?

  Hi All, How to receive the notification when subscription expires in transactional replication. Tha…

  deepak.a

  1 replies

  14 years, 8 months ago

  By: Jack Corbett

• Configure FILESTREAM in SQL Server 2008 R2

  Hi, I need to setup filestream for 3 Share point content databases I have performed the below for F…

  gary1

  1 replies

  14 years, 8 months ago

  By: gary1

• Join failing on char column

  Hi, I am experiencing weird behaviour on sql server today. Not sure what has changed. I have the f…

  Sridhar-137443

  5 replies

  14 years, 8 months ago

  By: SQLRNNR

• The maximum key length is 900 bytes

  Hi, I get this warning when I created the table Warning! The maximum key length is 900 bytes. The i…

  Krasavita

  2 replies

  14 years, 8 months ago

  By: weitzera

• here the subject of u r problem

  can u explain how to create a job step by step and uses of it..

  sandhya.msbi

  1 replies

  14 years, 8 months ago

  By: Jeff Moden

• Change IP address on prduction server

  Hi, 1. IPaddress -1 Installed sql server 2008 Enterprise edition, create database etc.. after that …

  SQL Galaxy

  3 replies

  14 years, 8 months ago

  By: Perry Whittle

• Database Size is not Expanding

  I have a DB that is presently 4gb and it says in the proerties that the spce available is only 20M…

  dstyles

  23 replies

  14 years, 8 months ago

  By: dstyles

• indexes, when to use include, vs when to use key columns

  Apart from the issue of size, which is addressed by included columns, does it matter if i place col…

  winston Smith

  4 replies

  14 years, 8 months ago

  By: Johan Bijnens

• Table Value Funcation Not Working

  Hi In One My of Database "Table Value Function" is not working properly what factor can i check. t…

  Diyas

  5 replies

  14 years, 8 months ago

  By: Diyas

• Two equivalent math expressions - one with variables, one with constants - give different results

  Can somebody explain why the two math expressions - one with variables, one with constants - give d…

  Tom John-342103

  5 replies

  14 years, 8 months ago

  By: SQLRNNR

• BCP not working

  Hi, i am running a BCP from SSMS, when i ran the BCP Going to that perticular server(taking remote)…

  pujain

  3 replies

  14 years, 8 months ago

  By: pujain