Answer Questions

• Keith Murray Nudging nodes up and down one position in SQL Server 2005

  With the following xml snippet, <folder id="B4790C9E-64B2-4818-B639-DB813A231A3F" name="oceans">   <folder id="26A62C24-51D0-42CB-9AEF-6A716F1BFE4" name="pacific" />   <folder id="77446ECF-5178-40BA-915B-2CD52B672452" name="atlantic" />   <folder id="AC78A55B-BDFF-473B-BC95-D113F23BC2C1" name="indian" /> </folder> I'd like to nudge the node for 'indian' above the node for 'atlantic' at the data ...Show All

• Ebaoll Always get one more blank page after group footer?

  hi, I have a report, basically, it has a table, and a group, and I checked the "Page break " at end in the group properties window. But when I run the report, between two group, there always is one more blank page there which is not what I want. If I clear that checkbox, the second data group did not change to a new page. So, I guess I should check the checkbox, but how to remove the blank page Thanks. ...Show All

• chaitanyapjk Stored Procedures in SQL 2005 Express

  Is it possible to create and use stored procedures in SQL 2005 Express As noted by someone else in an earlier post, you can right-click the stored procedures folder, get a template, code a stored procedure, and save it to a project file. However, whereas the earlier thread suggested that one could save the sp to the database by clicking !Execute, this does not work for me and I can find no other obvious way to make the sp accessible to my code-b ...Show All

• kr.Nitesh How can I query the appointed node in XML with XQuery quickly?

  I store the xml info below in the XML field in SQL 2005, I hope to query all the Folder node  with XQuery. The result  I hope to get <Folder Name="Root" Id="a6dce8fe-749c-4e38-ab2f-3d03d9711b3d">   <Folder Name="Card" Id="b8dcf8fe-749c-4e38-ab2f-6d03d9711b8j">   </Folder> </Folder>   ================ Stored  In XML field========================== <Folder Name="Root" Id=" ...Show All

• Oscar Calvo DTEXEC ReturnCode

  Hi, The DTEXEC Utility has the capability of returning ReturnCodes which have specific meanings e.g. ReturnCode=3 means: The package was canceled by the user. Is it possible to set my own ReturnCode values For example, my Package contains a Script Task which contains code to search a folder for a file. If the file cannot be found then I make the Script Task fail and hence the Package fails. But, when the Package is invoked by the D ...Show All

• Brian Mathis SQL Server 2005 equivalent to "Quiesce Database" for split mirror backup?

  We run on a SAN and we currently use a split-mirror setup to backup our non-Microsoft databases. We quiesce the database (which suspends all transactions), split the mirror, unquiesce the database, and backup the database from the split secondary disk. The quiesce/unquiesce takes a matter of seconds. Once the backup is done, we reconnect the mirror at the SAN level and it synchs back up. It works quite well. We would like to do something simi ...Show All

• CharlemagneJunior SQL 2005 CTP up to RTM

  I am installing SQL 2005 Developer Edition Sept CTP on the server which will hold production databases once the RTM is released.  Come November, do I need to backup the databases, uninstall CTP, install RTM version then restore the databases   I was told to basically expect our production deployment before November.  The developers basically are using the new features of Reporting Analysis, SQL Server etc.  I have mixed feeli ...Show All

• Dragan Panjkov Modifing XML document is too slow

  I need insert many dates from tables to XML file, I use T-SQL, everything is OK, but it works too slow. Is there another way Thanks' a lot. I use such sequence T-SQL: Declare @doc XML , @ixml nvarchar ( 4000 ) SELECT @ixml =( SELECT * FROM SAMPLE "d:SAMPLE" for XML AUTO ) SET @ixml = 'SET @Doc.modify('' declare namespace dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"; ...Show All

• Peder Reporting services and VBCrlf

  Hi,I have a textbox in the report that contains the VBCrlf for carrige return(enter) in the textbox. When i watch the report in the prieview tab in the VS.NET every thing is o.k. When i deploy the report and watch it in the report manager the VBCrlf has no effect. The html source shows the enter but without the <br> as it should be. I tried to inject <br> string to the textbox but the htmlencoding shows lt;btgt; Any id ...Show All

• Lloyd O. MIIS 2003

  Is there any way to make MIIS 2003 install with SQL 2005, or do I have to stay with SQL 2000 SP3 for all new MIIS 2003 implementations thanks, Azin So, is this the old DTS Hey all For completeness sake: MIIS (Microsoft Identity Integration Server 2003) will not currently install on SQL 2005 (but can be upgraded to SQL 2005). SQL 2005 is however NOT currently supported. This support should be added with MIIS 2003 SP2 (due to be ...Show All

• Syam SQL Server 2005 JDBC Driver 1.0 error in using XA datasource

  We are in the process of configuring a j2ee application with SQL Server 2005. We have downloaded the new version of SQL Server 2005 Java Database Connectivity (JDBC) Driver 1.0. We are having some issues in getting it to work using the XA datasource. Description of the error is as follows: javax.transaction.xa.XAException: java.sql.SQLException: Failed to create the XA control connection. Error: Could not find stored procedure 'maste ...Show All

• zarembisty Upgrade Express to 2005 CTP

  Is there a way to upgrade SQL express 2005 to SQL Server 2005 CTP Upgrades via Setup are not yet supported. You will need to uninstall Express, install the full CTP, and then attach your databases. Note: Uninstalling Express will not delete your databases. However, it will remove any users, jobs, etc you created. Dan ...Show All

• master_pete Oracle 9i -> SQL Server 2005: Snapshot agent aborts suddenly uninterrupted

  Hi - I hope some of you can help me with this problem. I'm trying to run the snapshot agent for 77 published tables, but the agent stops suddenly uninterrupted. It stops in the middle of taking a snapshot of a table containing 81,719,531 rows. The error message is pasted below. Message 2006-06-14 05:33:33.53 [89%] Bulk copied 100000 rows from "ORAMSSQLREPL"."HREPL_ARTICLE_21_21" (57200000 total rows copied) 2006-06-14 0 ...Show All

• mkurtbas DATENAME - can you not get it to say the actual day name??

  SELECT DATENAME(day, getdate()) AS 'Day Name' comes back as 15 but i want it to come back with thursday Cheers, Craig use dw   SELECT DATENAME(dw, getdate()) AS 'Day Name'   this stuff is clearly documented in BOL with in the section on datename what makes it worse is that i was sitting looking at datename page in BOL jsut one of those days where you cant see the wood for t ...Show All

• Brian.Nelson connecting using "datasource=localhost"

  hi all, i'm running VS2003.NET with SQL2000 on XP. when i try to use "datasource=localhost" in my connection string- i get "SQL server does not exist or access denide". (local) works and "=myServer" (server name) works. my hosts file is as it should be. i'm trying to connect to the server on my machine. i use to have no problem with it in the past. i think it all went to **** when i changed my machine's nam ...Show All