Answer Questions

• Brian Cecile Exporting data as XML file

  To get the data from the database table as an XML file we will use " for xml" clause in sql statement in SQLSERVER.   But i am not able to generate the following things in that XML file. please let me know how to get the following details in XML file using sql statement < xml version="1.0" encoding="UTF-8" > - < listOfIDXRefData xmlns =some url here>     ...Show All

• elix Error writing data to same destination in single data flow

  I am getting the following error running a data flow that splits the input data into multiple streams and writes the results of each stream to the same destination table: "This operation conflicts with another pending operation on this transaction. The operation failed." The flow starts with a single source table with one row per student and multiple scores for that student. It does a few lookups and then splits the stream (using ...Show All

• Alex Filo Create New SQL Server Mobile Edition Database

  Hi, I follow the instruction to install SQL Server 2005 Mobile Edition, but when I try to change the Data Source to add a new connection, I don't find "Create New SQL Server Mobile Edition Database". Does anyone know how to fix this Thanks Paolo Giorgio I just follow your step, but when i have to choose the Sql Mobile provider, " Microsoft SQL Server Mobile Edition" is not available, evenif i instal ...Show All

• Kikesegarra Error in SQL Server Management Studio Express when Attach DB

  Hello When I try to attach a Database in SSMSEE, I always receive the same error. After clicking on the "ADD"-Button in the "Attach Databases"-Window, the following error occurs: TITLE: Locate Database Files - ORION\SQLEXPRESS ------------------------------ C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA Cannot access the specified path or file on the server. Verify that you have the necessary security privilege ...Show All

• Gaea sql server management studio nov ctp

  I have vs2005 prof. installed along with sql express RTM I installed management studio nov ctp when I try to launch it, nothing happens any Ideas Thanks Microsoft SQL Server 2005 Books Online set this entry. I've deleted the "shell" key and the books online stop working. After this I reinstalled the BOL and Management Studio stopped working. Interesting. :) I installed SQL Server 2005 Express and Management Studio Express (CTP Novem ...Show All

• Chad Bumstead Mobile Replication

  Dear All, I need to make Sql Server Mobile replication with Sql Server 2005, could any body tell where can I find step by step procedure to make this Thanks and Regards hi it worked only after adding the snapshot_agent user to administrators group. thanks This article will get you started with using replication with SQL Server Mobile http://msdn2.microsoft ...Show All

• Freek Bos SQL Server Express Question partly related to ClickOnce

  Please see the thread linked below from the ClickOnce forum...(specifcially, please see my last post in the thread). Any help would be greatly appreciated! http://forums.microsoft.com/MSDN/showpost.aspx postid=171243&siteid=1 Did you find away to change this setting via the commandline I am trying to do the same thing. There are two places to find the full list o ...Show All

• frgu InvalidProgramException on Adapter.Fill

  Hi, Using VS2005, Framework 2 and SQL 2005 Mobile all from the recent launch in Australia, I have created a new Smartdevice project in c# and have created an SQL mobile database with 1 table in it. I added a datasource/dataset referencing the mobile database and it displayed the table/columns etc in the Data Sources Pane. I changed the table type to details, then dragged the table onto a blank form. VS created the form well and al ...Show All

• jen How to run an exe in the SSIS scripting task

  Hi, Can anyone help me how to run an exe file in the scripting task. I was trying the below code but it's giving an error. Set wshShell = WScript.CreateObject ("WSCript.shell") wshshell.run "c:\Test\ABC.exe", 6, True set wshshell = nothing   Thanks, rkn   I would be inclined to choose .NET's Process.Start method as the more language-neutral approach...but it's possible that this ...Show All

• Elzorro Management Studio Express CTP update now available

  There is a new Management Studio Express CTP download available at   http://www.microsoft.com/downloads/details.aspx FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en . This update fixes the defect where installing the full Books Online documentation prevented Management Studio Express from starting.  With the update, Management Studio Express and Books Online no longer interfere with each other. To update Management Stu ...Show All

• LUMING Start and Stop a server using SMO

  I am trying to stop and start a server using SMO in .net 2005.  I cannot find any function calls to do this on the server object like the old DMO has.  The MSDN help system is missing the example to show how this is done. If anyone knows how to do this I would really appreciate some help or sample code.  Thanks       This solution lists all of the sql2005 servers bu ...Show All

• Ruthc Detect whether executiontime or designtime in custom component

  In my custom component in the validate() method I want to determine whether this method is called during runtime or during designtime. I Can't find a property for this on PipelineComponent or ComponentMetaData. Is it possible Regards, Henk Well, during validation I want to access a package level variable that is filled with a lookup table by a preceding task. However, at designtime, there is no such thing as a ...Show All

• Anonym3 How to reduce the time when using a variable

  Hi, I have a table with column value like '123 345 678 143 648' like that. What I need to do is I have to take each code value and put it as a new record in another table. So, if I say 'Select substring(column_name,1,3) from table' then it is very fast (fraction of second). But since I need to take each code and the # of codes in each record may vary, I am using a while loop to take each code and so I delclared a variable @i and now my select ...Show All

• sgcook SQL2K5 SP1-CTP fails while upgrading "Database Services"

  Hello. I'm a little confused what went wrong on the SP1-CTP upgrade. Now, all three times I installed SP1-CTP, it failed to upgrade the "Database Services," but possibly for varying reasons Attempt 1: Received message about Pending Reboots, message about Full Text .dlls being locked. Stopped Full Text service, selected "Try Again," received "Failed" for "Database Services" component; successful for all other components. Rebooted. ...Show All

• Asha Subscriptions and Date Parameters

  Has anyone figured out how to set up subscriptions to a report that requires filtering the data for records where a date field falls between two dates Especially helpful is if someone has an elegant way to allow the user to select from options like "Today, Week To Date, Month To Date, Quarter To Date, Year To Date, Yesterday, Last Week, Last Month, Last Quarter, Last Year, Tomorrow, Next Week, Next Month, Next Quarter, Next Year". That way ...Show All