SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Transactional replication between SQL2005 & SQL2008

  Afternoon, I am in the process of designing a process to transport data from our production databas…

  Danb7183

  1 replies

  13 years, 10 months ago

  By: Danb7183

• Sql Query

  Hi, I heard about a book. That book having only sql queries. but I forgot what 's exactly that book…

  mmmarks007

  3 replies

  13 years, 10 months ago

  By: mmmarks007

• sql start up problem

  hello : We have a CRM 4.0 and sql server 2005. as I deleted some contetnt on cm accidentally I had …

  nazanin6060

  3 replies

  13 years, 10 months ago

  By: Perry Whittle

• Major Stupidity on Sys Move

  Hi all, So im moving our 2005 data and with all my might I have managed to change the file location…

  Staggerlee

  20 replies

  13 years, 10 months ago

  By: SQLRNNR

• sp_send_dbmail Message size exceeds fixed maximum message size

  I receive the following error when trying to send a test e-mail to myself with attachments totallin…

  Frustrated

  4 replies

  13 years, 10 months ago

  By: Frustrated

• Multiple foreign key columns to same table

  I have a table (action) which contains a nullable column (creatorid) whose value, if provided, must…

  C D Brinkerhoff

  7 replies

  13 years, 10 months ago

  By: ushaikh

• The report server cannot open a connection to the report server database - exception

  We have SSRS and the database engine on the same box with the following configuration Microsoft SQL…

  Manoj Singh-176086

  11 replies

  13 years, 10 months ago

  By: gary1

• Error while eporting the table data to excel file using OPENROWSET function.

  Hi All, I am trying to export the table data to excel file using OPENROWSET sql function. my code i…

  Sarath Vellampalli

  1 replies

  13 years, 10 months ago

  By: seth delconte

• Server Trigger

  Hi, We have a DDL trigger on our server preventing access from Microsoft Office, Excel or Access ap…

  adb2303

  3 replies

  13 years, 10 months ago

  By: adb2303

• Full-Text / Noise Word

  Hi guys, I'm trying to convince SQL 2005 to do a full-text search for "Re/Max". The problem, from w…

  Peter Zolja

  2 replies

  13 years, 10 months ago

  By: rush_bal

• Making a Log file for Maintenance Plan

  Hi I'm trying to troubleshoot how long my reorg/indexing jobs are taking and what they are doing. I…

  C3PO's twin

  1 replies

  13 years, 10 months ago

  By: SQLSACT

• How to Get Month Using Given two Dates

  Hi All, I need a help on date Diff Concept.. I want to get the Month Number of Given t…

  farooq.hbs

  9 replies

  13 years, 10 months ago

  By: Andre Guerreiro

• make a Comma separated Sting of all ID in table

  i have one detail table having field as id,date,UID,coid at the end of the day i want to make sum o…

  ajaysanhotra

  1 replies

  13 years, 10 months ago

  By: BrainDonor

• Database email isn't sending email anymore.

  Greetings Gurus, I have a stored proc called sp_Reminder. It has 4 parameters: @Fullname, @Employee…

  simflex-897410

  5 replies

  13 years, 10 months ago

  By: Jeff Moden

• Limitation on the number of files

  Hello there, I am trying to create many XML files to File system, by single call to a stored proced…

  touchmeknot

  2 replies

  13 years, 11 months ago

  By: touchmeknot