Answer Questions

• sierrakinglet Report Builder error.

  Hi, I am facing a peculiar situation where my ad-hoc report is inter-mittently giving me the following error based on the parameter values I am selecting from the dropdown. What could be the possible reasons for this Is this error displayed during execution (preview) of the report or during design-time If it is being displayed during design-time, try opening the model in Model Designer and change the element's "Value Selection" property to "None". This will tell Report Builder to use a textbox instead of a dropdown menu for this element. If this error is during execution (preview) of the report, does it occur when the report is published and executed directly from the server HTH, Jason Tremper ...Show All

• HSCSydney How to remote processing reports?

  Hi everyone! I have my reports published in a report server. What do I need to do so that the user can processing reports from a windows application There are many ways to do that. Within VIsual Studio 2005 there is a reportviewer control which you can use within your application to contact and display report. If you only want to get a report from the Server and present the user a byte stream to save to a file (something like a button which says Save the report to PDF...) THen you can just use the Report Server Services interface. WHat do you actually want to do (Meanwhile you can take a look on: http://www.gotreportviewer.com/ ) HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• arkiboys USE MULTIPLE ROLES IN CUBE BROWSING

  Hi, I'm developing a cube browsing aspx application using the OWC11 controls, both Pivot and Chart, associated with Analysis Service on SQL2005. I did quite a bunch of that but now I'm having some troubles to solve the following problem. Using the SSAS IDE, I defined two Roles in a Cube and I defined a filtering function on the dimension in both of them. When I choose each one of them and I check the functionality they works because I can see what I expect to see, only one result from a dimension where the filter is acting in the role definition . But, if I choose both of the roles, and I can do that because it let me select the two checkbox instead of all (having more than two Roles), the filter doesn't work anymore, showing a ...Show All

• Peter Cwik Date Format Data Driven Subscription

  I'm getting the typical error that the format of my date parameters is not correct. Although i'm getting my dates in a select from a datetime field. Is there really no universal format that can be delivered to RS that he can interprete the date right, whatever language the report has been set to. Kind Regards ..... You can define your datetime parameters as YYYY-MM-DDTHH:MM:SS. This format is independent of the language of the report. See http://msdn2.microsoft.com/en-us/library/ms159825.aspx for moer details. ...Show All

• jrsearles Data access using Ent. Library Jan. 2006 release

  Hello ... Using Ent. Library Jan. 2006 release and .Net Framework 2.0, I'm connecting to SQL Server 2000 using Microsoft.Practices.EnterpriseLibrary.Data.Sql. I have a windows service that processes jobs asynchronously and from time to time, I'm getting the following error -- "A connection was successfully established with the server, but then an error occurred during the pre-login handshake. 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. (TCP Provider error: 0 - An existing connection was forcibly closed by the remote host. " What's surprising is the error message saying SQL Server 2005. Has anyone encountered a ...Show All

• Munish Gupta Getting "An existing connection was forcibly closed by the remote host (System)" error

  I cannot connect to Analysis Services through SSMS. Receiving a "An existing connection was forcibly closed by the remote host (System) error." I changed my password this morning due to our company security policies and now I can't do squat. This is definitely a bug in the service as something is cached and not clearing out. I've rebooted both the server and client a couple of times. Running AS 2005 SP1 on Windows Server 2003. I can connect through another machine. Here's the message I'm getting. Don't know where to look to fix the problem. =================================== Cannot connect to hctx-idwdev. =================================== A connection cannot be made. Ensure that the server is running. (Microsof ...Show All

• DPotages Date out of range?!

  Greetings! I have a data source that gets generated based on a variable with the following SQL : "select * from result where deletion_ind = 1 and when_deleted >= '" + (dt_str, 50, 1252) @[User::Last_Run_Date] + "'" But when I run my package I get an error message saying: The conversion of CHAR to DATETIME resulted in a DATETIME value out of range The Last_Run_Date variable is set to '2006-06-25 14:35:05.450' When I run the code in a QA session it works, but in the package it complains! What am I doing wrong Thanks for your help in advance. Hi Jamie, The error does not occur while the SQL Task is being validated. The Task correctly picks the right date and assigns it to my ...Show All

• David E Montgomery SQL Server 2000 MSDE

  Hi We have sharepoint installed and as per the developer MSDE was installed by Sharepoint. I don't know much about Sharepoint but I would like to administer the 2 databases created by registering it with Enterprise manager. We have licenses for SQL Server 2000 Standard edition (per processor license). Is it okay for me to register the msde and manage it graphically rather than using osql commands. Thanks.   If you have a CAL for the client to administer the main Server, you are allowed to administer as well the MSDE with the EM. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- please be aware, if the operating system installed on that computer wi ...Show All

• gsell Defining an event inside of an assembly => UNSAFE (no workarounds?)

  Can someone verify that an assembly containing an interface with an event definition, such as... public interface A { event EventHandler Foo; } ... can never be loaded under SAFE or EXTERNAL_ACCESS It appears that the compiler-generated add_xxx and remove_xxx have the MethodImpl(MethodImplOptions.Synchronized) attribute defined by default, and "Explicit synchronization is not allowed". The same limitation also applies to classes by default, although technically one is able to define the implementation directly (clearly not ideal). That's exactly correct. There is some possibility in the future that the CLR could change the way they implement EventHandler synchronization to allow it in non-u ...Show All

• RobDever Can't Route to another LOCAL Broker Instance

  I have two databases (A and B )on the same SQL Server instance. Both have SSB enabled and running fine within themselves. All athorizations are at present set to dbo. Recently I had a requirement to start a dialog and send a message from within data base A to a queue via a service that is in database B. I tried coding the SSB instance in the BEGIN DIALOG then I set up a route and tried that. On both occoasions I got the following on sys.transmission_queue "An exception occurred while enqueueing a message in the target queue . Error : 916 , State : 3. The server principal "sa" is not able to access the database "B" under the current security context ." Is this sometjhing to ...Show All

• JerberSoft Troubles with speed of queries

  Hi, we are running MS SQL 2000 with several tables. One XY containing more than 100.000 records. After about 200 to 300 individual inserts into the table, database performance dramatically decreases. Queries like "SELECT ..FROM XY .. WHERE ..." takes about 2 minutes. Before these inserts (statistics were explicitly updated by UPDATE STATISTIC XY WITH FULLSCAN) performance is OK. Such select-query takes about 5 seconds. Database settings are: Auto update statistics - ON Auto create statistics - ON Does anybody knows what gets wrong Thanks for any tips. Jakub Good point shashi, although a good relational database will at least have identity or PK columns, I should'nt have assumed the obvious. ...Show All

• x646d63 Granting UPDATE for only certain columns in a table

  I have tried using the SQL statement shown below to grant UPDATE permissions for a single column in a single table to a user with db_datareader privileges. grant update (col_1 ) on trs . dbo.table_1 to calc When I then run a SQL script that has an UPDATE for col_1 on trs.dbo.table_1, I get an error message Msg 230, Level 14, State 1, Line 2100 UPDATE permission denied on column 'col_2' of object 'table_1', database 'TRS', schema 'dbo'. Why is the error message referring to "col_2" when my SQL statement is trying to update "col_1" When I performed the "grant" I did it with an account that has db_owner, db_securityadmin, and db_ddladmin privileges. This worked in SQL Server 20 ...Show All

• Whoisit SQL 2005 Service Pack 2

  Can anyone tellme when SQL 2005 Service Pack 2 will be out It is a big problem when I can't look at an existing role and see what permissions are for a group of objects. I found this in forums: http://forums.microsoft.com/TechNet/ShowPost.aspx PostID=605425&SiteID=17 quote user="Bill Ramos"] Actually - we have a "fix" in for our service pack 2 that will be available in CTP form later this summer that will list all of the securables for a given principle that have been explicitly set. You may need to use the "Effective Permissions" button to see if the principle actually has permissions on the securable. Thank you, Bill Ramos, Lead PM, SSMS BTw, the CTP for SP 2 is available - ...Show All

• 黃泓量 Jeremy Wong SQL Express question for parasing data from an Oracle database

  Hi, Below and far below are my SQL command and raw data. In the data, each lot has 13 records, for example, T6L09641 has 13 records. What I am working on is to average the Total, Large, Middle and Small for each lot as a representative instead of listing every record. So, I wrote a SQL express and put it in my Access and run it. However, I got an error message " ORA-00905:missing keyword(#905) ". I double checked it again and found nothing stange. Someone can help me to modify it SELECT LINE_ID, LOT_ID, AVG(TSIZE_QTY_PA)/10000 Total, AVG(LSIZE_QTY_PA)/10000 Large, AVG(MSIZE_QTY_PA)/10000 Min, AVG(SSIZE_QTY_PA)/10000 Small, RCV_TIME Time FROM IWMES.DIMES_PPTU_PT_IPCRST Where (LINE_ID='L401') GROUP BY LOT_ID HAVING RCV_TIME BETW ...Show All

• Furby Need help after creating SSIS project

  Hi, I have created SSIS project that imports .csv file into sql server 2005. SSIS package is saved successfully but now i want the table created in sql server 2005. So, how to get the imported data in sql server 2005. Can any1 help me out Thanx n Regards, Ruja :) Hi Jamie, Thanx for ur concern.. Yup i have created SSIS project but then also i m unable to get that table in sql server 2005. Can u tell me wht shud b the problem Is there anything extra effort to be done to get records in sql server Should i have to execute package.dtsx manually Plz help me to solve this problem. Thanx and Regards, Ruja Ruja wrote: Hi Rafael, Yes i have the mentioned components in ...Show All