SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• SQL Licensing

  Hi there - We have multiple SQL environments, a few of them are production which run Enterprise ver…

  arrjay

  2 replies

  11 years, 12 months ago

  By: arrjay

• Create CSV file in SSIS

  I need to setup a SSIS Package that will execute a view then create a csv file into a file location…

  kbnyny

  1 replies

  11 years, 12 months ago

  By: pietlinden

• Case statement in Order By to sort on two columns

  I have this Order By statement: ORDER BY CASE WHEN @SortID = 1 AND @SortDirection = 'ASC' THEN…

  webskater

  9 replies

  11 years, 12 months ago

  By: Sean Lange

• SQL 2008R2 to 2008 R2 login/password migration

  Hello, I copied a database from SQL 2008R2 to another 2008 R2 server, then scripted SQL logins and …

  nasirmajeed

  3 replies

  11 years, 12 months ago

  By: JeremyE

• select query based on compare date and not datetime

  I want to retrieve all the records from a table where the ActiveFromDate(column with datetime datat…

  Annee

  9 replies

  11 years, 12 months ago

  By: BobMcClellan

• Inactive SPID

  I am trying to find the user name using SPID. This is not active SPID.Is there a way to find the us…

  Admingod

  1 replies

  11 years, 12 months ago

  By: SpeedySQL

• Trn log backup chain

  Hi all I have setup maintenance plan which does 2 full(12AM and 5AM) backups and trn log backup st…

  Barcelona10

  4 replies

  11 years, 12 months ago

  By: Jeff Moden

• Transform Dates Table Into Range Table

  I have a table of employee numbers and dates. Each record represents a date that the employee was …

  paul.j.kemna

  5 replies

  11 years, 12 months ago

  By: Sean Lange

• Running stored procedure jobs from a different server

  We have a sql instance "A" in server "1", where we have jobs that run stored procs locally and also…

  jtc900502

  1 replies

  11 years, 12 months ago

  By: joshdbguy

• Check for sum and null values

  Hi, select '$ '+ CONVERT(varchar,CONVERT(decimal(10,0),CONVERT(money, Amt_Value)),1) as [Amount] f…

  vigneshkumart50

  2 replies

  11 years, 12 months ago

  By: samalex

• Adding dummy values

  I have 2 related tables Case c and Subcase s (c.Case ID = s.Case ID: Case columns: CaseID Resolutio…

  Golden_Eye

  10 replies

  11 years, 12 months ago

  By: Sean Lange

• Blocking

  I have 2 different tables i.e. TABLE A and TABLE B . Activity on these tables is updating column va…

  Admingod

  7 replies

  11 years, 12 months ago

  By: Grant Fritchey

• sql svr conf manager The server threw an exception [0x80010105]

  Dear all, anyone can help? May be shared if there is ever experienced: The following server spec de…

  nusa_x

  3 replies

  11 years, 12 months ago

  By: nusa_x

• how to dissplay 0 days when enddata is empty or null in sql server.

  hi firends hi small doubt in sql server please tell me how to solve this issue. table :emp fromd…

  asranantha

  1 replies

  11 years, 12 months ago

  By: LinksUp

• Server-side trace to find SELECT *

  Hello experts, Is there any efficient way to set up a server-side trace to find queries that use 'S…

  webrunner

  5 replies

  11 years, 12 months ago

  By: webrunner