Answer Questions

• tjiwe concatenate a string within a loop from a temp table

  I need help. I have a large table that looks like this. (ID INT NOT NULL IDENTITY(1,1),PK INT , pocket VARCHAR(10)) 1, 1, p1 2, 1, p2 3, 2, p3 4, 2, p4 5, 3, p5 6, 3, p6 7, 4, p7 8, 5, p1 9, 5, p2 10,5, p83 i would like to loop through the table and concatenate the pocket filed for all the records that has the same pk. and insert the pk and the concatenated string into another table in a timely manner. can anyone help Emad ...Show All

• psn Can ODBC be used in Report Builder or Report Model?

  Dear All, Our company use DB2. When I download Report Builder from Report site or when I create Report Model project in VS, I can only use SQL Server Data Source. Can Report Builder or Report Model use ODBC Thank U. Not directly in this release. You can do it indirectly using SQL Server linked tables or by creating an Analysis Services cube first, then creating a report model on top of that. Where can I find the steps ...Show All

• David Swain ReportServerUrl element is not a valid configuration file element

  Hi, I get the error specified in the subject "ReportServerUrl element is not a valid configuration file element" ini the report manager if I replace <ReportServerUrl></ReportServerUrl> tags in RSWebApplication.cofig file with <ReportServerUrl>http://<computername>/ReportServer</ReportServerUrl> Any ideas why I should get that . If the element was not valid, it should not have worked ev ...Show All

• evans bcp out file including all the columns names

  How to bcp out file to also include all the table column names Thank you! If you need to know the column names that exist for a given BCP file, then you can create a format file during your bcp out.  For more information about format files, please see topic "Creating a Format File" in SQL Server 2005 Books Online. Users ask for it.  It was not my choice. What is the purpose of you wantin ...Show All

• Andy Lowen sending "Empty string" to a textbox on the report

  Hi All! I was checking the value of a field and if it is empty sending empty string to the textbox  if not only the first few values and it is working but on the empty field something like "#Error" is being displayed. here is the code: =Iif( Fields!Lname.Value <>””, Fields!Lname.Value .ToString().Substring(0,10), "" )   What I want to acheve is : If it is not zero to take the first 10 characters and if n ...Show All

• luvly_girl modify stored procedure

  In sql server 2005: If you right click on a stored procedure and select modify the word “create” is changed to “alter” everywhere in the stored procedure: Can anyone tell me the reason behind it Thanks That's becaue you can only create a stored procedure once (unless you drop it first), so if you want to modify an existing sp, then you need to use alter, which will alter the syscomments entry for th ...Show All

• Moonshadow Need urgent help

  Hi I have a strange situation. We have a middle teir application (j2ee appserver) that uses connection pooling. The client was working fine when all of a sudden it hangs. I have checked the sp_lock and sp_who2 and there has been no locking/blocking whatsover. This problem stays until we restart the app server. Is there any way that I can further dig into this problem and find it out if it is the db that is causing the issue. I us ...Show All

• pashford SSIS - Data Sources - Configure for deployment?

  I had posted this in the following pre-existing thread : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=89737&SiteID=1 Also wanted to start a thread on this to see if I can get some suggestions. Any suggestions on how to do this are appreciated. -------------------------------------------------------------------- Books-Online quote: >> In Integration Services, data sources are design-time objects that you use w ...Show All

• ZKing SQL Server 2005 is terribaly slow on x86 Intel Xeon Processor

  Sql 2000 server was working very fine on the same sever, I unistalled SQL 2000 and installed sql 2005 after which the applications which access 2005 is terribaly slow. The server config is like this Processsor : Intel Xeon RAM : 4gb ram OS Name Microsoft Windows Server 2003, Enterprise Edition Version 5.2.3790 Service Pack 1 Build 3790 Other OS Description Not Available OS Manufacturer Microsoft Corporation System Name BL ...Show All

• Micah Armantrout SQL Server 2005 Service Pack 1 - Timeframe?

  Is there any news on when SQL Server 2005 Service Pack 1 is scheduled for release ie. trying to schedule a project that doesn't want to go SQL 2005 until SP1 has been released. Well, your guess is as good as mine, but i figure it won't be long. Look here, MS has already released an update for the documentation of sql 2005: http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx which, imho, goes to show what ...Show All

• Tommy Tucker Failed to generate a user instance of SQL Server

  Hi, I have visual basic team 2005 beta that come with sql server express, and i am trying to connect to a database on my local computer. And i get this message "Failed to generate a user instance of SQL Server due to a failure instarting the process for the user instance. The connection will be closed". If u ever heard of the Northwind database it is the one i am trying to use I don't know much about how to configure server, but i ...Show All

• Milen Lazarov MSFT GUIDs using NEWSEQUENTIALID() on SQL Server Mobile

  Hello, I've been thinking about using GUIDs as primary keys within my application. One problem I have with this approach is that GUIDs generated with NEWID() are not sequential, and this can have a huge impact on insertion performance due to fragmented indexes. It would seem that NEWSEQUENTIALID() solves this issue, however it doesn't seem very practical to use this on SQL Server Mobile. With SQL Server, you can specify an OUTPUT clause for an I ...Show All

• dev2005 Failed to generate a user instance of SQL Server

  Hello Everyone, I have instaled SQLExpress September on my Windows Server 2003 Standard. and I work on a windows XP SP2 for development using Visual studio Web Edition (Beta2) which comes with sql server 2005 too. I've built my application and tested it on my computer and everything went fine. But When I copied the application to the server, it showed the following error: "Failed to generate a user instance of SQL Server due to failure in retr ...Show All

• Brian12184 AdventureWorks database not seen by Management Studio Express CTP

  When I install AdventureWorks.db for SQL Express, it runs without errors. The database files (data and logs) are in the SQL Express 2005 data directory. However, I can not see the database in Managment Studio Express CTP. I've tried repairing and uninstall/install again. Does not help. I have SQL Express 2005 cleanly installed. I have the pubs and Northwinds databases cleanly installed. (I was able to execute the queries that came for instal ...Show All

• hassanmushtaq Management Studio all databases . . .

  I see that Management Studio lists all databases, even ones that the user doesn't have access to.  I thought this was going to be fixed so I've been watching it from CTP to CTP throughout the year.  But I can see view a list of all databases on a server even if I'm simply a db_owner on one database.  I've tested this on the September CTP build. Microsoft posted a KB article to resolve this for Enterprise Manager (SQL 2000) just l ...Show All