Answer Questions

• kevinzx Connections in Pool Not Being Reused

  I have a form that has a number of database calls. It does these sequentially. In some cases it's not possible (due to archetecture more than anything) to make these calls all on the same connection. However it does open then close the connection. (all connections created are in using statements) What I'm seeing is that we're getting a timeout when the 100 connection limit is hit. Looking at Activity Monitor I can see these connections growing and growing over time in the activity monitor the more windows you open and close even though these connections are closed. (and they all use exactly the same connection string) I read that it might be because of SQL Debugging being turned on in vs.net, but that is not enabled in either debug o ...Show All

• Roger Andersen problem connecting to database server with distributed SRS install

  Hi, I have a sql server 2005 database server that is remote to my SRS intall (SRS is installed on a separate IIS server). The install goes fine, the SRS config all shows green - but when trying to connect via IE ( http://servername/reports ) I get an error that it cannot make a connection to the database: The weird thing is that it is showing the computer account as having login failed instead of my user account (which it just asked prompted me for). I have changed nothing on the IIS server, but the dba's have changed some stuff on the sql install i'm pretty sure. Can anyone tell me what needs to be enabled for this default SRS install to work What could they have changed on the sql server to make it do this or...How can I stop ...Show All

• Kapoulkine Arseny Upgrading Reporting Services 2005

  Hello all, I have a SQL Server 2005 64-bit Standard Edition install of the database engine and Reporting Services on a server. The BI team would like us to upgrade the server from Standard Edition to Enterprise Edition of SQL Server and Reporting Services to take advantage of data driven subscriptions. Does anyone know if this is a straightforward upgrade (another words .. install EE on top of SE), or is it better to backup the databases, remove SQL Server and RS, do a clean install, and restore the databases back to the server Thanks, Eric Eric, You should be able to just run EE setup.exe and it will upgrade the edition. It is recommended to backup the RS databases (in Management Studio) ...Show All

• Robertis Tongbram SMSS SQL SERVER 2005 canned reports greyed out

  How does one make the canned SMSS reports such as disk usage available from 1.) Local workstation for administrators of SQL can run then on SQL instances from the Object view of Management studio. All we see is the reports tab greyed out. 2.)From a reports server. Yes, I know these seems rather basic but it seems there is a right way to make this occur and a wrong way. MDSN has yet to give up this information to me. If anyone knows the links or answers kindly post in the blog and also email me at brucehelp@yahoo.com . This link covers the discussion but does not have the methods to achieve the installation of the canned reports. http://blogs.msdn.com/sqlrem/archive/2006/05/16/SSMS_Reports_1.aspx "Did ...Show All

• Luke Breuer Linked server problem

  hey, I have a sql server 2005 an I want to have a linked server to itself. I have made a linked server an gave it enough rights. When I do want to query all the tables I get the following error Msg 11001, Level 16, State 1, Line 0 TCP Provider: No such host is known. Does anybody know what the problem could bee Please post the commands you used to set up the linked server. Thanks Laurentiu It is good to know what is asked above, and the error could be due to a misconfigured linked server, but they could also be due to network or hardware issues. Of course, these errors abort the entire batch, so whether or not the rest of your code requires the remote server to be active, it still terminates. Hi ...Show All

• TonyX852 Increase activation time

  Is there any way to increase the activation time, i.e. the time between service broker creating a new instance of the activation SP. What I want is to be able to have x activation procs running currently it takes x * 5 seconds to get them all running. For a demo thats not great. Well if it's just for a demo, why don't you increase the timeout on the WAITFOR to 2 hours (or something along those lines) and activate them all before you start the talk   -- Adam Machanic Pro SQL Server 2005, available now http://www..apress.com/book/bookDisplay.html bID=457 --     < SimonS_@discussions.microsoft.com > wrote in message news:5581fc5f-f83a-4118-a194-66b1c23d608b ...Show All

• arkiboys SQL2005 SSIS - won't allow text delimiters

  W2k3 server, SQL 2005. @@version = Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) I'm trying to set up my first SSIS package to import a flat file to a database table. The connection manager will not allow a text qualifier. My data is comma delimited, with doublequotes around each field. If I enter " as the text qualifier, then I get the error "The preview sample contains embedded text qualifiers ("). The flat file parser does not support embedding text qualifiers in data. Parsing columns that contain data with text qualifiers will fail at run time." The data in Columns view shows as just one column rather than multiple columns. If I leave the text ...Show All

• tolily Declare cursor based on dynamic query

  Hi, I am declaring the cursor based on a query which is generated dynamically. but it is not working Declare @tempSQL varchar(1000) --- This query will be generated based on my other conditon and will be stored in a variable set @tempsql = 'select * from orders' declare cursor test for @tempsql open test This code is not working. please suggest Nitin I don't like to ever advocate the use of cursors, but you can do this using a global cursor, if you really must: create procedure test as declare @name nvarchar(128) exec ('declare bob cursor global for select name from sys.objects') open bob fetch next from bob into @name select @name as works close bob deall ...Show All

• darknessangel openxml join to delete from table

  Hi, Trying to delete records in a table that are present in the xml data. (See below). The error I get is: Incorrect syntax near the keyword 'as'. delete from tblMarketValues as mv inner join FROM OPENXML (@idoc, '/marketData/forwardCurves/forwardCurve/maturities/maturity',2) as oxml WITH ( contractMonth varchar(50) ) on mv.IndexID = @IndexID and mv.MarketValueTypeID = @MarketValueTypeID and mv.ValueDate = @ValueDate and mv.ContractCode = oxml.contractMonth ...Show All

• parosky Create a publication in SQL Server 2005 Express

  Hi, is it possible to create a publication with SQL Server 2005 Express. I can’t seem to find it in Microsoft SQL Server Management Studio Express. Do i have to install the full version :( Isn’t there any other option Thanks SP SQL Express can't serve as publisher or distributor for all types of replication. For more considerations for replication on SQL express. checkout this topic: http://msdn2.microsoft.com/en-us/library/ms165686.aspx in BOL. You will need workgroup edition or above, although the workgroup has limitations on the number of subscriptions. For full detail, take a look at "Features Supported by the Editions of SQL Server 2005" ( http://msdn2.microsoft.com/en-us/library/ms14 ...Show All

• twonjosh multi line rows

  Using Visual basic 2005 I have a form and set up my datasource, bindings etc. All works well, adding, updating, and deleting via form to sqlexpress except..... I have 2 columns set up in sqlserver that get data from muliline textboxes on my form. Column 1 "Material" is nvarchar(50) Column 2 "Quantity" is int The first multine textbox "Material" works fine, eather updating in the textbox or in the Datagridview cell. the second multiline textbox "Quantity" works when I just put in a number in the first line of the multiline textbox, when I put in the 2nd number on the second line, nothing gets updated. I I do that in the datagridview cell (Shift-Enter), I get an error. " ...Show All

• TobsTec database and vb6

  How can I attach mdf and ldf files using Visual Basic 6.0 Help me See SQL Server Books Online topic Server.AttachDatabase Method (String, StringCollection) http://msdn2.microsoft.com/en-us/library/ms210158.aspx There are many code examples in many languages. 'Connect to the local, default instance of SQL Server. Dim srv As Server srv = New Server Dim owner As String Dim logstr as String Dim datastr as String owner = srv.Databases("AdventureWorks").Owner 'Detach the AdventureWorks database. srv.DetachDatabase("AdventureWorks", False, False) 'Display information about the detached database. Dim d As DataTable Dat ...Show All

• The ZMan Questions about "Dimension Processing Destination" & "Analysis Services processing Task"

  First I will thanks for any friends open this one. My questions is: 1.What's the diffrent between Processing a dimension by "Dimension Processing Destination" or just by "Analysis Services processing Task" I found that I could do the same work by both, and the MSDN tell nothing about the diffrence. 2.Why the Process Option in the "Dimension Processing Destination" is diffrent to the Process Option in the "Analysis Services processing Task" to deal with a dimension In the "Analysis Services processing Task",the Option is the same with the MSDN, without the "incremental" option. But in the "Dimension Processing Destination",there is the "incremental&qu ...Show All

• Umeshnath Fixed Header in Reporting Service 2000

  I want to create a report with SQL Server Reporting Service 2000 where I need to have a fixed header and one fixed column containg names of each row items. I tried to find "Fixed Header" property in table but could not locate it anywhere.Can anyone please kindly tell me where should i look for it Or how to achieve this functionality Thank you in advance. Bharat Gadhia. Hi Fang, Thank you for the reply. Can you tell me how to achieve this functionality in SQL Server Reporting Service 2000 Bharat Gadhia. FixedHeader is a new feature that got added in RS 2005. It was not available in 2000. ...Show All

• Wojtek Data integration challenge. Will SSIS help?

  Hi, We have a requirement to do ETL on large EDI batch files into SQL Server. For this we have to map several X12 schemas - which are fairly complex - into relational schema. Right now they use Biztalk but that is not a good option for batch processing of large EDI files. Performance is really bad. Is this possible using SSIS Are there any 3rd party tools which might integrate with SSIS to make this easier or can do this as a stand-alone I know Mapforce 2005 from Altova supports X12 mapping and even generates C# code for the mapping. Anyone has experience in using Mapforce generated C# code in SSIS Looking forward to any insights. Thanks, JGP Anyone have any real-world experiences doing so ...Show All