Answer Questions

• Dave_MEC Execution plan changes if inside/outside transaction

  Hi, let me introduce you the scenario of my problem: I have a temporary table (#export_news). I insert some id's into this table. Then I call stored procedure which assumes existence of this temporary table. This stored procedure consists from one select statement in which is this temporary table inner joined (temporary table is used to restrict the output just to record I am interested in). The problem is following:      &n ...Show All

• KnowsEnuf2BDangrous XML as Data Source for Reporting Services

  XML as Data Source for Reporting Services Reporting Services Express Edition cannot accept XML as DataSource . XML is a great technology, and it does not look like a "big deal" for Microsoft to let developers use XML as the DataSource for the Reporting, even in Express Edition How to convince Microsoft to revoke this limitation Thank you very much for attention. ...Show All

• baaba Web Services Task Editor: The input Web Services Description Language (WSDL) file is not valid

  I am trying to prove I can use SSIS to connect to a web service. The WS I am trying to connect to was developed by a vendor and covered by a NDA, but I was able to reproduce the issue with a public WS. Here are the steps to reproduce the issue: In the Web Services Connection Manager, I entered http://office.microsoft.com/Research/Providers/MoneyCentral.asmx wsdl in the URL window. I am able to successfully "test" the connectio ...Show All

• Krunchu SQL Table size

  Hello, If i want to know the size of table then how can i do it in SQL Server 2000 and in SQL Server 2005. -- how much amount of data can a table store in sql. -- On which thing the size of table depends. or Can anyone give me a introduction about the size of table in sql in SQL Server 2005 you can use CTE and ROW_NUMBER then the query would be this with ReturnFifthRow as ( select row_number () over ( o ...Show All

• pjhacker SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call

  Hi All, Iam using SQL Server Management Studio subscription wizzard to attempt to create a subscription from SQL Server Mobile to a publication on SQL Server 2005 CTP i got couple months ago. When i get to the end of the wizzard and press finish when it attempts to "Syncronizing Data" it then gives me a error as follows. "An incorrect or unsupported HTTP function call was made HRESULT 0x80004005 (28017)" Any help is appreciated. Thanks. ...Show All

• inthegroove SQL 2005 Mirroring... Remote Broker ID does not match the ID on the principal

  Hi, I'm trying to get database mirror working with SQL 2005... but I'm not having much luck. Any pointers would be appreciated. I've got 3 separate machines in a work group configuration. There isn't a primary dns suffix so I'm just using the simple machine names. I've configured the certificates, logins/users, and end points. On the mirror I do the ALTER DATABASE SET PARTNER and that works. On the primary I do the ALTER DATABASE SET PARTNER and ...Show All

• macky100 Set Report for Snapshot History via Web Service?

  Hello, Part of our Reporting Services 2005 implementation calls for the creation of a report (RDL) and uploading it to our RS server for deployment, all done programmatically.  We'd like to have the uploaded report set up for snapshot history.  Does anyone know how to do this programmatically through the web service   I know how to do it manually through Report Manager, but can't seem to find the right method calls to do i ...Show All

• microuser Data Flow Source for dbf (DBASE IV) files

  We're trying to read DBASE IV files as a source, but can't find any providers for that format. Will these be included in the final release Is there another way DBASE has always been supported, so it's kinda stranged. Thanks, Dirk It's been too long since my Support days to recall this error message. If you own Access, I would try importing your DBF file into Access. If that works, then we should be able to ...Show All

• Hubajube Show Parameter Selection on Page Header

  My first day using Reporting Services. I have a report parameter that has the following properties: Name: Region Multi-value Available Values = From query Label/Value examples: East/4160 North/869 South/6185 West/5315 The report Page Header needs to show the region(s) selected in a textbox named "SelectedRegion" and the body has a table that shows the filtered data from a stored procedure. What is the best way to populate the SelectedRe ...Show All

• Adama0 Can not open SQL Management Studio

  All of a sudden out of the blue today, Sql Server Management Studio refuses to load and open. I'm running Windows XP x64. Sql Server Dev. Edition x64. (Release version.. There were never Beta versions on the machine) When I open the program this dialog opens: --------------------------- Microsoft SQL Server Management Studio --------------------------- Package 'Microsoft SQL Management Studio Package' failed to load. -------- ...Show All

• narva SSIS SQL Agent Schedule job problem

  Hi everyone, I have a log table that track my SSIS scheduled jobs. This SQL Agent job runs every 15 minutes for now. The problem is, when I check the status(log) table, I see it fails and succeed at random. I have checked the history and I can't figure out why it is doing this. Has anyone any idea what is going on At least for the fact that the package succeeds after it failed shows that nothing is wrong with it. Again when I query my deti ...Show All

• andy1114 Importing Data From a Flat File

  Hi, I am trying to import data from a Flat File in SQL Server 2005, this used to be a simple task in SQL2K but for some reason isn't in SQL2K5. I am only trying to import part of the record not the whole thing and it keeps giving me this error: ************************************************************** MessagesWarning 0x80047076: Data Flow Task: The output column "Column 3" (19) on output "Flat File Source Output" (2) and component "Sou ...Show All

• Paulus178178 one to one relationship

  How do I create a one to one relationship in a SQL2005 Express database The foreign key needs to be the same as the primary key so it can't just increment to the next number. I found an @@Identity under the Programmability\Functions\System functions\Other Functions\ directory, but no @@SCOPE_IDENTITY. I have no idea how I would put it to use though. I found this in SQL2005, but not the SQL2005EXPRESS edition. ...Show All

• MeanOldDBA SQL DMO Support in SQL Server 2005...

  Hi,     We have a C++ application that uses the raw SQL DMO COM interfaces to connect to the SQL Server 2000. When this application tries to connect to SQL Server 2005, it failed to connect for obvious reasons. I tried to use the latest SQL DMO interfaces and, to my surprise, in the June CTP, I didn't find any header files that contains the COM interface definitions for the latest SQL DMO. Is this something that MS ...Show All

• Oussou error 1603 when installing sql server 2005 sept ctp

  I tried to install SQL Server 2005 Sept CTP and it gave error 1603 when installing MS SQL native client. What should I do As a first step, I suggest you tell us more about your setup, which build you are attempting to install and whether you had a previous build of SQL Server 2005 or Visual Studio 2005 on the machine. That would help us understand a little more about your situation. Andrew Watt ...Show All