Answer Questions

• Simone Romano Error when opening Designer

  When I try to open the designer (with exiting, e.g. tutorial or new project/package) I get the following error message: Microsoft Visual Studio is unable to load this document: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. After closing the project I have the following application event log error: Faulting application devenv.exe, version 8.0.50727.42, stamp 4333e699, ...Show All

• Craig Selbert Deployment of system

  I am about to start developing a system using VB 2003 and SQL Server 2000. On my development computer, I am going to use MSDE for the database, which I guess I will later be able to export to my client's SQL server 2000. Now, I am a bit worried. In my local computer, I can develop a system which runs locally very well. So, I am very sure I will be able to develop one for my client. But when I later deploy it to the client, it will have to run ...Show All

• Miroslav Endys Access web application is slow, should I upgrade to SQL server?

  Hi, first time poster/newbie here. I've got a football (soccer for the yanks!) predictions league website that is driven by and Access database. It basically calculates points scored for a user getting certain predictions correct. This is the URL: http://www.pool-predictions.co.uk/home/index.asp There are two sections of the site however that have almost ground to halt now that more users have registered throught the season. The p ...Show All

• Bill Barnett - MS ADOMD.NET 8.0 dependencies for connecting to both AS 2000 and AS 2005

  I've got a C# application developed with Visual Studio .Net 2003 which uses Adomd.net (8.0) to access cubes on SQL Server 2000 Analysis Services as well as SQL Server 2005 Analysis Services. In the MSDN reference page I noticed that I can set the connection parameter "ConnectTo=Default", and now, after installing the SQL Server 2005 Client Connectivity components, I can make connections to both AS2K and AS2K5 from my development machin ...Show All

• ThunderChildAU How to import *.mdf file

  I have a SQL Server 2005 database *.mdf file that I would like to import into another SQL Server 2005 engine on another computer. I don't see how to do this. How can I import a *.mdf file to create a copy of an exiisting database from another computer Thanks. Using Attach in the Object Explorer did the trick. Why can't they make this easier and more consistent with other software Why can't the ...Show All

• UZone More SSIS via the web

  Thanks to Michael Entin's help last week, I was able to execute a package via a .NET web application.  I have now moved my solution to the client's development server.  I can execute the packages via DTExecUI and DTExec, but my web application is failing.  The only difference between the two servers is the database server is installed on another box.  Will this be a problem Also, am I correct that the "Network Service" needs ...Show All

• JonnyOThan Some problem with creating diagram in SQL Management Studio.

  First of all, I want to say that there is no problem if I create DB in standard way, namely, when I create DB and then create some tables and so on. But, when I made restore from SQL Server 2000 backed up file I get next message: "Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTORIZATION s ...Show All

• summer_truth Using SQLExpress Manager to Create Database

  I got this error message when I tried to use an alternative place for the data files, I have checked the permissions on the destination directory, and I can't see any reason why this would happen ============================================= Create failed for Database 'Database_1'.  (Microsoft.SqlServer.Smo) ---------------------------------------- For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft SQL Server&ProdVer= ...Show All

• avatary2k Recommendations related to Skinning or rebadging SSRS portal

  Hi Experts!! We are interested in recommendations relating to "skinning" or rebadging the SSRS portal and related components to conform to our applications look and feel and also to better integrate our branding / logos etc. Please provide the required help or suggestions ASAP, at least a useful link wud also be fine. Thanks in Advance Shaun Unfortunately, your options are very limited here. There is some limited customization you can do ...Show All

• Marek Istvanek Error 8152: "String or binary data would be truncated"

  I've been working with a sample database that the company is using for testing purposes. I (we) did not create the database - it was sent over to us by another company. I'm still a rank newbie at working with MS SQL Server, though I've worked with Access and MySQL in the past. There is one table that contains bank information. At the moment, it is filled with information on imaginary (fake) banks. I need to change one record so that it contains ...Show All

• rsk7 Error Type 'System.Xml.XmlTextWriter' is not defined

  I use this Code in SSIS Destination Script Transforamtion:   Imports System   Imports System.Data   Imports System.Math   Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper   Imports Microsoft.SqlServer.Dts.Runtime.Wrapper   Imports System.Xml   Public Class ScriptMain   Inherits UserComponent   Dim xWriter As XmlTextWriter ' get this Error: Type 'System.Xml.XmlTextWriter' is not defined   Publ ...Show All

• glenberry EnumAvailableSqlServers does not return all instances

  Hello All, When I execute SmoApplication .EnumAvailableSqlServers("AServerNameHere"), passing in the hostname of a system I know to be running multiple instances (2x 2000 and 1 x 2005), it only returns/finds the default unnamed instance. I thought this could have been some form of security issue as per http://blogs.msdn.com/sql_protocols/archive/2005/09/24/473502.aspx , however this is not the case because: 1. When I execute ...Show All

• Golf67 Running Long Reports

  I have some reports that may take a long time (we're talking approximately 64k report pages long). And I'm not talking 64k pages of raw data from a stored procedure that returns millions of records. I have a couple of subreports that get repeated hundred of times. So on the report, I call a stored procedure that returns to me a thousand records, and for each record, I have a couple of subreports, which in turn, call their own stored procedures. ...Show All

• Dirk Strikwerda SQL Agent Job fail

  Hi, i've setup a sql agent job using a maintenance plan. As far as I know e.g. the database backup jobs are created as integration service packages. When I try to execute this sql job, an error message appears: SQL Server Scheduled Job 'BackupSSO' (0xDDC8AE8E9B2EF940919967FEBE70B85A) - Status: Failed - Invoked on: 2005-09-15 10:05:06 - Message: The job failed.  The Job was invoked by User WW001\claus.  The last step to run was step 1 ...Show All

• Kent_8848 from Express to 2005? - How to?

  I have a database on SQL 2005 Express and i want to restore in SQL Server 2005 Beta 2 but it's not accepting it so how can i do it please any tool design an SSIS package to export the database ..and in addition to that the license of beta is no longer valid since the RTM was published. if you want to move forward get a RTM version of developer or any version you want to migrate to. HTH, Jens Suessmeyer. --- http://www.sqlsevrer2 ...Show All