SQL Server

Page 1474




  • Topics
    Replies
    Last post
  • Excel 2007 AcquireConnection error
    by RTInSeattle
    2 Replies
    Last post by vonpato
      • I'm creating a small test package that copies a value from an Excel 2007 worksheet into a SQL 2005 database (SP2). When I do an Execute Task, I get the following error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager \\lorip\MandEScorecards\SQLQueryExample.xlsx failed with error code 0xC0202009. However, i
  • Join and heavy tables
    by vihang
    1 Replies
    Last post by Jens K. Suessmeyer
      • Hi Team, I have a query about the way join works when it comes to dealing with heavily populated tables. I have two tables tableA and tableB each containing lakhs of records but one table is containing less records. The realistic count will be (TableA 100000, TableB 80000). Now when I am performing a join which table should on the left hand side and which table should be on the right hand side W
  • Updating an ADO recordset...
    by dhoops
    2 Replies
    Last post by Baba urf Sivaji
      • I'm updating an ADO recordset inside VB6... We just moved the database from SQL Server 2000 to SS2205.... The following code has worked a long-time now when it tries to update the record with SS2205 on the back-end I get a run-time error '3219' Operation is not allowed in this context... Here is the Open statement... SampleRecordset.Open "Select * from samplereleased_view"
  • SQL 2005 - Migration from SQL2000 / LEFT OUTER JOIN
    by Sascha05
    14 Replies
    Last post by Tom Phillips
      • Hi! I have to migrate an Application from SQL2000 on a SBS2000 to a SQL2005 on a SBS2003-Server (german version) (SP2 for SQL2005, all patches installed) I made an backup of the SQL2000-database and imported in SQL 2005. Everything looks fine, but some things are look quite weird: The application runs following SQL-Statement against the Server: (I verified this with the SQLpro
  • How group column to show side-by-side?
    by rcook349
    3 Replies
    Last post by giret
      • This is nasty question but... How can I take the following data from a table: ID ItemNumber Type 1 9830302 CD 2 9830302 Cassette And run a select statement to get me: ID ItemNumber Type 1 9830302 CD/Cassette Thanks, Ron
  • Need help with constraint statement
    by Kel Regor
    4 Replies
    Last post by ro3L
      • Hi guys, I was reading an SQL Server book and I came across the following query: CREATE Table dbo . CustomerToCustomerAddress ( CustomerID INT NOT NULL FOREIGN KEY ( CustomerID ) REFERENCES dbo . Customer ( CustomerID ), CustomerAddressID INT NOT NULL FOREIGN KEY ( CustomerAddressID ) REFERENCES dbo . CustomerAddress ( CustomerAddressI
  • Compatible with Visual Studio 2008 Beta 2?
    by Digilocity
    1 Replies
    Last post by nielsb
      • Is SQL Server 2008 July CTP compatible with Visual Studio 2008 Beta 2 (released last week) Specifically, are the versions of the .NET Framework Runtime identical If the answer to these questions is no, when can we expect to see compatible betas of both products Cheers!
  • can i remove visual studio after sql 2005 install?
    by Charlie___XXX
    1 Replies
    Last post by mrdenny
      • it's been a while since i installed sql2005, but doesn't visual studio get installed at the same time all the servers that i installed sql2005 on have visual studio on them too. the sysadmins think having VS on the servers is a security risk and want to remove it. if we remove VS from the servers, will that impact SQL Server 2005
  • Factorized association
    by Haggai
    2 Replies
    Last post by Haggai
      • Hello, LetĄ¯s say (for simplicity), in my site you can do one of two things ¨C look at products and buy products. I want to build an association structure between my products based on those two actions , but(!) when a user looks at two products it creates less important association than when the user actually bought those two products. So basically, I want to give a different factor base o
  • SQL Server 2005 SP 2 December CTP authentication fails
    by psc161
    14 Replies
    Last post by Sahil Girotra
      • Hi, if I try to install SP 2 using SQL Server authentification (sa) it fails. The following lines appear in the file "Hotfix.log": 01/03/2007 14:08:23.859 Authenticating user using SAPWD 01/03/2007 14:08:23.875 Validating database connections using Windows Authentication 01/03/2007 14:08:24.171 Pre-script database connection failed - continuing to wait for SQL service to become res
  • System.Data.OracleClient.OraclePermission Permission Denial
    by WildAndCrazy
    6 Replies
    Last post by WildAndCrazy
      • I am getting the following System.Data.OracleClient.OraclePermission Denial: "System.Security.SecurityException: Request for the permission of type 'System.Data.OracleClient.OraclePermission, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed." I am using SQL Server 2005 to connect to Oracle to pull data, format it then store the data into
  • Join on subquery with distinct?
    by Marko B. Simic
    11 Replies
    Last post by Rob Farley
      • Can someone give me some reasonable explanation why these two queries are performing dramatically different: First (slow): select tableA.column1, tableA.column2 from tableA join (select distinct col1,col2,col3 from myView) vw on vw.col1=tableA.col1 and vw.col2=tableA.col2 and vw.col3=tableA.col3 Second (fast): create table #tempTable (col1 varchar(200),col2 int,col3 varchar(200)) insert in
  • Update Statement
    by Whiz-kid
    2 Replies
    Last post by Whiz-kid
      • I have One Doubt on Update Statement. I have field value like ' xxx123456', 'xxx789654', 'xxx456987'. now I want to update taht value as last digit four ones like 'xxx121111', 'xxx781111', 'xxx451111' Please Help me out this Problem..
  • oledb source issues "<column Name> cannot be found in datasource"
    by davhas
    7 Replies
    Last post by davhas
      • Good morning, I have written a package which accepts variables for the server, initial catalog & table name. I execute sql to drop the following stored procedure, then following sql statement to create it. ================================================================ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE procedure [dbo].[SP_CreateMatch
  • Package Configuration in SSIS
    by Ramesh Chandran
    10 Replies
    Last post by jwelch
      • Hi, I am new to SSIS. I have an SSIS package which we are storing it in the application server ( not in SQL Server ). We are storing the database name etc.. in package configuration. Where should I store the configuration file In app server or in the database server. Also please tell how to execute the package stored as file system. Thanks ramesh
  • Problems after SQL Server 2005 SP2 install
    by RickN
    5 Replies
    Last post by Ivan Pavlovi?
      • I have two servers on the network running Windows Server 2003 Ent, .Net 2.0 and SQL Server 2005. I installed the Service Pack 2 upgrade to both and it said it installed successfully. Since then I have a strange new problem. I have a .Net app that runs on serverA and connects to the SQL instance on serverB. If I reboot serverA, the app runs fine. Within a short period of time, the app starts
  • Is SQL Server CE really the solution?
    by St&amp;#233;phane Beauchem
    14 Replies
    Last post by Stephane Beauchemin
      • Hi,   So far, with other programming platforms, I used to have the facility, embedded within application .exe, to:        1- Interface with already existing "multi-user" database (ex: Oracle, Access, etc.)        2- Create/access "local"/"Single-User" files for processing purposes.  (try to minimize
  • Need Execute SQL component to fail package if zero records
    by 1Dave
    4 Replies
    Last post by 1Dave
      • I have a SSIS package that has several Execute SQL Components. One of the first components reurns a Full Result Set of IDs based on a stored procedure call. The stored procedure can return multiple rows. I store the results to an ADO recordset (object variable) to be used later. I want the component to fail, and the package if the return of the stored procedure is zero records. What is the best wa
  • i acn't login to a sql server with Database Engine Tuning Advisor
    by molnarcs
    2 Replies
    Last post by Dan Ward
      • I'm trying to connect an instance (sql2005 standard edition) with the Database Engine Tuning Advisor (DETA), but it always fails. I get this message: "Failed to open a new connection.Failed to initialize MSDB database for tuning (exit code: -1073741819).(DTAClient)" The msdb database is exist on this server. What can i do
  • MDX question
    by jjsr
    6 Replies
    Last post by sjung
      • Hi, Here is my question. For the last year special store sales amount, we only calculate sales amount based on special store lists in current selected date. If a store in current date is not a special store then we do not include this store for last year sales amount (even if this store was special store in last year). This means we don't care about last year store status and we only iden
  • System.Data.SqlClient.SqlException: Timeout expired.
    by AlexBB
    7 Replies
    Last post by Andrea Montanari
      • Hi there, I am not sure it is the right forum. The Exception is thrown in C# app while saving a few databases. Small databases are being saved OK but this one has 12,934,142KB after the last backup. I am not even sure what the words "last backup" mean in this case. It is possible that is the size of the database from two months ago when first the problem appeared. Since then I've
  • Rebuild index failed
    by renching
    4 Replies
    Last post by widdowsj
      • I scheduled a maint plan to rebuild index. All table's indexes are successfully built except for one table. The error message I got: Failed:(-1073548784) Executing the query "ALTER INDEX [Index_name] ON [dbo].[table] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = ON ) "
  • VB6 RDO error
    by PhilEvans
    4 Replies
    Last post by Anton Klimov - MSFT
      • I've been given a legacy app that I have to change to point to a Sequel 2005 database (from a sequel 6.5 database). The app falls over when trying to execute a stored proc. The message I get is: Run-time error '40041': Object collection: Couldn't find item indicated by text The above message is displayed when the following line is executed: qryStoredPr
  • Date Parameter in Reports Manager
    by ifaber
    4 Replies
    Last post by ifaber
      • I have one master report and 4 linked reports. I deployed a report and set defaults for BeginDate and EndDate as =Today(). I have 4 linked reports that I need to change the date parameters for each. For instance the first linked reports needs to be BeginDate =Today() and the EndDate as =Today()+30. So in my linked report, I tried to change the EndDate to =Today()+30 and an error, 'The value provid
  • "The specified procedure could not found" error with SQL reporting services
    by schaturvedi
    0 Replies
    Last post by schaturvedi
      • Hi, I have a Microsoft CRM 3.0 setup where the CRM application and the SQL reporting services are all hosted on one website under IIS 6.0. The SQL server is on another server, with Kerberos delegation setup and working. By default the CRM services and Reporting services use "IWA" authentication in IIS. I am trying to integrate the CRM with a third party SSO provider. They have an ISAPI f