SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• How to use Table Valued Parameter.

  Hi, I want to know how can I use the Table Valued Parameters when I am passing a datatable from ASP…

  manu.gupta2k1

  2 replies

  14 years, 7 months ago

  By: Sean Lange

• Named or Default Instance

  Hi good people, I am a new baby in SQL server but i love it am enjoying it every day now am expect…

  miranda1866

  2 replies

  14 years, 7 months ago

  By: shivendrakumaryadav60

• Script to restore backups on other SQL Server

  Hello, I am using the cheaper version of SQL (2008 R2 Web) that doesn't include replication. I need…

  Raymond van Laake

  12 replies

  14 years, 7 months ago

  By: Raymond van Laake

• Msg 802, Level 17, State 20, Line 1 There is insufficient memory available in the buffer pool.

  Hi, I am rebuilding the indexes for a database that's 120GB on my laptop. My laptop has windows 7 6…

  Pyman

  2 replies

  14 years, 7 months ago

  By: grahamc

• SSMS-Text Editor Font (Readability) affected automatically !

  [font="Verdana"]SSMS-Text Editor Font (Readability) affected automatically, and switched to old fas…

  Abrar Ahmad_

  1 replies

  14 years, 7 months ago

  By: Abrar Ahmad_

• Store Proc should return correct result

  Hi, I have Implemented logic for getting corrected records in my SP, but I need some bit help from …

  kiran.rajenimbalkar

  2 replies

  14 years, 7 months ago

  By: Gail Shaw

• How to map UK postcodes

  I am new to geographic data in 2008R2 and have a couple of basic questions. 1) I was wondering how …

  marks_262

  2 replies

  14 years, 7 months ago

  By: paul.knibbs

• Data Collector vs Utility Control Point

  Hi All Is there any differences between data collector and utility control point other than, the ce…

  Ant-Green

  5 replies

  14 years, 7 months ago

  By: hindle.steve

• How to delete record if error occurs ?

  I'm using two table for inserting Attendance of all students. tblAttendanceClasses - Save the reco…

  Ashwin9

  3 replies

  14 years, 7 months ago

  By: Gail Shaw

• Copying only the content of databases

  Hi, Is there any easy way to copy only the conten of databases like tables structures and others wi…

  Ryan007

  3 replies

  14 years, 7 months ago

  By: MyDoggieJessie

• SQLserver datetime and SSIS SCD issues

  I have a weird thing going on here. I've been searching for a long time with no real good answer. T…

  MajikTom

  1 replies

  14 years, 7 months ago

  By: MajikTom

• Need user to Create/Attach DB and then be immediate dbowner of the new DB

  I'm having some security related issues, and cannot google my way to a solution ... I'm hoping some…

  Paul Bradshaw

  36 replies

  14 years, 7 months ago

  By: Paul Bradshaw

• Job Notification

  Hi, I am not able to the email notifications when a job completed. The Alert System feature is se…

  Rem70Rem

  1 replies

  14 years, 7 months ago

  By: JeremyE

• SSIS Package Connection Manager

  Hi, I'm trying to replicate an issue with a package in prod and need to modify flat file connection…

  Lexa

  1 replies

  14 years, 7 months ago

  By: Lexa

• Updating multiple rows using Trigger

  I have a table named "computers_deviceprocessors" which contains 'id' as the PRIMARY KEY; 'computer…

  yap.clifford

  2 replies

  14 years, 7 months ago

  By: yap.clifford