SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• dataconversion (yyyy-dd-mm to yyyy/dd/mm)

  need help with converting (yyyy-dd-mm to yyyy/dd/mm) using data conversion

  koolme_85

  8 replies

  14 years, 10 months ago

  By: Jeffrey Williams

• How do you use social media as a database professional? Students need your input! Chance to win $50 Amazon gift card!

  We are a group of students from Northwestern University and we need your help for our research. As …

  mage1gr

  1 replies

  14 years, 10 months ago

  By: Ron McCullough

• date time question

  Hello, I have two columns 'date' varchar (8) and 'time' varchar (4) I want to club 2 columns in to …

  ranuganti

  4 replies

  14 years, 10 months ago

  By: WayneS

• Linked Server (MYSQL) links ok, but cannot see tables and queries return errors

  I followed the steps in this article and successfully got a Linked Server on SSMS. http://www.ideae…

  mariann harper

  13 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• how to check if my database triggers and other objects are invoking tables that it's not exist

  Hello, I'm trying to know how to check if my database triggers and other objects are invoking tabl…

  Earl Downs

  7 replies

  14 years, 10 months ago

  By: Earl Downs

• Strange SQL 2008 R2 Missing Configuration Parameters?????

  Does anyone have any experience with this? How can this happen? I have a number of development ser…

  Melissa.Fischer

  1 replies

  14 years, 10 months ago

  By: jorgepc

• An Alternative for DISTINCT AND GROUP BY by using ROW_NUMBER()

  An Alternative for Distinct AND GROUP BY using row_number() How can I generate distinct values fr…

  ASFSDJG

  4 replies

  14 years, 10 months ago

  By: krisgomathi

• Recursively update tree item count

  I have a table as such that is self joining with child and parent IDs. There can be infinite level…

  SQLDev1

  3 replies

  14 years, 10 months ago

  By: Orlando Colamatteo

• Deploy SQL Database

  Hello... I am trying to build a deployment package for a couple of databases to automate the proces…

  sqlsponge2

  3 replies

  14 years, 10 months ago

  By: steveb.

• Need right direction to load monthly data

  I have to load monthly data in sql. Data comes from flatfile and loading in staging sql table throu…

  patla4u

  5 replies

  14 years, 10 months ago

  By: TheSQLGuru

• Grant permission to only few tables in DB 2008

  Hi, I need to give SELECT permission to only few tables and one view in a database to a SQL user. A…

  SqlSavvy

  1 replies

  14 years, 10 months ago

  By: SQLRNNR

• Moving a 2005 database that has legacy SQL2000 schemas to SQL 2008 R2.

  Hello everyone, I think I know what I am going to do, but I'd be crazy not to run it past you guys …

  Duran

  3 replies

  14 years, 10 months ago

  By: Welsh Corgi

• Failed to load msxmlsql.dll

  I am getting this error when i am trying to run DTA(db tuning advisor).Pls help me in fe=iguring ou…

  Manvendra

  1 replies

  14 years, 10 months ago

  By: Sean Lange

• Upgrade advisor

  I know this is early, but wondering if Microsoft has a tool to show you the deprecated features for…

  Sailor

  1 replies

  14 years, 10 months ago

  By: Sean Lange

• SqlServer 2008 installation error

  Hi all, I have installed Sql Server 2008 on my windows XP. now unistall it and I try to reinstall S…

  orkun çapraz

  3 replies

  14 years, 10 months ago

  By: FTdenali