Answer Questions

• bhayes Frror: 4000 max string literal in Expression for datareader component

  Hi, I have a datareader component of which i am dynamically setting its sqlcommand statement with expression (click the background of dataflow > properties > expressions). Now my sql select statement has about 600 fields so that makes my expression statment "select field1, field2, .....from table1 where field2 >=" + @[User::dateforfield2] but when i evalute the expresssion (which is right), i get the error: A string literal in the expre ...Show All

• edgard Forms security deploy problem and email-subscription

  Hi, I have changed my Reporting services from Windows Security to Forms Security. When I deploy reports on the local SQL server, a windows pops up. This windows requires my username and password for the report server. After I input them, everything works fine. However, When I deploy reports to the above server from the different SQL server located on a different computer, the windows always pops up, although I type the same usern ...Show All

• Sunkakangi SERVER 2003 Standard x64 will not run ASP connecting to SQL

  I have a asp page running set dbConn = server.createobject("adodb.connection") dbConn.open "Provider=SQLOLEDB.1;Password=cyclone;Persist Security Info=True;User ID=sa;Initial Catalog=DataWarehouse;Data Source=TVI_XXX" And testing DSN file............with ODBC myConnFile = Server.mapPath("/") & "/" & "TESTFILE.dsn" connectstr = "Provider=SQLOLEDB.1;Password=c ...Show All

• jmshearer killing sqlservr.exe from sqlclr code

  I keep getting different answers from different people on regarding if you can or cannot kill the hosting sql server process with an unsafe assembly. Can you do this If so could you please attach a sample demonstrating this Thanks, Derek Is this simple enough public static void killsql() { System.Environment.Exit(-1); } Steven There are many ways to kill sql server. If we allow PIn ...Show All

• RuneFS SQL Server 2000 Reporting Services and VS.NET 2005

  If we have SQL Server 2000 and SQL Server Reporting Services already installed is it possible to design reports in VS.NET 2005 or is VS.NET 2005 tied to the SQL Server 2005 Reporting Services Steve Miller   Sort of. When you create your SSRS 2000 report (with VS2003), you can then upload/deploy it directly to SSRS 2005, or open it with VS 2005. If you upload/deploy it, the report will work, an ...Show All

• MWP rsAccessDenied

  I have a reportViewer control on a webform. In my partial class I set the report path, server and parameters in the Page_Load. When I run the report I get this error: The permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this operation. (rsAccessDenied) Here is my code: Dim u As New UriTypeConverter Dim ReportParameters(0) As ReportParameter ReportParameters(0) = New ReportParameter(" ...Show All

• KWFANG DSO object Scripting for cubes

  Hi All,    We got a cube in the Analysis services which we need to copy that to the same database in a different name using the DSO object scripting. I had did that successfully using the Clone method available in the DSO objects. But in the new cube created i need to replace the existing fact table to a new fact table which got the same structure as the old fact table but the name alone changes.I'm not able to find any kind of fu ...Show All

• Damien White users cannot accesss report builder without being local administrator

  I've seen similar posts on this problem but no answers. Does anyone know what 'local rights' the user needs without being admin to access report builder. I have already gave them the rights to install report builder they can see the icon on the web page but when they go to install it and are not local administrators on their desktop, they get this error. We have tried putting the users in the Power Users group but still does not let them ...Show All

• Yorch System::ExecutionID required in eventhandlers

  It is possible for a task to be executed multiple times in parallel. e.g. If a package is executed more than once using "Execute Package Task". I understand that in the future the ForEach container will have the ability to execute all its iterations in parallel as well. This is a problem. In the eventhandlers we know the SourceID of the container raising the event so we can tie together events raised by the same container but this s ...Show All

• tryanothername Quick way to Round all fields

  I am having to go through each of my fields in my table to edit and put Round() around them. Is there a quick way to do this instead of having to edit every textbox So you want to Round values in textboxes, not the field values coming from DB Then yes, you need to change expression in every textbox. I am doing heavy calculations in SSRS, not SQL. The calcs I'm doing you wouldn't want to do in SQL, it would hurt your brain and ...Show All

• justncase80 SQL Profiler and Analysis Services Connection Error

  When trying to profile Analysis Services, I am getting the following error: TITLE: Connect to Server ------------------------------ Cannot connect to xxxxxxxx\SQL2005. ------------------------------ ADDITIONAL INFORMATION: The operation could not be completed. (pfutil90) ------------------------------ BUTTONS: OK ------------------------------ (I xx'd out my machine name) I can browse and see the databases on the server. Any ideas why I cannot c ...Show All

• Karl Kaiser Export Report

    Hi, How can i export a reporting services "report"  without using a report viewer From C# code  NB: i am using SQL server 2005 (RS 2005 too) Thanks Tarek Ghazali SQL Server MVP     Hi again, (That will then ask the user if they want to open or save the file. The file name will be what ever the report name is.) Is there a way to automaticaly save it w ...Show All

• sriksdave Changing login permissions

  I am trying to set up a secure system and would like some advice on how to do it as it is a bit tricky. The underlying security is Windows Authentication but I need to set various permission levels in the application. What I want to do is to allow users read-only access to a users table. Once they are validated and their permission level is determined, then I want them to be assigned to the role that is set for their permission level. I hav ...Show All

• GaryBla Restricting number of records

  I want to restrict the number of records coming from an OLEDB source. I have 500 records in my source table and I want to process one record at a time I have I set the MaxBufferRows parameter to 1and it l sends 8 records from OLEDB source Any help is appreciated. We are trying to pupulate 8 target tables from one source tables. The source table has 10 million records. We want to read one recod at a time from the source and apply to ...Show All

• JGIS .NET Stored Procedures

  We are considering the pros and cons of whether our client/server application should use a combination of stored procedure that are either native SQL or managed code based versus an approach where the stored procedures are only using managed code. Our database platforms will be Oracle (10GR2) and SQL Server (2005). Our understanding is that managed code is best used for complex manipulation that would be anywhere between difficult to extremely d ...Show All