SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• Monitoring date specific changes

  I have a Bookings table as such:- CREATE TABLE [dbo].[Bookings]( [Id] [int] IDENTITY(1,1) NOT NULL,…

  dtwilliams

  10 replies

  14 years, 5 months ago

  By: dtwilliams

• Statistics or index issue related to delete

  First of all, I am terribly sorry that I am not allowed to paste any code from the project I'm work…

  okbangas

  4 replies

  14 years, 5 months ago

  By: okbangas

• What is your total query processing time per day?

  Hello, just wanted to gauge my sql instance query processing time against others here in the forum.…

  pkennedy 77296

  2 replies

  14 years, 5 months ago

  By: MysteryJimbo

• Need help with SSIS Package...I want to pass input parameters

  Hi Everybody, Hope all is well I have created an SSIS package that pulls a column from a Sql Server…

  Pyman

  12 replies

  14 years, 5 months ago

  By: Pyman

• The permissions granted to user 'ABC\mssqlsrv' are insufficient for performing this operation. (rsAccessDenied)

  Hi, I have installed & configured SQL Server 2008 R2 on Server A The reporting services runs u…

  Mani-584606

  5 replies

  14 years, 5 months ago

  By: SQLRNNR

• Utility Control Point

  SQL Server has this pretty cool utility now that allows you to monitor multiple SQL Servers. This i…

  Jared

  4 replies

  14 years, 5 months ago

  By: Jared

• PowerShell, xp_cmdshell, and T-SQL

  I am currently working on learning PowerShell, but am still struggling with the general usage of it…

  Jared

  12 replies

  14 years, 5 months ago

  By: SQLRNNR

• restore with replace- what happens when files are different?

  Let's say for example, I have a staging database which I intend to refresh from a production backup…

  NJ-DBA

  7 replies

  14 years, 5 months ago

  By: NJ-DBA

• inserting records from another table and checking duplicates

  Good morning all, Please i need help as per an issue, i want to insert some records from one table …

  timotech

  5 replies

  14 years, 5 months ago

  By: timotech

• How to Update records of one table by selecting more than one rows from another table

  Update table1 set table1.foreginer='yes' where table1.PersonalID=(select table2.PersonalID …

  farhanfarooq82

  6 replies

  14 years, 5 months ago

  By: John Mitchell-245523

• Nested Union query?

  Hello, I'm trying to develop a report using Dynamics CRM tables using BIDS connecting to a SQL Serv…

  qutip

  6 replies

  14 years, 5 months ago

  By: GSquared

• string concatination

  Hi guys, Can any body help in below problem? Recordtype recidlocation --------------------------…

  Soft Developer

  1 replies

  14 years, 5 months ago

  By: Soft Developer

• How to configure SSRS 2008 R2 Subscription to send external mails.

  Hi All, Right now I am able to send mails through SSRS 2008 R2 subscription over the intranet, But …

  Hakuna Matata

  2 replies

  14 years, 5 months ago

  By: Hakuna Matata

• Does the Database Mail Task in SSIS use Database Mail?

  Does the Database Mail Task in SSIS use Database Mail? For better, quicker answers on T-SQL questio…

  Welsh Corgi

  9 replies

  14 years, 5 months ago

  By: Koen Verbeeck

• rsInvalidItemPath issue- full path must be less than 260 characters long

  We are having the ERP CRM non-profit application from Blackbaud and while creating the report on th…

  ssora-dba07

  1 replies

  14 years, 5 months ago

  By: KevinNicholas