Answer Questions

• Fredm SSEUtil.exe SQL Server Express Utility

  All, When I try to start the SQL Server Express Utility (SSEUtil.exe), I get the following crash output message below ... I have checked all of my instances. The all work with windows authentication and sql server authentication. I have used the surface area configration manager to allow 'everything' and rebooted my machine. I have tested each through osql. I have turned my firewall on an off. The problem stilll persists. Could ...Show All

• shankarr SQLExpress w/Beta 2 VS -- Can't Create DB

  We have a clean Windows XP Install w/ Visual Studio 2005 Beta 2. I can not create a new database with SQLExpress... We have also been trying to connect to Oracle 10g.. And we constantly get cannot find TNS Names.ora, but we have easily configured this with another clean machine with VS.NET 2003.. What gives with 2005...I can't connect it to any database other than a SQLServer 2000 on another machine.... Please help!!! ...Show All

• BrianFerguson accessing report server programmatically

  Hi friends I have .net app ,where i display reports from my report server in a screen .,which works fine. I added a web reference to my report server ,to my solution to get it work. since i know my report server name on machine i added webreference to my project. but when i deploy at site ,as you can guess, the server name can be different. is it possible add web reference programmaically so that i dont need to hard code report server name a ...Show All

• Mark Beiley Failure to create first Replicated Database (SQL Mobile/SQL Server 2005) / Err 28627

  Hi, I'm trying to get my first replication going, and I have set up a database successfully, along with merge replication, however when I attempt to create the first subscriber, I get a permissions issue, regardless of what I do. In the SQLCESA30.LOG file, I get the following entries: 2006/01/07 16:59:36 Hr=00000000 SQLCESA30.DLL loaded 0 2006/01/07 16:59:58 Hr=80004005 ERR:OpenDB failed getting pub version 28627 I posted the initial th ...Show All

• Mark Arend derived column transformation expression

  Hi. I am using the following expression to check if the first charcter of a string is not the letter "E" and if it is, strip it off by selecting the remainder of the string: SUBSTRING([Derv.comno],1,1) == "E" SUBSTRING([Derv.comno],2,10) : [Derv.comno] This is ok in 99.9% of cases, but ideally I would like to be able to check, and alter the string if the first charcter is anything but numeric ...Show All

• Anonymous_2075 Win installer 3 is installed - Sql Server install says not!

  New installation of XP pro -with SP2. Installed .Net 2. Went to install Sql server 2005 express - complains Win installer 3 not installed Tried to install win installer 3 and says it is not needed What do I do next We actually require Windows Installer 3.1 for SQL Server installs. Can you install WI3.1 and try again Here's a link to it: http://www.microsoft.com/downloads/details.aspx familyid=889482FC-5F56 ...Show All

• johnny wisconsin Synchronisation using web service for PDA application

  I am developing a application on PDA using c# compact framework. I would like to do synchornisation of sql mobile 2005 database with sql server 2005 database using web service. The reason for going to webservice is based on the client request. Will anybody help me on this, how to perform conflict management etc. Hi again Perhaps you could give me some more information. What do you exactly mean, with w ...Show All

• n-k Distributing database with app

  Sorry if this something beaten to death already... What is/should be required for a target client machine to use and connect to a local copy of a SqlExpress database Can't seem to get a db connection established to a different machine through a VB6 app. Installed the sql native client on the machine, but still can't connect. What am I missing, or do I have to distribute/install the entire SqlExpress client Working fine from my development machin ...Show All

• Hemanth Cannot get Report Server to work

  I installed SQL Server 2005. I am trying to configure Team Foundation Server, but before installing it I want Report Server to work. The service logs in as the local administrator. Yet it seems like SQL Server doesn't like Administrator to much... Here's the log of the error when I try to browse reportserver.asmx from IIS. <Header>   <Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>   &l ...Show All

• Jodney Flat File Destination Filename with Date ?

  Is there a way to append a date at the end of the filename for whenever a Flat File Destination is run   So far, I only see the ability to browse to a static filename. either I'm missing something or this link doesn't work: ms-help://MS.VSCC.v80/MS.VSIPCC.v80/MS.SQLSVR.v9.en/extran9/html/a4bfc925-3ef6-431e-b1dd-7e0023d3a92d.htm "C:\\file" + (DT_WSTR, 2)month(getdate()) + (DT_WSTR, 2)day(getdate()) + (DT_WSTR,4)year(getdate( ...Show All

• jvlake SCD Historical Component not working

  I have an SCD that contains a historical output path. If I throw dataviewer in the flow before the SCD, I can see that it should trigger a trip down that lane, but its not. In the advanced editor, all looks good. Anything I can check. BTW, the datatype of the fields that should cause the SCD are datetime. thanks in advance A collegue figured it out. Shout out to my homeboy Joe! For those who ...Show All

• Chen_mcc can't get multiple values using reportItems

  On a report I have I have a hidden table which I am trying to get values from for a total. On a seperate table, I have an if statement that checks if a product # matches one on this table. This works fine if there is only one record in the hidden table. If there are more than one records, the ReportItems call only see's the last textbox (the last record) of the hidden table. Here's the total expression I use =IIf( sum(Fields!PickupDeliveryDet ...Show All

• paulinmadison Newbie question about Object transfer

  Hi, I'm new to Integration Services and I have a problem when I try to make a simple transfer of tables and views between 2 DB. The idea is to copy tables and views from DB1 to DB2. If the object exists in the target DB, it must be dropped, then created and the data must be copied. The problem occurs when a new object is created in the source DB and thus does not exist in the target DB. This throws an error because the system cannot ...Show All

• Bhasker import from Excel error

  While attempting to import data from Excel using SSMS and the import/export wizard, I received the following error: TITLE: SQL Server Import and Export Wizard An error occurred which the SQL Server Integration Services Wizard was not prepared to handle. ADDITIONAL INFORMATION: Exception has been thrown by the target of an invocation. (mscorlib) The connection type "EXCEL" specified for connection manager "{11CD789E-0DC ...Show All

• brob URGENT!!!! SSIS Configurations and SQL Jobs

    Hi there,   I've got an urgent thing I need to resolve.   I have a package that has a file connection. We have set the connection in the package for development - we also have the connection in a config file.   We are calling the package from SQL Jobs. In the step we call the package in, we try to set the value for the connection in the Data Source tab. However, the package does NOT use the value we ent ...Show All