SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Compare Comma seprated values of two table in sql server 2005

  I have two Tables Table A and Table B In Table A there are two column UserId(int) and PermissionId(…

  ashu.sajwan

  2 replies

  11 years, 4 months ago

  By: Luis Cazares

• Image Rotation on SSRS Reports

  Hello! We have a requirement of displaying image on a report using SSRS. Images are stored in file …

  souvikbari

  1 replies

  11 years, 4 months ago

  By: alex_2356

• Need assistance in troubleshooting a KEY LOCK DEADLOCK

  Greetings, Chasing a deadlock that has me perplexed. Here is the errorlog output of a single deadlo…

  klharless

  1 replies

  11 years, 4 months ago

  By: klharless

• Clear Database Engine Server Name drop down

  I have managed to fat finger a number of database engine server names that do not exist and now wan…

  b-dubs

  7 replies

  11 years, 4 months ago

  By: David Burrows

• TempDB Write Latency

  Hi I have been reviewing a fairly large SQL environment and business owners have asked the usual qu…

  netsmurph

  2 replies

  11 years, 4 months ago

  By: netsmurph

• date format while inserting irrespective of regional settings

  as per my understanding If I pass a date to sql server to insert it will parse the date on the basi…

  tirthadip

  1 replies

  11 years, 4 months ago

  By: LutzM

• Restoring a sql backup from another server

  Hello: We have two sql servers one is HR uat and HR production. We want to refresh the HR uat serv…

  rpradel

  7 replies

  11 years, 4 months ago

  By: Divine Flame

• BackupDirectory is not available

  Hi, has anyone meet with this problem ? Yeasterday I have installed a new SQL Server 2005 side by s…

  eica

  2 replies

  11 years, 4 months ago

  By: amarpawar2012

• Which tables required to make payroll in this case

  I work in sql server 2005 and visual studio 2005 i want to make database for payroll only but i don…

  ahmed_elbarbary.2010

  1 replies

  11 years, 4 months ago

  By: Jeff Moden

• ALTER INDEX REORGANIZE Compacts pages that contain large object (LOB) data. Does rebuilding also do it?

  hi, ALTER INDEX REORGANIZE Compacts pages that contain large object (LOB) data. Does rebuilding als…

  rajemessage 14195

  1 replies

  11 years, 4 months ago

  By: Jeff Moden

• Error saving Excel document in varbinary(max) field

  Hello, We have a web site in asp.net where users can upload and save various documents. These are b…

  anoopk4u

  1 replies

  11 years, 4 months ago

  By: bonniereed346

• Select all months bewtween two dates

  Please help me in finding a query to get all months the between two dates.

  aneel.c

  11 replies

  11 years, 4 months ago

  By: Jeff Moden

• Sql Query Blocking

  Dear All In my production server keep on blocking Queries .What is a reason ? please…

  vs.satheesh

  2 replies

  11 years, 5 months ago

  By: Gail Shaw

• Locking in SQL Server 2005

  My requirement is a "Lock Table" which locks the table when some process is running ( i.e. no inser…

  ashu.sajwan

  2 replies

  11 years, 5 months ago

  By: ashu.sajwan

• Does sql job skips the secdulted time , if job takes more time to finsh than the scheduled time.

  Hi, I wanted to call a stored proc, on time basis , so i have made a job in sqlserver2008r2 and…

  rajemessage 14195

  3 replies

  11 years, 5 months ago

  By: Gail Shaw