Answer Questions

• EileenWin Best and quickest approach to importing thousands of 2 meg XML files into XMl column?

  Hi all, I intend to use SQL Server 2005 (which I haven't used before), to store hundreds of thousands of XML files this autumn and I'm trying to figure out which approach is the best to do this. These files are very complex (multiple nested elements) and use multiple namespaces (imports).The files will be on the same server as the Database. Below is a list of some ideas I have. 1) Use Some DTS process to import the XML files if possible in SQL Server 2005 2) Create a stored procedure that interates through a local directory, opens each XML file and inserts it's content into the database column using the bulkload method (any examples would be appreciated). Does this require the use of some scripting code such as VB script 3) Run a server-si ...Show All

• DOSST Replicating Stored Procedure permissions issue

  I'm having a problem replicating stored procedure permssions accross two sql server 2005 servers, using transactional replication. When I replicate tables, it's easy enough to send the permissions over from the subscriber since there is an option under the articles properties for "Copy permissions." I can't seem to find any such option for SPs, UDFs or views. Am I missing something So the other idea I had was to create a script to grant the proper permissions, and run it using sp_addexecscript to my publication. Currently I have two one-way transactional publications. One publication for all my tables, and another for SPs, UDFs and views. I can run sp_addexecscript on the publication containing all my tables with out a problem, ...Show All

• clint 2 Change Color of Textbox Depending on Value

  He is my question depending on the code field from my database I need to display a different color. The field is a detail in my table with just text displaying the title of the report. I have the actual code value in another column . I then go to the background color expression and am using this code: =Iif(First(Fields!Code.Value, "CodeDataset" ) = 3, "Green" , Iif(First(Fields!Code.Value, "CodeDataset" ) = 4, "Blue" , "Red" )) They all work if you pull the report up one at a time, but when selecting multi-values you get the color from the first record on each report page no matter what the second, third or so on values are. The code field does display each correct code. Is thi ...Show All

• paulchsu SQL 2005 database restore

  In SQL 2000, When I restore a database backup called "A" as "B" the datafile name and log file will change automatically with the new restored database name , whereas in SQL 2005 the datafile name and log file name remains with backup database name . Will this issue be addressed in next release of service pack. When you restore a database to database , the logical name stay the same as . The physical name can be or or [whatever/where-ever] you want. This is process is exactly the same in sql2k or sql2k5. The syntax for the restore is: restore database from disk='c:\ .bak' with move 'logical_ _data' to 'x:\new_ _or_ _data.mdf', move 'logical_ _log' to 'x:\new ...Show All

• Philipp Lamp where can i download IIS v6.0

  Where can I download this IIS v6.0. Try http://www.microsoft.com/downloads/details.aspx FamilyID=f9c1fb79-c903-4842-9f6c-9db93643fdb7&DisplayLang=en Dear friends, got the point, the iis 6.0 works with windows server 2003, iis 5.1 works with windows xp and iis 7 .... works with windows vista. but one can download and install iis 6.0 manager to manage the sites hosted on an iis 6.0 from windows xp. thanks, how to install iis v6.0 in windows xp professional well, it works with windows server 2003 very well. Thanks, Jwalant Natvarlal Soneji IIS 6.0 is not downloadable. It's part of Windows 2003 and you just need to install it. See here for install steps: ...Show All

• Zion_zii Analysis Services 2000 SP3 or SP3A - how to identify ?

  Hi, Is there a way to identify whether I have Analysis Services 2000 SP3 or SP3A Thank you very much. Code wise, you can read the registry on the server's LOCAL_MACHINE \ Software\Microsoft\OLAP Server\CurrentVersion and look at the VersionNum and CSDVersionNumber You can go to Help/About and Google your version number. Worked for me. ...Show All

• daveHassen Inserting XML values

  " Insert Into...Value" seems to be the command for inserting new data into an XML Doc. I have also seen people using "Insert...Value" without the "Into" keyword. Is there a difference between "Insert" and "Insert Into" thank you :-) There is no difference. 'INTO' is optional keyword for INSERT ... VALUES() statement. It's not only for insert xml value, but for all other sql types. ...Show All

• Juliano.net insert into a table by openXml and variable

  I have a table that should be filled by a stored procedure. Some of its columns are filled by xml data file and a column (ExGroup ) by a value. I’ve used OpenXml method for it but I don’t know how to define data of Exgroup by @exgroup value. My query is this:     set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go         ALTER   PROCEDURE [dbo] . [sp0] (             @strXML ntext , @exgroup int ) AS Declare @intPointer int exec sp_xml_preparedocument @intPointer output , @strXML Insert into Symbols_Stage ( symbol , longname , shortname , Exchange , ExGroup ) Select * from OpenXml ...Show All

• Soby Select GetDate() Just the month or year

  I wonder if someone can help me with getting JUST the month and year from SQL DB. Using the Select Getdate() Statement. If I need to use another one that would work that would be appretiated as well. Thanks! Here is one option: SELECT replace( right( convert( varchar(8), getdate(), 3 ), 5 ), '/', '' ) select month (getdate()), year(getdate()) select year(getdate()) % 100 I brought a smile to me also! If you want chars and need the leading zeroes: select right ('0' + convert (varchar (2), year(getdate()) % 100), 2) ( Thank you for the smiles; they are welcome ) Dave :-) Arnie Rowland wr ...Show All

• Jason Lodice sql server 2005 query analyser

  is there a query analyzer for sql server 2005 as in sql server 2000 bcoz i downloaded the 180 days evaluation version & installed it . i have worked with sql server 2000. but there is no query analyzer for 2005 how can i write queries & execute of course there is vs 2005 which has come with sql server 2005 evaluation copy. plz help! bcoz i really want to work with sql server 2005 thanks in advance for ur replies thanks for ur reply i installed the 180 days evaluation version but there is no sql server 2005 management studio Then you either did install the SQL Server Express edition or did not install the client tools of SQL Serv ...Show All

• NewName Error updating data in table that uses a trigger?

  Hello. I am new to SQL Server Management Studio 2005 and am using it to connect to a database on another machine running SQL Server 2000. Everything seems to work well, except when I try to edit table data on a particular table that has an update trigger associated with it. I am receiving the error: ------- The data in row 1 was not committed. Error Source: Microsoft.VisualStudio.DataTools. Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(5 rows). Correct the errors and retry or press ESC to chancel the changes. -------- I want it to update those the 5 rows in the other tables...that's the whole point of having the trigger! This used to work fine f ...Show All

• Diane D Problem using the textAlign expression

  I am trying to use an iif function in the textAlign property. =iif(A=B, left , center) I am getting an error on the left...it seems to be expecting arguments for the left function. How do I get around this thanks that worked. not a problem, Can you mark it as answers so that others will searching for answers will find our solution Ham Forscuis Try =IIF(A=B,"Left","Center") This is should resolve your issue. Ham ...Show All

• averge joe Problem writing to fixed width text file destination

  I am trying to export data from a query in SQL Server 2005 SSIS to a flat file destination. Everything works fine except the rows returned from my query are written to the flat file in one long string (i.e., without line breaks). I have tried appending a new line character to the rows returned from the query but that only throws an error when the package is executed. My rows returned from the query are 133 characters wide (essentially only one column per row) so I have set the properties accordingly for a fixed width file format with 133 character wide rows. Any suggestions or ideas on how to correct this would be greatly appreciated. Thank you, Michael What viewer are you using when looking at the text file Are you sure y ...Show All

• lordkarma Multi-step SSIS Job Hangs

  I have two SSIS packages that I want to run in one SQL Agent job as two individual steps. The two packages run fine when they are in separate jobs. However, when I run the job conaining both SSIS packages (under the same proxy), the first SSIS package starts, but hangs in the middle. I then tried setting the DelayValidation flag to True as suggested for a similar issue in another thread from this forum. After changing the DelayValidation flag to True for all containers and tasks on the second SSIS package, the first SSIS package ran completely through sucessfully, but the job continued executing for hours and the second SSIS package never started. I finally killed the job. Any ideas as to what is the problem here I have logged to th ...Show All

• FaWei Error while installing sql server 2005

  Need Help. I'm trying to install sql server 2005 on Windows server 2003 and got the following error message "The setup has encountered an unexpected error while setting up reporting service and share point exclusion path. The error is: Fatal error during installation." Not sure what to do next. Hi, see the screencast on my site how to configure a site-by-site installation with Reporting Services and Sharepoint HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- You need to have IIS installed on your machine for Reporting Service to get installed. Regards, Rajesh This is answered in Microsoft Knowledge Bas ...Show All