SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Dashboard for a specific SP executions status

  I am required to provide a dashboard for recent and ongoing executions of specific stored procedure…

  Atif

  2 replies

  12 years, 1 months ago

  By: Atif

• Parametros desde un sp en 2008

  He implementado un Proc. Almacenado que retorna un consecutivo compuesto. Ej:TA-1. Requiero obtener…

  elkinfortiz

  4 replies

  12 years, 1 months ago

  By: Luis Cazares

• The log for database is not available; Database was shutdown due to error 9001 in routine 'XdesRMFull::Commit'.

  Testing and Production db's have lost connection to the translog 2 days in a row now. Today, my pr…

  SkyBox

  12 replies

  12 years, 1 months ago

  By: forsqlserver

• Reuse same tablix for multi pages (with different params)??

  Hi, I have report that could be run for multiple months, it's all the same, but I just found that …

  mario17

  1 replies

  12 years, 1 months ago

  By: mario17

• column with data type of csv list?

  I'd like to find the best option for saving a boatload (100K +) of csv lists to my SQL DB. Normal…

  bkmooney

  4 replies

  12 years, 1 months ago

  By: bkmooney

• Analysis database backup is failing from SQLAgent

  I followed the steps in below link to automate the analysis service database backup. But the job is…

  Mani-584606

  1 replies

  12 years, 1 months ago

  By: Mani-584606

• Rebuild Index

  When I right click on the index and select rebuild or reorganize, nothing happens. The indexes are …

  LearningDBA

  15 replies

  12 years, 1 months ago

  By: LearningDBA

• Copy files from one directory to another using code

  Hi there - I was wonder how you can copy all files with a certain file extension (.bak) from one lo…

  arrjay

  7 replies

  12 years, 1 months ago

  By: Jeff Moden

• How to reject parallelism in a query ?

  While tuning a S.P. for performance, I found that it better executes without parallelism. But I don…

  SQL Guy 1

  3 replies

  12 years, 1 months ago

  By: Jeff Moden

• How to Update a db field using MAX

  Hi Everyone. This is my code. update co set co.Uf_CoCompletedDate = MAX(inv_hdr.inv_date) FROM CO j…

  Gillian_Pappas2002

  4 replies

  12 years, 1 months ago

  By: Gillian_Pappas2002

• Extract text which is between 1st and 2nd comma

  [font="Verdana"]I want to select text which is between 1st and 2nd comma on SQL Server 2005 for Ex:…

  star_saty

  6 replies

  12 years, 1 months ago

  By: Jeff Moden

• SQL Login notification

  We have set up service accounts for applications but some time developers log in to servers using t…

  Tabbasum

  1 replies

  12 years, 1 months ago

  By: SQLRNNR

• Execute large number of insert statements

  I m trying to insert thousands of rows in a table and don't want to use the SSMS query windows beca…

  sp_who2

  7 replies

  12 years, 1 months ago

  By: Caruncles

• Query help

  declare @var varchar(max) = '@var1', @sql varchar(max) declare @var1 varchar(max) print @var set…

  Minnu

  10 replies

  12 years, 1 months ago

  By: Michael L John

• Must Declare Scalar Variable Error with IN Clause ?

  Hi I am using a multiselect parameter @DiagnosisType in SSRS report My sp states ... ALTER PROCED…

  jbalbo

  3 replies

  12 years, 1 months ago

  By: jbalbo