SQL Server 2008 - General

• Topics

  Started by

  Posts

  Last post

• 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 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, 4 months ago

  By: GSquared

• string concatination

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

  Soft Developer

  1 replies

  14 years, 4 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, 4 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, 4 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, 4 months ago

  By: KevinNicholas

• Can we have MS Dynamic AX 2009 as a source in SSRS report ?

  Is this possible to have MS Dynamic AX 2009 as a source in SSRS report? How to do that and we can u…

  Ritesh_Dev

  1 replies

  14 years, 4 months ago

  By: Alexander Suprun

• can a non-serveradmin be enabled to drop a database?

  A Login with the serveradmin server role is allowed to drop a database. Can a Login with a non-ser…

  sqlguy-736318

  5 replies

  14 years, 4 months ago

  By: SQLRNNR

• No files copied using SQl Agent task CmdExec

  HI i am trying to copy a backup file from one server to another using sql agent job - CmdExec Task.…

  SQlLogic

  2 replies

  14 years, 4 months ago

  By: SQlLogic

• Sql Server will not start

  Is anybody having issues with SQL server not starting after the application of the December MS secu…

  Joshua D Gang

  11 replies

  14 years, 4 months ago

  By: old account - will s