SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• RE-Index is taking time

  Hi, I am facing one problem with re-index, while doing the re-index on 40gb database one table is t…

  BSLChennai

  1 replies

  13 years ago

  By: Sean Lange

• Passing multiple value to a parameter

  --Exec L1 'Bitumen VG 30 (60/70)' Alter Proc L1 @Itm Varchar(50) = NULL As Begin Set NoCou…

  yudy.varma

  2 replies

  13 years ago

  By: Sean Lange

• NEED SSIS,SSAS Coding Standard

  Hi Frnds I am looking for Some Coding Standards, that we need to keep in mind for implementing MSBI…

  deeep

  3 replies

  13 years ago

  By: andy.j

• Reg: Migration of Crystal reports to Sql 2005 Reporting Services

  Hi, i am working with web based ERP which was developed in .NET, and the reports we generated for o…

  pavan.sunkara

  10 replies

  13 years ago

  By: linda.w.sheng

• Needed database level permissions script for whole instance

  Hello, I cannot seem to find a script like this which would produce the users and their DATABASE LE…

  johnnyrmtl

  4 replies

  13 years ago

  By: Lowell

• after fragmentation

  We are using SQL2005. two weeks back , we run script for fragmentation, and found major tables wer…

  kshatriya24

  9 replies

  13 years ago

  By: Gail Shaw

• OLE Automation in T-SQL

  Hello, I have been trying to find any resources about OLE Automation in T-SQL. The problem right no…

  renu.iitkgp

  1 replies

  13 years ago

  By: Sigerson

• How to delete the oldest file in a given path. Assume some .txt file of the format File_MMDDYYYY.txt

  Can someone please help me....i have tried using for each loop, script task and file system task th…

  SS53217

  2 replies

  13 years ago

  By: SS53217

• How To Setup Server Side Only Alias (No Client Config Needed) For Named Instance Only SQL Installs

  How (if possible) can I setup a Server Side alias for a named instance on a server that has SQL 200…

  YSLGuru

  4 replies

  13 years ago

  By: YSLGuru

• sql server table valued function parameter issue

  Hi all, I got following table valued function (SQL Server 2005). I got an compile error when I run …

  nzhang6666

  10 replies

  13 years ago

  By: nzhang6666

• idle configuration for 1000-1200 concurent users

  Hi, i want to set up a database server in my company for 1000-1200 concurrent users. so i want to k…

  KcV

  2 replies

  13 years ago

  By: derek.colley

• Plan Caching in Sql Server 2005

  So I just read an article on Plan Caching that was extremely informative. http://msdn.microsoft.co…

  pamozer

  2 replies

  13 years ago

  By: pamozer

• How to dynamically assign colors to data

  Hello, i am generating a matrix report using Visual studio 2005. The report as data contains proje…

  avesh_h

  3 replies

  13 years ago

  By: Ant-Green

• "This file was created in a previous beta version of Excel 2007. Open the file with Excel 2007 to save it to the most recent version of the Excel 2007 file format before opening the file in Access 2007."

  Hi, I am using SSIS 2005. Got the source file in XLSX format. As 2007 format not supported in SSIS …

  sqlstud

  1 replies

  13 years ago

  By: Gail Shaw

• Using Parameters in Reporting services 2005

  Hi , i am trying to generate a report based on resource name. I have already added the @Res in my w…

  avesh_h

  2 replies

  13 years ago

  By: avesh_h