SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• help loop through rows to expand (date, number of months) to multiple rows

  I am trying to normalize some data, as follows: seq, date, months to apply ------------------------…

  dandenson

  6 replies

  14 years, 8 months ago

  By: LutzM

• coalesce (or alternative) PIVOT *into* CSV

  I can't figure out how to add a 'grouping' to the output of this. any help appreciated. Thanks curr…

  dandenson

  1 replies

  14 years, 8 months ago

  By: parthi-1705

• SSIS and SQL Server package configuration question

  Good afternoon. In developing an SSIS package, I configured it to use package configuration and st…

  CGSJohnson

  11 replies

  14 years, 8 months ago

  By: CGSJohnson

• SQL Naming Convention

  i would like to know which script do i use to rename user names from e.g john.munroe to johnmunroe …

  musa 84273

  1 replies

  14 years, 8 months ago

  By: Orlando Colamatteo

• Restore error

  Hello, Iam restoring the databse on sql serrver Express edition and am getting the following error.…

  ranuganti

  4 replies

  14 years, 8 months ago

  By: C.K.Shaiju

• Is possible to know who is using tempdb?

  Hello all I want to check how many space in tempdb is using each individual spid, is that possible?…

  ricardo_chicas

  5 replies

  14 years, 8 months ago

  By: ricardo_chicas

• How really works TRUNCATE TABLE?

  Hi. Question is simple. What does sqlsrv engine do with table after truncate command? Someone told …

  misiekbest

  2 replies

  14 years, 8 months ago

  By: Orlando Colamatteo

• problem setting the datasourse for a treeview

  Hi i have two tables and i want to populate a treeview using a left join query but i need a unique …

  kodekeeper

  3 replies

  14 years, 8 months ago

  By: kodekeeper

• SSRS sum() command excluding duplicate rows

  I have an SSRS report with a table linked to a procedure which contains invoice header and detail i…

  Chuck 17099

  2 replies

  14 years, 8 months ago

  By: Chuck 17099

• Looking for a Good diagramming tool

  Hoping to get a good recommendation on a database design/diagramming/modelling tool. Right now I'm …

  mtassin

  5 replies

  14 years, 8 months ago

  By: A.R.Ghazal

• Table is locked after restart SQL Service and server

  We have table that is locked. I tried to kill all SPID which holds the same table. Unsuccessful. I…

  zblagojevic

  4 replies

  14 years, 8 months ago

  By: Jeremy Leasor

• Updating ANSI NULLS setting on a stored procedure.

  Hi, When a stored procedure is created the settings for ANSI NULLS and QUOTED IDENTIFER which were …

  David McKinney

  3 replies

  14 years, 8 months ago

  By: Jeff Moden

• sql server 2008 installation

  Hi! I'm tryng to install sql server 2008 on windows 7, but I read in the microsoft site that to ins…

  borgexvw

  2 replies

  14 years, 8 months ago

  By: StarNamer

• The partner transaction manager has disabled its support for remote/network transactions

  When I try to execute a stored procedure on server a with distributed transaction which will update…

  sql_2005_fan

  1 replies

  14 years, 8 months ago

  By: saleemprivate-personal

• SQL server 2005 SSIS package will run on SQL 2008

  Hi, I have developed SSIS package in SQL 2008 environment. whether it will work in SQL server 200…

  suresh.n

  1 replies

  14 years, 8 months ago

  By: suresh.n