Answer Questions

• AbbottF Question on Report Builder/Designer

  I have Visual Studio 2005 Team Developer. I don't need SQL2005 since I have SQL2000. How do I get Report Designer/Builder for VS2005 I would like to use the Report Designer/Builder to build reports for Windows applications. Do I HAVE to buy SQL 2005 Thanks. It is also an snap-in to Visual Studio. Everything I have read is that you use it to develop reports for Windows Apps, which is what I want to do. ...Show All

• Loknar - DBA Remove sources from a transaction

  Hello, I am attempting to run a (distributed) transaction in one of my data-flows. The data-flow loads data from a non-standard data source using a proprietary OLE DB Provider into SQL Server. When I run this I get these errors: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D008 "The requested isolation level is not valid or supported.".  An OLE DB error has occurred. Error c ...Show All

• Xtraeme Initializing SQL Server Reconciler has failed.

  Hi all ,     In my VB.NET application i have made a synchronization function which synchronize the data from a SQLCE SERVER 2000. till the data is less the synchronization happen well the data from the PDA database to the Desktop version database goes well but when we increase the data size in the syatem(desktop) or Pda the following error comes: 2. On synchronizing the data from the PDA database to the Sql database on th ...Show All

• Chris Ellis stored procedure return/result behaviour change from 2000 -> 2005 ?

  Hello, Can someone please help explain if the way MS SQL Server 2005 returns result from stored procedures is different from MS SQL Server 2000 The problem i am having is that i have lots of code that used to connect to SQL-2000 and did this: SqlDataAdapter da = new SqlDataAdapter(sqlCmd); ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) //process rows SqlCmd Type is a StoredProcedure btw, in SQL-2000 if the store ...Show All

• PJune Error 22029 on maint jobs

  OK this is a new error on me. I have a SQL server 2000 on Windows Server 2003. I have setup a Maint plan that backs up the user and system databases and the transaction Logs on my user databases. Does optimises and integrity checks on those databases as well. I am not attempting to repair any minor problems. I am not performing integrity checks before backing up the database and transaction logs. All of the databases that I am do ...Show All

• Jacob Bolan SQL 2005 release date?

  We are looking to do some software upgrades in our shop so we were wonder what the release date of SQL 2005 will be Thanks SQL Server 2005 (along with Visual Studio 2005) will be released in the week of November 7. See here for more info: http://weblogs.asp.net/fmarguerie/archive/2005/06/07/410676.aspx Hi, Nov 7th 2005 it is. Here is the official PressPass from Micros ...Show All

• TheDane New SQL Database?

  I posted this in "Visual Studio General" a few days ago, but got no response. I am running VSTS 2005, and I have Microsoft SQL Server 2005 Developer Edition installed on my machine. I would now like to create an application that has its own database file (.mdf) included. From within my VS project, I go to "Add New Item". I select "SQL Database", put in the name, and hit [Add]. At that point I get a message box wi ...Show All

• Soul ReportViewer control

  trying to build a test page with a single ReportViewer control < rsweb : ReportViewer ID ="ReportViewer1" ProcessingMode ="remote" runat ="server"> < ServerReport DisplayName ="VSTestReport" ReportPath ="MyReports/VSTestReport" ReportServerUrl ="http: //pugrs/reportserver"/> </ rsweb : ReportViewer >   build fails with 401: Unauthorized. Not even sure where to begin troubleshooting this one. ...Show All

• Kardath Combining XML Files

  I have to combine two seperate fixed-length flat files into 1 xml file, however, the catch is the 1st flat file (header) can/will be converted to an xml file but if there is another flat file *detail) found, then we must transform that to xml and combine into the header into one xml file. So, the standalone header xml file would look like this: <document> <tables> <header> <rows&g ...Show All

• iliketoeaticecream Disapearing Records

  The first line in my global.asax is the creation of an ActiveX object that will hold a data connection to a SQL2000 Server database for the lifespan of an "Application" scope. < OBJECT RUNAT="Server" SCOPE="Application" ID="Conn" name="Conn" PROGID="ADODB.Connection" VIEWASTEXT >< /OBJECT > With that done, every time a new user invokes global.asax, a routine will verify rather it needs to open the connection ...Show All

• Ben Fry FTP Task will not execute when scheduled as a job

  I have a job that runs a SQL script and creates a flat file. I use an FTP task to send the file to a specific FTP site. The job work beautifully when is is completed in the development environment. After I build the package and deploy on the SQL server and set it up to run as a job it will not work on the SQL server. The error appears to be in the FTP connection. I get two separate errors: 'Unable to connect to FTP Server using FTP Co ...Show All

• Asen Asenov MAS90 ODBC database to SQL 2005

  Good afternoon everyone I am trying to import data from mas90ODBC DSN into my SQL2005 DB. IN 2000 I was able to connect to an ODBC DSN but it seems that this option has been deprecated in 2005. Can someone please provide me with the best step by step instructions on how to go about importing my data. Um... you probably should check out Sage Best Talk online because they deal with Mas90. I, on the other hand hav ...Show All

• IK81 What is necessary to create SDF-Files on desktop legally?

  I want to write a PC application that prepares a SQL Server Mobile Files (.SDF) and sends it to a PocketPC. I get this error message: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU" If I install "SQL Server 2005 Express" the error message disappears and everything works fine. Question: Is it allowed to create SDF-Files if "SQL Server 2005 Express" ...Show All

• jaypatel Recover data from .mdf and .ldf file?

  Hello! Hopefully someone can help me with the following (potentially huge) problem: We've got a simple database application running on microsoft sql desktop engine. This database contains two tables. Up until now all worked fine, but probably due to a programma that crashed part of the database seems to be corrupted or broken while today only one table contains/returns data and the other table does not return any values! When I open the ...Show All

• Christian44 Remote connection to SQLEXPRESS doesn't work!

  Hello, OK. It is not possible for me to get remote connection to a ssqlexpress database (error 40). I tried everything posted in this forum, MSDN site etc., I used named pipes, TCP/IP ports, disabled Zone Alarm etc. it is just not working. I can coonect the Northwind database using SQL Server Management Studio Express CTP without any problem. And I am trying to learn creating databases, tables, stored procedures etc. by using code sampl ...Show All