Answer Questions

• Najm Import all xml-Files from a Folder into SQL

  Hello I'm just starting with SQL and BIDS. I have created a xml-Import to SQL Server which works without any problem. Now I like to import (daily) all xml-files of an appropriate Folder at once to the DB. The files will have different names each day. I could not find any help in the internet to solve this problem. Can someone give me an Idea how to import many xml-files out of the same folder to SQL Thanks & regards Chaepp ...Show All

• Kevin Holand Why you can't set up in 'disabled status' a task in Data Flow layer???

  In Control Flow you can do that. its worth my mentioning my favourite 3rd party component here - the Trash Destination. http://www.sqlis.com/default.aspx 56 It terminates your data-paths without putting the data anywhere. Very useful for debugging! -Jamie Data Flow objects behave quite differently from Control Flow objects - disabling a transform may invalidate much that happens downstream. This is especially the case ...Show All

• Girija is it a bug ? (relationships in report builder)

  Hi friends am having some weird problem.am using sql server 2005 standard edition. i've a report model with tables (tab1,tab2,tab3). tab1 and tab2 (actually these are views) relate to same table but each has different columns from same table. the third table i.e. tab3 is child of tab1. in my report model project,i set cardinality of this role in tab3 as "one" and in tab1 as "Optionalmany". when creating a report in reportbuilder.if select colum ...Show All

• Mirz Does Full-text extract searchable metadata (Properties) from documents?

  When I create a full-text index on a word document for example. I want it to load metadata (property) fields that can be search independently from the word list. For example, queries like: cat and dog and (Author <contains> 'Mary Jones') This quarantees that Mary Jones only occurs in the word docs author metadata field and not within the document itself. The property fields for an email document would be: to, from, cc, bcc ...Show All

• thePrisoner06 Free space information in Management Studio

  In Enterprise Manager, the taskpad view showed me how much space is available in the data and log files. Is this information available anywhere in SSMS For instance, in one database EM shows me that I have 1200MB free in the data file and 400MB free in the log file. It also says, at the top of the taskpad view, that I have 0 free space in the database - I'm not sure how they relate, but in SSMS the only number that I can see is the 0. It also t ...Show All

• Harshal Right Hand Side Of Report is cut off

  I have a table control on a report that is when it is displayed it shows the right side of the report being cut off. If I go to the next page the report displays properly. When I go back to the first page it then displays properly. How can I get it to display properly the first time it is viewed Hi Trish, We are currently facing the same problem so I was wondering whether you already found a solution ...Show All

• GeLeTo Visual Studio 2003 & SQL Server 2005

  Is it posible application writen with Visual Studio 2003 to establish connection to SQL server 2005 You'll have to write your own, then :)   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < gorovvv@discussions.microsoft.com > wrote in message news:6841067f-f1e5-45f8-bf ...Show All

• kasakaimumbai Formatting text within cell

  I have multiple words within a single tablecell and need to be able to make one of them bold, not the entired contents of the tablecell, just one word within it. I can't find a way to do it. Can anyone help me out Thanks. As far as I am aware you can't differentially format text in a cell. Andrew Watt MVP - InfoPath wrote in message news:5fe80da2-bdd1-4e54-987d-31f576f8913c@discussions.microsoft. ...Show All

• Max Manowski Server Registration

  TITLE: Microsoft SQL Server Management Studio Express ------------------------------ An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 41 - Cannot open a Shared Memory connection to a remote SQL server) (Microsoft SQL Server, ...Show All

• ScubaSteve20001 SQL Server 2005 System Table (View?) Map

  Is there an estimate on the availability of the System Map for SQL2005 If it is already out there, would someone be so kind as to tell me how to get it Thanks, DO A poster that shows most of the SQL Server 2005 system views (catalog view and dynamic management views) and their relationships will be available in the December issue of SQL Server Magazine. Regards, The System views map for S ...Show All

• Pat. Can not provide a project to IIS

  I start the SQL 2005 - reporting services configuration assistant, he wants to start a view services and this is what i get: "System.ServiceProcess.TimeoutException: Der Vorgang wurde nicht abgeschlossen, da der Timeout abgelaufen ist. bei System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout) bei ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)" ...Show All

• KojiKato_MSFT looping through XML with xquery

  Hello, for example: declare @xml xml select @xml = (select * from table for xml raw, elements) ... now i want to iterate through @xml and get the values from field ID: declare @id int, @x int, @y int select @x = @xml.value('data(count(/*))','int') set @y = 1 while @y <= @x begin select @id = @xml.value('data(/row/ID)[' + cast(@y as varchar) + ']','int') set @y * @y + 1 end ... this is not working because for value() only string literals are ...Show All

• KClawson Audit Transformation error

  Hello all, I am getting an error that I am stuck on. I dragged the Audit Transformation for error handling (Flat File Source); however, the Audit Transformation is returning an error for one of the standard column "User name". I tried to change the length or take out this column, but the error does not go away. Below is the error message. Your help is much appreciated! -Lawrence "The length for "output column " ...Show All

• odul SQL 2005 Mobile Edition Error: The buffer pool is too small or there are too many open cursors.

  I am working with merge replication. The db server is running Windows 2003 Server Std x64 with SQL 2005 Std x64. The IIS server is running Windows 2003 Server Stx x86. The clients are Windows Mobile 5.0 running SQL 2005 Mobile. I have previously been able to get the test client to initialize a subscription to the publication. I made some changes recently and added about 7 tables, bringing the total articles to 104. Some of the articles have u ...Show All

• lgemcor Cant Install ReportBuilder The remote server returned an error: (401) Unauthorized.

  Hello, I have windows 2000 pro, theserver is on windows 2003. and I cant install report builder And I am the administrator of the server too! PLATFORM VERSION INFO Windows : 5.0.2195.262144 (Win32NT) Common Language Runtime : 2.0.50727.42 System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200) mscorwks.dll : 2.0.50727.42 (RTM.050727-4200) dfdll.dll : 2.0.50727.42 (RTM.050727-4200) dfshim.dll : 2.0.50727.42 (RTM.050727-4200) SOUR ...Show All