SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Looping with out While or Cursor

  i have a table with this structure: DECLARE @tblLeaveRec TABLE( intSlNoINT IDENTITY, txtEmpNo…

  pramod_yg

  9 replies

  15 years, 9 months ago

  By: pramod_yg

• sp_send_dbmail

  Well I am having a bit of a problem with the above... Basically I am trying to send an email to mu…

  grahamc

  1 replies

  15 years, 9 months ago

  By: grahamc

• Can we have 2 witness servers in sql server database mirroring?

  Can we have 2 witness servers in sql server database mirroring? -----------------------------------…

  forsqlserver

  3 replies

  15 years, 9 months ago

  By: forsqlserver

• Please help with a query

  Hi there, I have a database to track forex trades. See below for a DDL script. The orders table con…

  keymoo

  20 replies

  15 years, 9 months ago

  By: keymoo

• User mapping to database is lost

  Hi, I mapped a user to a specific database and gave read permissions. I then pressed ok. If I close…

  SatishAyyar

  9 replies

  15 years, 9 months ago

  By: Johan Bijnens

• Advantage of Stored Procedure?

  Is there any real advantage to using a stored procedure other than that it is modular / encapsulate…

  goodfu

  3 replies

  15 years, 9 months ago

  By: goodfu

• Using output of a Stored Procedure in an UPDATE statement

  I am almost finished changing a cursor bases stored procedure over to set based. Amost, because I …

  jerry-621596

  1 replies

  15 years, 9 months ago

  By: Evil Kraig F

• Can SQL 2008/2005 read SSIS packages created with SQL 2008 R2?

  Hi, I've just moved my primary system to Windows 7 and installed SSMS and BIDS for SQL 2008 R2. Al…

  samalex

  6 replies

  15 years, 9 months ago

  By: Alvin Ramard

• SQL 2008 R2 RTM

  Greetings all, Can somebody provide info on if the SQL 2008 SP1 bug fixes are included in the SQL 2…

  lorisj33

  2 replies

  15 years, 9 months ago

  By: Gail Shaw

• Detailed RAID explanation and question.

  I have had many discussions with folks about how to properly set up storage for use on a SQL Server…

  jpSQLDude

  2 replies

  15 years, 9 months ago

  By: jpSQLDude

• Microsofts Hotfix Site is Down?

  Hi everyone, I have been trying to download a Cumulative update for SQL 2008 R2 for 4 days - but th…

  dbaforever

  3 replies

  15 years, 9 months ago

  By: dbaforever

• REAL Sample Data available for free - better than fake!

  I was reading the discussion: http://www.sqlservercentral.com/Forums/Topic1013494-2758-1.aspx about…

  jpSQLDude

  3 replies

  15 years, 9 months ago

  By: Jeff Moden

• UK daylight saving and scheduling jobs

  Hi, Need a few pointers please. I have a SQL task that runs every 10 seconds, this task is used to…

  Fishbarnriots

  1 replies

  15 years, 9 months ago

  By: george sibbald

• Question about Inner Joins

  Hi Guys, Im trying to get my head around inner joins and at this precise moment in time i can figur…

  scott.atkins

  13 replies

  15 years, 9 months ago

  By: vamsi_jupudi

• In reporting services got this error "The permissions granted to user sysname\ASPNET are insufficient for performing this operation. (rsAccessDenied)"

  hi... i'm using sql server 2008 with advance services the below error is of reporting services.. "…

  vinayak.v

  1 replies

  15 years, 9 months ago

  By: Adiga