SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• ILM 2007 to FIM 2010 database migration

  I have a 10gb ILM 2007 database, (6gb data, 4gb log) in production. The developers are telling me …

  alanspeckman

  1 replies

  13 years, 8 months ago

  By: alanspeckman

• Finding out network stats in SSIS

  I trolled the internet for some direction on this but I am unable to find out how to get the bandwi…

  rvphx

  1 replies

  13 years, 8 months ago

  By: Brandie Tarvin

• SSAS 2008 R2 SP1 and KB975783

  http://support.microsoft.com/kb/975783 I've got an SAP/BPC installation with an MDX query issue tha…

  Kudikai

  1 replies

  13 years, 8 months ago

  By: Charles Hearn

• SQL Server Needs Rebooting For First Time

  Hi, I have recently started a new role and the SQL Server needs rebooting over the weekend. However…

  gs1975

  3 replies

  13 years, 8 months ago

  By: free_mascot

• How to add code in this store procedure to void empty data?

  I use one store procedure to select data as below code: select * from ORDER where city='London' In …

  adonetok

  2 replies

  13 years, 8 months ago

  By: Sean Lange

• SCOM 2012 monitoring pack for SQL Server

  I'm researching this monitoring pack to add on to our current instance of SCOM 2012. Using Idera S…

  SkyBox

  1 replies

  13 years, 8 months ago

  By: BLOB EATER

• Blank the data in row from Position 50-74

  Hi, I want to blank the data in below line where row start will be always ZY05034 ,Then I have to r…

  Rakesh.Chaudhary

  8 replies

  13 years, 8 months ago

  By: Lynn Pettis

• Requeired Date format : 13 Sep, 2012

  Hi, am using below statement in a select statement, " e.expiration_date" is a date fromat column, …

  Minnu

  2 replies

  13 years, 8 months ago

  By: Lynn Pettis

• Text in New Line

  Hi , am having a select statement like below, Select record_id, msg_text from test Record IDMsg_t…

  Minnu

  1 replies

  13 years, 8 months ago

  By: Ant-Green

• error handling

  Hello, Can some one help me with a way that I can stop scripts from running if one of the scripts f…

  ugo boy

  2 replies

  13 years, 8 months ago

  By: ugo boy

• Update Column from Another Column - Plz check attachment

  Hello Experts, I have a table with a column called Z_Status: the values of this column are DUP and …

  ishchopra

  3 replies

  13 years, 8 months ago

  By: ishchopra

• Date Function

  Hi, am using below funtion to convert date, CREATE FUNCTION dbo.fnFormatDate ( @Datetime DATETIME,…

  Minnu

  1 replies

  13 years, 8 months ago

  By: Eugene Elutin

• Effect of adding update statistics as part of the stored procedure

  Hi, What are the negative effects of running update statistics on few tables as part of stored proc…

  praveen_vejandla

  2 replies

  13 years, 8 months ago

  By: Gail Shaw

• Using ROW_COUNT

  Hi Below is the code for my stored procedure Alter proc [dbo].[InvoiceDisplayTest] (@InvoiceNumber …

  mark.dungey 56406

  5 replies

  13 years, 8 months ago

  By: Gail Shaw

• Updateable Function Based SQL Index

  Hi, How do I create an updateable index from these index definitions: CREATE INDEX LibSort ON dbo.P…

  stanlyn

  2 replies

  13 years, 8 months ago

  By: stanlyn