SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• sql service cannot start

  * when I connect to sql server it displaying the following error: TITLE: Connect to Server --------…

  monshine

  9 replies

  13 years, 5 months ago

  By: Gail Shaw

• If Exists

  Hi Team, i've a table "LOC_TEST" with below columns "Text, Rights, Expiry" TEXTRIGHTSEXPIRY -----…

  Minnu

  1 replies

  13 years, 5 months ago

  By: Steve Jones - SSC Editor

• SSIS package fails in the scheduled job- How to add Decrypt password in command line - Any Example syntax please

  Hi Experts, I am trying to schedule a job with ssis package.. The error message is: SQL Server Exe…

  SQListic

  5 replies

  13 years, 5 months ago

  By: bernard.barnard

• SQL Query: Subtract data from consecutive rows uptil non zero value reached.

  I need to write a query to subtract data from consecutive rows uptil a non zero value is reached. F…

  npranj

  8 replies

  13 years, 5 months ago

  By: npranj

• Upgrade from 2005 to 2008

  Hi, I am trying to backup a db from SQL 2005 and trying to restore in SQL server 2008 with standby/…

  SQLisAwe5oMe

  5 replies

  13 years, 5 months ago

  By: jerry-621596

• what ports SQL uses

  hi guys, i have not changed anything in my sql server configuration, i know as a default the sql po…

  DBA-640728

  8 replies

  13 years, 5 months ago

  By: DBA-640728

• String to Rows question (quasi xml??)

  I haven't been able to apply the xml solutions to the kind of string I have in my data. I am lookin…

  Mindy Hreczuck

  2 replies

  13 years, 5 months ago

  By: Dwain Camps

• Server Hangs

  i had installed IIS 7.5 & SQL Server 2008 Std on Windows server 2008 R2 Std. over IBM Quad Co…

  jabinc

  10 replies

  13 years, 5 months ago

  By: Jeff Moden

• Best way to sync two databases?

  Hi, I have two SQL 2008r2 servers. They are mirror imges of each other (IP and name different). I n…

  krypto69

  8 replies

  13 years, 5 months ago

  By: SQL-Squid

• Query to find the start day of the week as Monday

  Hi All, How to specify the start day of the week as Monday for the below records I have tow fields …

  var05

  23 replies

  13 years, 5 months ago

  By: Jeff Moden

• Storage Space for Table, Column, and Index

  I am building a data mart for server metrics. Using the various system views I need to find disk s…

  cacapo

  6 replies

  13 years, 5 months ago

  By: Gail Shaw

• Understanding Inline TVFs

  I have only recently stumbled upon inline table valued functions. From all my reading, they are co…

  Jeff K

  2 replies

  13 years, 5 months ago

  By: Jeff K

• A quick and easy way to pull up table names, column names, and specific data structure

  This is another one of my fun little tools that I decided to share. There are times that I need to …

  jarid.lawson

  4 replies

  13 years, 5 months ago

  By: Lowell

• Update query - Performance tuning

  Good morning, I am trying to optimize the following query, which executes in 5 minutes and 45 secon…

  ivanball_76

  1 replies

  13 years, 5 months ago

  By: ivanball_76

• SET IDENTITY_INSERT [dbo].[tblTransactions] ON

  I have a trigger with the line "SET IDENTITY_INSERT [dbo].[tblTransactions] ON" but when I run the …

  DaveBriCam

  13 replies

  13 years, 5 months ago

  By: toddasd