SQL Server 2005 Strategies

• Topics

  Started by

  Posts

  Last post

• Two users get vastly different file sizes when using results to file option

  Hello, (I hope I'm posting this in the right place) We are exporting some tables to text to give to…

  replace('!','?')

  4 replies

  13 years, 3 months ago

  By: DBA_Dom

• Logshipping - Need full backup of Sencondary Database

  Hi, We've SQLServer 2005 logshipping configured on one of production database and the size of this …

  ravisamigo

  4 replies

  13 years, 3 months ago

  By: Bhuvnesh

• Parallel DB availability

  Hello Friends, I was wondering if you can help me finding a solution....We need to extract data on …

  sqlquest2575

  8 replies

  13 years, 3 months ago

  By: Bhuvnesh

• Backup Scenario

  Hi All my qns is i have 70GB space and how to take a full backup and database size is more that 120…

  satvinder.atwal

  2 replies

  13 years, 4 months ago

  By: Grant Fritchey

• How to check the database size

  dear all plz tell me which command to use to check the database size in all server that is prod.dev…

  satvinder.atwal

  1 replies

  13 years, 4 months ago

  By: rraja

• Archiving database in SQL Server

  Hello, We are currently running SQL Server 2005, and i need to archive data from databases in Produ…

  Dj463

  3 replies

  13 years, 4 months ago

  By: PaulB-TheOneAndOnly

• Rollback Update Statement

  I'm trying to prevent a user from updating a value in a table from b to a. Once the value becomes b…

  K Currie

  6 replies

  13 years, 5 months ago

  By: Eric M Russell

• SSRS

  Dear All, I have few queries on SSRS. Does SQLServer2008 R2 developer edition Supports the SSRS? Ca…

  ravisamigo

  8 replies

  13 years, 5 months ago

  By: Henrico Bekker

• Can I install Named instance without any default instance?

  Can I install Named instance without any default instance?

  jitendra.padhiyar

  3 replies

  13 years, 5 months ago

  By: Elliott Whitlow

• Parsing tab selimited text into SQL table

  Hello! I have a weekly tab delimited file that is currently being parsed row by row in .net code an…

  KirkEB

  13 replies

  13 years, 5 months ago

  By: Jeff Moden

• Query Hints - How To Combat Against

  We have a situation where our primary accounting software executes a query with a table hint that a…

  YSLGuru

  10 replies

  13 years, 5 months ago

  By: Rick-153145

• Is there a SET based alternative to using CURSOR for adding numbers of user defined and localized error message with sp_addmessage?

  Hi all. I've got a following situation: Temporary table #Temptable (msg_id, lang_id, severity, islo…

  Doc_saar

  2 replies

  13 years, 6 months ago

  By: Orlando Colamatteo

• deploy stored procedure from dev/test to production with different linked server names

  Hi guys, I have a 2005 instance with both a DEV and LIVE database with a stored procedure which ref…

  aaron.reese

  10 replies

  13 years, 6 months ago

  By: Jeff Moden

• Behavior of Partitioned Table in concurrent DML statement

  Hi All, I want to partition a table having more than 30lac data. But my concern is how it will beha…

  debanjan.ray

  5 replies

  13 years, 6 months ago

  By: Gail Shaw

• How to auto generate database object dreate scripts in SQL 2005?

  I used to use 6.5 a long time ago then I had a career break until recently; although many things ha…

  sharon.smith

  3 replies

  13 years, 7 months ago

  By: mvm219