SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Feedback On Proposed Drive/RAID Configuration For New SQL 2008R2 System

  I am no hardware expert and so when it comes to things like RAID configurations and Channels I'm no…

  YSLGuru

  22 replies

  14 years ago

  By: webtomte

• Insert Profiler output into a table without a trace (trc) file

  Hi all, I'm using a 2008 R2 server and want to log profiler output into a table. But while doing th…

  ecagirgan

  1 replies

  14 years ago

  By: Gail Shaw

• SQL Server Auditing in 2008R2

  Hi DBA'S I am enabling the SQL Server auditing to trace the changes in databases, Actually i enable…

  SQListic

  2 replies

  14 years ago

  By: Randall F Smith

• cursor loop

  BEGIN TRAN DECLARE @HUL_OUTLET_CODE VARCHAR(50) DECLARE @FGLAT FLOAT DECLARE @FGLONG FLOAT DECLARE…

  harishp06

  1 replies

  14 years ago

  By: Cadavre

• How to calculate timespan based in login in status

  I have a temporary table whose structure is a below. create table #temptime ( logtime datetime, …

  sqllearner-339367

  1 replies

  14 years ago

  By: sqllearner-339367

• Automate the sending the query result

  Hi I have a requirement where I need to send the query resukts to my co-ordinator. The query is to …

  VSSGeorge

  3 replies

  14 years ago

  By: Ant-Green

• Rollback Script

  Hi I have a simple stored procedure having a select statement. Recently I added a NOLOCK to the tab…

  VSSGeorge

  6 replies

  14 years ago

  By: VSSGeorge

• create YTD in a Table

  I want to obtain an YTD value for every year and on the same row I have to put the ytd value of pr…

  antonela

  16 replies

  14 years ago

  By: ChrisM@Work

• Order of TRY/CATCH and TRAN Blocks

  I've recently inherited a database that I've been working on for the last 6 months or so. I'm also…

  walshbd

  1 replies

  14 years ago

  By: Igor Micev

• How to upload images in a post in SQLSERVERCENTRAL forum ?

  How to upload images in a post in SQLSERVERCENTRAL forum ?

  SQListic

  10 replies

  14 years ago

  By: emile.milne

• SQl 2008 change collation of all columns

  HI, How can I change collation of all columns in sql 2008. I am getting error for keys. Is there an…

  mssqlsrv

  6 replies

  14 years ago

  By: mssqlsrv

• Replication Error due to Trigger

  Situation: I have setup transactional replication between 2 computers. In the publisher, there is a…

  alanlee

  1 replies

  14 years ago

  By: alanlee

• migrating ssrs 2005 to ssrs 2008

  Hi , i want to migrate the ssrs 2005 report to ssrs 2008 . Please let me know any solution

  Varaprasad_Tripuraribhotlavenkata

  4 replies

  14 years ago

  By: Varaprasad_Tripuraribhotlavenkata

• Sum(Sum(Field,Scope)) Syntax for SSRS Expression?

  Hey everyone, I'm building a report where I'm trying to write an expression for a variable (not pa…

  dj1202

  2 replies

  14 years ago

  By: dj1202

• Data type Conversion

  I have a column with data type as int. I converted the int data type to varchar to convert nulls to…

  f9c882q 61644

  1 replies

  14 years ago

  By: Dwain Camps