Answer Questions

• Cammyr Problem when i am using RSClientPrint Active X

  Hi , I m using rsclientscript in my application..i m using the following code in <script> function Print() { RSClientPrint.MarginLeft = 12.7; RSClientPrint.MarginTop = 12.7; RSClientPrint.MarginRight = 12.7; RSClientPrint.MarginBottom = 12.7; RSClientPrint.Culture = 1033; RSClientPrint.UICulture = 9; RSClientPrint.Print('http://localhost/Reports/Pages/Report.aspx ItemPath', '=%2fTestMonday%2fSrCorpLogo&CorporationId=2', 'Employee_Sales_Summary') } </script> I m calling this script when user clicks the button in the webpage.. I m getting the dialog box properly..In that if i click preview button i m getting the following error "An error occured trying to render the report. (0x80004005)" Please ...Show All

• JavaBoy SQL2005 Tools don't work unless all components installed on C:

  On serveral computers in our lab and in production, we installed SQL2005, putting the Data folder on d: because we expect to have a very large database file, but all else on c: When we try the Surface area config tool, and choose the Surface Area configuration for Services and Connections, it responds with an error regarding something being "out of range", then closes when we click OK. Previously, in a couple of lab situations, we installed everything on C:, and all tools worked fine. Is there a known workaround which will allow us to leave the data folders on d: to accommodate large amounts of data, and still have the use of the tools Jim What group policy did you alter We are seeing the same issue. th ...Show All

• Dick R ForeachFile and ForeachItem

  Since I installed SP1, I do not see ForeachFile and ForEachItem anymore as possible collections in the Foreach package, What went wrong Thanks for any advice. That's weird. No errors come up It just crashes I had an issue with very large packages sometimes crashing. It didn't really crash the IDE, but I couldn't save any packages. I would get an Out of Memory error. That mysteriously disappeared though. Do you have SP1 You may have to make sure there are selected under the SSIS Control flow items. Right Click on Control Flow task tab - select choose item... - select SSIS Control flow tab - you should see the foreachfile and foreachitem controls - make sure they are selected. Carl ...Show All

• cobain81 Parameters for Report Builder

  Is there a way to set parameters for a Report Model I have a database that includes data for a lot of users and I want to be able to use a Report Model but only allow the user to see data related to their UserID when they are using Report Builder to build a report. Is this at all possible Would I have to set up some custom authentication Thanks for any help. Please take a look at Model Item Security. http://msdn2.microsoft.com/en-us/library/ms156505.aspx This post should help: http://blogs.msdn.com/bobmeyers/articles/Implementing_Data_Security_in_a_Report_Model.aspx Ok, I understand I can limit access to certain parts of a report or datasource, but I want to be able to filter da ...Show All

• SteveVBNET Replication

  does anyone know if it's possible to run a replication task with a script, and how (is there ans sp_ for this ) thanks, yeah , sorry for unprecisions. I was talking about merge agent. I'd like to control it "on-demand", instead of a plannification. i'm running sql 2000. it's an idea. i'm going to try this. thanks. dont know the script..but u can use replmerg.exe to run it from command prompt... its in the com folder of sqlserver..u shud know the parameters for the agent which u can get from sysjobsteps(in msdb) What task are you asking about ...Show All

• Jonathan Ward Regular Expressions in SQL 2005 using C#

  Hi all, i wrote a little function that is basically supposed to give me a match of a regular expression in C#. i tested it out in VS05 and it seems to work fine. It hits the fan when i try it on SQL Query analyzer once deployed. Anyone have any idea why here is the C# class that I deploy to a db using VS05. using System; using System.Data; using System.Data.SqlClient; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; using System.Text.RegularExpressions; public partial class RegExTest { [Microsoft.SqlServer.Server. SqlFunction (IsDeterministic = true , IsPrecise = true )] public static string RegExMatch( string pattern, string matchString) { Regex r1 = ...Show All

• Henry Ong Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

  I have: (1) SQL 2005 on a member server, Windows Authentication (2) I'm using Visual Studio.Net 2005 on my Windows XP sp2 work station. (3) From my machine, within my development application, I have no problem accessing the Data in the SQL server. (4) I Receive the Login Failed error after I copy my project to the Test Web Server (Same machine that houses SQL) and test from either my machine or from the host server. More details of the error message are: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Det ...Show All

• Terrence Chan AccessDataSource and stored querydefs

  - i have been connecting to an mdb stored in the App_Data folder with AccessDataSource controls on .aspx pages. - i was using stored queries in the mdb as the data sources without a problem. all of the queries were stored as views and were easy to find and configure to the AccessDataSource. - i recently opened the mdb on its own to update and rename some queries and also add some new queries (knowing i would have to redo the data source configs, gridviews and dropdown lists, etc. on the .aspx page(s)) - but now a lot of the mdb queries are stored as functions and i can't use them as a data source. or can I - why are so many of my mdb querydefs now stored as functions, and how can i turn them back into views so i can easily conn ...Show All

• laja Reporting services with SQL Express

  Ok, here's the deal. I'm just learning sql express and I'm trying to get my reporting services worked out. I have everything installed and I have managed to connect to the report server at http://<computername>/Reports my problem is I can only connect to this page when I am at the machine where the sql database, reporting database, etc... I cannot log on to this site from any other computer no my network Does any one know why Thanks!!! I suggest you ask this question in the Reporting Services forum. Mike I get a page cannot be displayed in the browser window when I try from a different machine. Header bar at the top of browser window says "Cannot find server - Microsoft Internet Explorer" Hi, do you ...Show All

• Ljhopkins SUM returns incorrect value in SQL Server Mobile Query ... Bug??

  Hi all, I am a newcomer to Microsoft Database Technology and have appeared to come across an issue with the SUM function in SQL Server Mobile Edition. I am running Visual Studio 2005 and have created 2 tables: Orders and OrderLines which are set up in master detail fashion. The SQL Statement I create in the Query Builder is as follows: SELECT     Orders.OrderNo, Orders.OrderDate, Orders.Priority, Orders.Address, SUM(OrderLines.Quantity * OrderLines.QualityReference) AS Total FROM         Orders, OrderLines WHERE     Orders.OrderNo = OrderLines.OrderNo GROUP BY Orders.OrderNo, Orders.OrderDate, Orders.Priority, Orders.Address Now, the SUM ...Show All

• Drudkh How to : Truncation : Can i write a log entry whenever data is truncated?

  I'm reading data from a flat file source. If some data gets truncated, i have the option of 'ignoring', 'redirecting' or 'fail component'. What i'd like to do is, to allow the data to be truncated, but i'd also like to write a log entry so that i can know that a particular rows data has been truncated. I've tried 'redirecting' the row to a script component (as transformation), but i don't know how to determine if the error is truncation or not, not only that, i can't redirect the row back to the 'original' flow, which is a derived field column. Any ideas on how to do Cheers. I agree with u on that one. Just wish there was a more elegant way of doing it. It wouldn't be to hard for m'soft to p ...Show All

• cmwith Profiler: Duration column

  When I run profiler against the Production database, I filter on duration sometimes - such as give me all events that go over 1 second (10,000 Milliseconds). When I run the same SP or t-sql statement against the test database server (which is on the LAN), the results come back to me in under 1 second. The production database is at a co-location facility to which I don't have a great connection. This had me confused - yes there is a load on that server but for a query to run in under one second on the test server(not a powerful as the PROD server) and take upto 25 seconds against PROD when run from QA on my desktop was not quite right. So I logged in to the production server (remote desktop connection) and ran the same query from SSMS on t ...Show All

• SQLDataMonkey Sql log can not increase?

  Database's log file can not increase when nearly get 2 GB What's wrong with this Any idea about this Thanks someone might have set the transaction log size limit. right click the database in the Enterprise manager. click properties. click on transaction log. see if the the option "restrict filegrowth is checked" mine is sql server 2000 ...Show All

• byronfromwesleyan Images aren't being displayed in deployed Reports

  Hi everybody, When I develop and run (preview) a report in my machine (Vs.net 2003), the report is displayed correctly, including images. But, when I deploy the report to the server (Win2k Server), the report runs OK, but the images are not displayed! I've already tried everything I found in the internet about this problem .... changed the way of put the image in the report (Embedded, External), tried an image with only RGB colors, changed the account for unattended execution (rsconfig) .... but nothing worked!!! Does anybody have any idea about what might be happening Thanks a lot!! Yes, cookies are enabled. Actually, view the properties of the image was the first step I took ... The image link: http://server/ReportServer %2fOpex ...Show All

• Steffanp Calling a child package from the Main Package

  I need to pass variables from the parent package to the child package. I got this to work in a small test case. But in the actual project, I get an error when I try to do that. The parent package's log has this error : Error: Error 0xC0012050 whike loading package file "c:\.......". Package failed validation from the ExecutePackage task. The package cannot run.. There's nothing more to go on here in the log. Any ideas -chiraj I got it to work. There were some Script tasks that were not getting the variables. Once I fixed that, it started working. Now I need to make sure it works consistently. I've read elsewhere that it suddenly chokes. Thanks -chiraj ...Show All