SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Help needed

  Hi I have a excel were the date columns are in the format of YYYYMMDD and when am loading the da…

  Lucky9

  2 replies

  15 years, 4 months ago

  By: crazy4sql

• Database Mirroring error

  Hello, We are trying to enable mirroring on a database hosted on Windows XP professional.We are abl…

  SQLRO

  13 replies

  15 years, 4 months ago

  By: SQLRO

• CLR Strore Procedure to access fixed Disk info

  I am trying to write a CLR stored procedure to access the driveinfo object in IO. The code works fi…

  andymay-496937

  1 replies

  15 years, 4 months ago

  By: andymay-496937

• Hi, I have migrated a database from sql server 2000 instance to another sql server 2000 instance.So i have taken the backup of the Tenu001 database and i have restored it onto the target instance.Then later on i tried to transfer the logins and passwords from the source instance to the target insta

  Hi, I have migrated a database from sql server 2000 instance to another sql server 2000 instance.S…

  nikhil.theegela

  8 replies

  15 years, 4 months ago

  By: nikhil.theegela

• clustered or nonclustered index for UserId?

  We have a Table with this structure CREATE TABLE tblMessages ( [Id] [bigint] IDENTITY (1, 1) NOT N…

  adnani

  8 replies

  15 years, 4 months ago

  By: Jeff Moden

• SSIS Execute SQL Task

  Hi, first post so please be gentle.. I wasn't sure where to put this post, it's 2008 but SSIS, plea…

  andylovegrove

  4 replies

  15 years, 4 months ago

  By: andylovegrove

• 2008R2 Developer versus Standard Editions--how to convert

  I've got a situation where an employee accidentally installed the developer edition of SQL Server 2…

  lduvall

  1 replies

  15 years, 4 months ago

  By: jerry-621596

• backing up and restoring filegroup issues

  Greetings everyone, I am building a database across multiple file groups and there are situations …

  shannonjk

  2 replies

  15 years, 4 months ago

  By: shannonjk

• check position of value in string.

  want to create a table from this data, if possible. i used this to check the number of columns, SEL…

  ny66

  2 replies

  15 years, 4 months ago

  By: ny66

• AD Group Authentication to SQL 2008

  Hi All! I'm a regular reader here but first time poster 🙂 We recently moved to SQL 2008 Ent and are…

  cstewart-1126229

  14 replies

  15 years, 4 months ago

  By: Rick.Cornell.SME

• config sqlserver 2008 with ruby on rails

  Hi every one How are you my friends? I need your help 😛 I began to programming ruby for 2 weeks and…

  amirsanaii

  3 replies

  15 years, 4 months ago

  By: Henry Treftz

• Data importing from Notepad to sql server 2008

  I have the notepad data with spaces. I could not import the data into sql Server 2008. The data: 10…

  antonyp 46888

  2 replies

  15 years, 4 months ago

  By: steve-893342

• Older Foxpro .db (NOT.dbf) file import into Sql 2008

  I am looking to import some data from a group of Foxpro files. these have extension of .DB, .MB, .P…

  DavidNPD

  4 replies

  15 years, 4 months ago

  By: Steve Jones - SSC Editor

• Correlated MAX query in where clause, when there are more than one max value

  I have a sense that this should be straightforward, but am stuck so would very much appreciate some…

  steven.fleck

  4 replies

  15 years, 4 months ago

  By: steven.fleck

• Odd sort with BIN2 Collation and non-printable ASCII

  I'm trying to use the Latin1_General_BIN2 collation on a varchar column to ensure results are sorte…

  Chad Crawford

  7 replies

  15 years, 4 months ago

  By: Chad Crawford