Answer Questions

• Michael.Young Reporting Services: Allow Blank Value for a multi-valued Parameter

  I have a multi-value parameter "Keyword" that also allows blank value. When I try to view my report with a default null Keyword value, it doesn't display any. Please help. Thanks! Gerri Thank you. I would also like to ask. I have 7 parameters for my report. 3 of which are coming from UI. and 4 are visible in report viewer. When I set a value from the parameter in RS and click 'View Report', the value is set to null, thus, disregarding the values of these 4 and considering only those 3 coming from UI. Please help. Thanks! Gerri I assume you want to return everything if the parameter is null, right does you query support null parameters ...Show All

• MrSock Reset a database

  Hi, I have red this thread while I was searching an answer to my problem. Basically when you develop an app. you do some testing to check if everything is fine. When the testing is done you have primary key seeds starting from a number x which is not 1, as it is when the db is newly created. I read about the truncate instruction (which I knew from mysql) but I can't perform the query because of the presence of a foreign key constraint in another table. So I thought, maybe there is a way to tell the DB engine to disable FK checks while I do the truncation, but I can't find it in the documentation. So the question is: using SQL EXPRESS what is the quickest way to reset the db state to its initial state, where all the primary key seeds were ...Show All

• Jeff Weber ssis in sql server express edition

  hi, can anybody tel me how i can install (any component to be instakked) ssis in sql server 2005 express edition it's lok like this edition doesn't support ssis! is' it true Thanks Sandipan Hi, Is there any way we can run an SSIS package from SQL Server Express (with any extra components installed) . My application needs this scenario, the SSIS package running from the client machine and pull data from the server. Please help me understand how can i do that. Thanks. Vigya Thnaks Mike Sandipan Because of the changes to the security model, it does not appear the my dts packages will properly execute - they did not on my test system just now, so I assume that will be the case o ...Show All

• Shahid Mahmood Reboot Takes Retries to reach Remote SQL Server

  When our application server reboots, our application service has problem connecting to a remote SQL Server. We get the following error: 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: 26 - Error Locating Server/Instance Specified) After several retries, the connection is finally made. Our service has several dependencies to OS services like Net Logon, Remote Procedure Call (RPC), etc. Is there an additional dependency we can add that will delay the startup of our service until the applicati ...Show All

• mabrouk remove <select a value> oprion

  I have a parameter that get his values from a query. his defualtvalue is Null. In the report page, The first value is "<select a value>". even if I give the parameter another defualt value Then it open with this value selected but still the first value is "<select a value>". Can I remove this Thanks. ...Show All

• Jstun Stored Procedure - Insert with table name from parameter

  First of all hi for all, I m trying to make insert stored procedure with parameters, i want to send table name and insert values with parameters, i m trying that below stored procedure but it gives syntax eror to me what shoul i do to correct it set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [insertalepform] -- Add the parameters for the stored procedure here @type nvarchar ( 15 ), @talepbrmno int , @birimisteksayi bigint , @birimistektarih datetime , @aciklama nvarchar ( 50 ), @onay int , @seviye int , @talepformno bigint , @taleptarih datetime AS BEGIN SET NOCOUNT ON ; exec ( 'INSERT INTO [BelediyeWork].[dbo].[' + @type + 'TalepForm ...Show All

• joesanders Permissions

  hi all my computer = NZ3 (sql Server) my computer = the report server I can design / view / publish to local host (myserver) others in domain can only view local host (myserver) and no content so to test added one person - as content manager he can now see all reports - but when he goes to run gets the error cannot create a connection to the datasource I am using sql server 2005 standard where else should I be changing or setting permissions thanks jewel thanks Jens that enabled him to see now cool. So when I have a group set up - do I have to add each one in the Security Logins to enable this to work thanks Jewel Hi, seems that you are using Integrate ...Show All

• dork Can you please help me on this?

  I have a table like this: Item                            QUAN ----------                       --------- 2                                   30 3                                  5 ...Show All

• GConst Temporary table name

  Hi all Is it possible to name a table when a script runs with the date ie select name, address into test (date) from company where the (date) is will be todays date Thanks Richard Sure, DECLARE @tablename as CHAR(20) DECLARE @SQLString as VARCHAR(100) SET @tablename = 'Test'+CONVERT(CHAR(12),GETDATE(),112) SET @SQLString = 'SELECT Name,Address INTO '+ @tablename +' FROM Test' EXECUTE sp_sqlexec @SQLString Peter Cwik Please note that sp_sqlexec is deprecated since SQL Server 2000 (maybe even SQL70) and shouldn't be used. Also, the code needs to protect against SQL injection like: DECLARE @tablename as CHAR(20) DECLARE @SQLString ...Show All

• Kira_26 Question on association models: MINIMUM_ITEMSET_SIZE

  I've been experimenting with the algorithm parameters for a market basket association model. The default MINIMUM_ITEMSET_SIZE is 1. This doesn't seem to make sense: what is the point of a single-member itemset However changing the value to 2 substantially reduces the proportion of good recommendations obtained (which I'm testing via a holdout approach). So I'm obviously misunderstanding what the parameter means. Can someone explain it please, and also explain the observation above)   Every item in a dataset is an "itemset", so there are always "1-itemsets", that's just the list of items and their counts. MINIMUM_ITEMSET_SIZE is really only there for those who are only inter ...Show All

• 70Hours MTD and Prior MTD to only calculate up to Current Day in the Month

  Hey guys. I have used the wizard in SSAS to create all my time calculations. These are working fine as they have been designed to do. I have had a request, and it is valid. that when they are using the MTD (Current Month) and Prior Month (Previous Year) calculations, it is showning the total value for the Prior Month(Previous Year). They would only like it to show up to the current day. Example, They monitor Sales on a daily basis. For instance, Dec 2006, Vs Dec 2005. We are only 2 weeks into December, so we only want to see the first 2 weeks of December in 2005. Is this possible And can i modify the existing Scripts that were created via the BI wizard.. Any help is much appriciated Thanks Scotty ...Show All

• AmitKa TSQL Logic Help

  I have a Rule table that looks like this. Rule_ID (PK) vMin vMax vName I would be recieving the vName as an input. I need to go through the table to make sure that the rules (Min and Max) are not intermingeled. Rules can be within another rule but can not cross. This is Correct Rule 1 vMin = 10, vMax = 20 Rule 2 Correct vMin = 15, vMax = 18 Rule3-Incorrect vMin = 8, vMax = 12 Every time the SP is fired I need to be able to check if this rule is valid or not by comparing it to all the rules in the table. if it is not valid I need to fire an error back. how can we get the logic of this code to work Please help This query will return if it's not intersected. select ...Show All

• donkaiser Query Notification stops working after 10 minutes

  Hi All We built a Cache component that take advantage of the SQL Server 2005 query notification mechanism, all went well , we tested the component in a console application , and notifications kept coming for as long time as the console application ran. When we initiate our Cache Component in our web service global.asx application start event , the query notification works for a few minutes , but if we came after 10 minutes or so , we stoped getting notifications from sql, the SQL Server queue is empty , and all is showing that there is nothing wrong on the DB side... Our Cache component is a Singleton class , that perform all registrations ,catch the notification events and resubscribe for notifications. What can ...Show All

• hr0nix Creating database

  I have been using microsoft office access to create database and connect to application built. This is the first time trying to create database using the sql server. How do i create a database using this Do i use the sql server management to create it Is there any step by step tutorials How do i connect the database to the web developer Hi thanks for the help. I am trying to built a web database using the visual studio web developer 2005 express. client will be able to access the database in the intranet server. I found out that i can built a database using the web developer itself so what is the different from built it using the sql server   ta ...Show All

• Blue-Fire SQL Database connection set up in Global.asax.vb for multiple users

  We have an application where users log in and set up a ConnectionString based on the login-info. As to now, we have used Application.Contents("conn") = (strConnectionString) in Global.asax.vb (Application_Start section) and then in the in the webforms we use Dim con As New SqlClient.SqlConnection con = New SqlClient.SqlConnection(Application("conn")) con.Open() ...... ...... con.close() (Each user has their own sql database that they connect to using the same scripts.) The question is: When many users are logged on at the same time, will the use of Application.Contents be a safe way to connect to each users own database or is there a possibility that users suddenly will try to establish a connection to a databa ...Show All