Answer Questions

• Ragh Using SQL Management Studio Express CTP to connect to a remote database provisioned bij the Windows Based Hosting Solution 3.5

  Hi All!! I was wondering if it's posible to connect to a remote database (in an other domain that is), by using Windows Authentication We are an ISP that uses the MPS (Microsoft Provisioning System) platform to provision al our IIS and SQL servers. We also use this platform to provision MS SQL 2005 databases (not supported bij de Windows Based Hosting Solution 3.5 at this moment, but it works fine over here). But when provisio ...Show All

• _Doug Export the data as an XML file?

  I have two tables in my database like this. AppsTable with columns INSTANCE_NAME, VALUE. SecondTable with columns UID,SID,XID I need the xml file like below. - - where commonID  is the Value of  UID from the second table, appInstance name is the instance_name from the appstable.           If i have values like this in second table: &nbs ...Show All

• WineForLife Can I get a value from a Matrix Cell?

  I know in a report we can use ReportItems to refer to a cell, however, will this work for a matrix How do I get values from a Matrix Cell ...Show All

• Ivan Fernandez microsoft.exceptionmessagebox.dll

  I wanted to use the SQL server SDK samples and i need the assembly microsoft.exceptionmessagebox.dll ; can you, please, tell me where i can find it is it installed by the SQL server installer with the DataBase engine integration services or something else i'm using SQL Server Express Edition. i looked in the directory " C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies " and i didn' find it. thanks. ...Show All

• Galb How to make tables & stored procedures in MSDE?

  Hello, I am a beginner using MSDE & Visual Basic.NET standard version (not Visual Studio.NET) . MSDE was downloaded from microsoft.com yesterday, which is sql2ksp3.exe. The problem is I don't know where to input data to set up tables or stored procedures after configured the MSDE. The MS Desktop Engine pops me "configuration sucessfully", then I can just open a small window with the title of "SQL Server Service Manag ...Show All

• Jeff Gebhart Random access in a result set

  I use an SQL task to produce a result set which I store in a package variable. It works fine to access the result set in a script task by first casting it to a ADODB.Recordset, and then enumerating it and accessing the rows in the given order. But is there a simple and clean way to randomly access the result set  In other words to repeatedly select a random row from it One thought I had was to conver ...Show All

• Dean Wagner searching xml column

  Hi I have a table that contains a xml column 'propertiesXML'. I would like to select all rows in this column where one of the nodes in the xml document starts with something (for example 'S'). If the propertiesXML column contains 3 rows: <properties> <property name="name">Sally</property> <property name="id">21003993</property> </properties> <properties> <property na ...Show All

• Santosh how to do equivalent of an outer join

  In the db, I have two tables - testcases and testresults. Test results have a field called testcaseid that corresponds to the id field in the testcases table. Not all test cases have results in the testresults table. Tests results have a field called "resultvalue" that can be "pass" or "fail". Test cases have a field called "area" that categories the feature the case belongs to. I want a pivot that show ...Show All

• Diester Create File Option In File Connection Manager

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• gearboxpc ~* Difference between RDL and RDLC *~

  hi, i am confused with RDL and RDLC. when to use RDL and RDLC.. can anyone help me out of this. Thanks in advance. Robert, Is it possible to get Report Designer for VS2005 Team Developer WITHOUT purchasing Report Server 2005 which includes BI Development Jim Why don't give google a try ;) http://www.google.de/search q=rdl+rdlc Q: What is the difference between RDL and RDLC ...Show All

• tvu4251 Management Studio to remember servers?

  If I "Connect" to different SQL Servers in Object Explorer, close and reopen SQL Management Studio, the list of Servers is Object Explorer is blank. Each time I need to re-connect to my list of SQL Severs. Anyone know how to get Management Studio to remember list of connctions in Object Explorer Thanks, Chris Skor I don't belive this is possible, and would probably be a bit too much. Do you use Registered ...Show All

• auser095 Feedback regarding Feedback on the Feedback Center

  Just a note to the MS guys... I'm fully supportive of the product Feedback Center initiative and the subsequent withdrawal of sqlwish. Problem is, if nobody ever gives us feedback on the things that we submit then it simply is a glorified version of sqlwish with no added value. I apologise if there are plans afoot to address to offer feedback to the things we put up there but I (and others) have been freely submitting bugs and sugge ...Show All

• Don.Frazier Setup: Invalid login information message (sp1)

  When running setup for the sql server 2005 sp1, 32bit, during the "authentication mode", I get a message saying: "Your account information could not be verified for one or more instances.  Ensure that you can connect to all the selected instances using the account information provided.  To proceed further, deselect the instances to which connectivity cannot be established." I selected windows authentication.  The other ch ...Show All

• srkrishnakumar Loop through each record and then each field within each record

  I need to essentially do 2 loops.  One loops through each record and then inside each record row, I want to perform an insert on each column. Something like this maybe using a cursor or something else: For each record in my table (I'll just use the cursor)      For each column in current record for cursor               perform some sql based on the current column value      Ne ...Show All

• Ham Selv But the SQL Server 2005 optimiser is inconsistent

  We are experiencing a problem in SQL Server 2005 Standard Edition (on x86 & x64, RTM & SP1 CTP1). The problem is we have a view which does something like "CREATE VIEW myView;SELECT * FROM MyTable WHERE ISNumeric(MyVal)=1" when you do "SELECT * FROM myView" you see a dataset which only contains numeric values. However it's clear that if you do "SELECT * FROM myView WHERE MyVal>5" that it is evaluating t ...Show All