Answer Questions

• John Lockhart Subscription Error

  Hi! I get a strange error on some report subscriptions. The following is the stack trace: ReportingServicesService!library!13!12/27/2006-08:07:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.OverflowException: Arithmetic operation resulted in an overflow. at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName) at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String us ...Show All

• Olga Jaufman problem when installing sql reporting services 2005(encrypt problem)

  Hi, I am trying to install sql reporting services 2005....i am getting this error “Error : SQL Server Setup cannot install files to the compressed or encrypted folder: C:\Program Files\Microsoft SQL Server\. To continue, make sure that your installation directories are not compressed or encrypted, or specify a different directory, and then run SQL Server Setup again.”… on the same machine sql server 2000 is also installed Please help me ..its urgent.... Regards, Pradeep You may either have a compress or a EFS encrypted folder. This isn’t allowed in SQL Server 2005. Remove the compressions and / or the encryption and try again. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.d ...Show All

• dork Use regular DataTables for a local SQL report?

  Hey all, I have a local Sql report. Right now I am using the DataSet objects and table adapters with binding sources to get all the data for my reports. I would like to just use my DAL, which returns regular DataTables. Can I bind these and add them as sources to the report How would I fill in the fields of the report without using the DataSet object Is this possible Thanks. You'll need to look into writing a custom data extension. You write a class that implements IDataReaderExtension and configure RS to trust your assembly. Then make your class access your DAL to retrieve the data. Why not create a new dataset with the one table as the single item HTH, Jens SUessmeyer. --- http://www.sqlserver200 ...Show All

• Ruther Error 1612 - can't get Express installed

  I have done all I can to resolve this on my own and would really appreciate any help anyone can give me. I have run uninstall utilities, followed a few MSDN reinstall methods, but all roads lead back to this vicious cycle: The install hangs trying to install the prereq Microsoft SQL Server 2005 Setup Support Files with Error 1612. So I try to uninstall the Support files using Add/Remove..but the Windows Installer looks for "Microsoft SQL Server Native Client" disk, which of course I don't have because I install from downloads from Microsoft. That's the very short version. I've got a ton of hours reading help groups, MSDN, trying everything. I have posted the error log file below. Thanks in advance. === Verbose logging ...Show All

• Vince P sql05-exp: what exactly is installed to client computers on the network

  I'm sure this is rediculously simple, but I am totally new to sql. We are upgrading our practice management software to an edition which requires sql to be installed on our Win2003 file DC server and 18 client computers, all running xp-sp2. New software comes with an option to automatically install MSDE but I would like to try sql05 express instead, which they support if it is pre-installed on the server and all workstations. We meet all necessary sql05-exp requirements. After spending several hours online and downloading 05 books online, etc I beleive I understand how to set up the file server where the data resides, but I am now confused about what exactly I am to install on the client computers. Clients have .net 2.0 installed. I see no ...Show All

• LSS There must be an easier way - Dupe check and Increment field

  Greetings all, I have a bit of brainteaser that's going to take some serious thought. I'm importing information from .xls files into a SQL table. The problem is I need to check for dupes and increment certain fields on success of dupe find and then not insert or delete the dupes. For example, if I have Adam, Turner, 32, 50 already in the table and someone tries to insert Adam, Turner, 32, 50...I need it to increment to read Adam, Turner, 64, 100 and not insert the record. (Notice 2 fields were incremented.) With that, I have created an INSERT trigger as follows: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER Trigger [dbo] . [trgInsertCheck] ON [dbo] . [MyTable] FOR INSERT AS BEGIN  &nbs ...Show All

• xxxmpsxxx SQL 2005 Server Agent won't start

  When I attempt to start the Server Agent Service, it tells me it started, but stopped immediately. When I check the log files for the agent, I get the following two entries: 2007-01-03 15:07:11 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started) 2007-01-03 15:07:13 - [098] SQLServerAgent terminated (normally) This same error was posted inanother forum and I was directed here. The EventLog is running (I did an SC command) so I am lost. Help I cleared the log and get the same errors. The system log in the event log logs a start control being sent to the service and the service stopping. Did you che ...Show All

• sandsdad Saving a package to the package store vs. SQL Server?

  There must be a difference, but I don't know what it is. Can someone please explain the advantages and disadvantages of each method Thanks in advance. From the link above... You can also save copies of the package XML file to the msdb database in SQL Server 2005 or to the package store. The package store represents the folders in the file system location that the Integration Services service manages. Advantages versus disadvantages... If you store the package in the file system it would seem like it would be easier to edit and make changes. Package Store saves the dtsx file to the file system, while Sql Server saves the package in msdb database. http://msdn2.microsoft.com/en-us/library/ms137633.aspx ...Show All

• Mostafa Ragab EXECUTE SQL string with parameter and return value

  Hi all, I would like execute an SQL string who calls a stored procedure with param and return a value: declare @query nvarchar ( 50 ) set @query = 'sp_test 1' declare @resultat int exec @resultat = @query select @resultat Its returns a error message: "Could not find stored procedure 'sp_test 1'" The command exec ( @query ) works fine, but I can't retreive the return value and I can't do exec @resultat = ( @query ) How can I do Thanks, Aurelien Thanks very much, With sp_executesql, the stored procedure is correctly executed, but it don't return the return value... exec @resultat = sp_e ...Show All

• scoobystuck DTS Packages

  How would I transfer DTS packages from 2000 to 2005 SQL Server 2005 Integration Services Backward Compatability article (addresses your question and much more, great paper) http://msdn2.microsoft.com/en-us/library/ms143706.aspx ...Show All

• JHarjung Syntax using EXCEPT

  My statement below gives me an " Incorrect syntax near the keyword 'EXCEPT'" error. select distinct tprod , tlot from ith where ttdte between 20061023 and 20061105 and ttype = 'R' and twhs in ( 'FV' , 'S1' , 'MV' ) EXCEPT select distinct tprod , tlot from ith , frt where tprod = rprod and ttdte between 20061023 and 20061105 and twhs in ( 'FV' , 'S1' , 'MV' ) and ttype = 'R' and rtwhs = 'RP' Each individual SELECT statement runs fine on its own. What have I done wrong when combining them h Yep. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• sajithpt Lookup finds match on empty reference table

  Hi all, In BOL it says: "The Lookup transformation performs an equi-join between values in the transformation input and values in the reference dataset. Using an equi-join means that each row in the transformation input must match at least one row from the reference dataset. If there is no matching entry in the reference dataset, no join occurs and no values are returned from the reference dataset. This is an error, and the transformation fails, unless it is configured to ignore errors or redirect error rows to the error output. " I have a lookup transformation which is supposed to find a match on two fields in the reference dataset (a table in my case) but strangely, when I execute my package and the reference table is emp ...Show All

• Larrybird02744 Assigning values based on InitialToggleState of a control in SSRS

  Hi, I need to assign the value for a field in a report based on Expand/Collapse state of another field. Eg. If Collapsed, the value should be "AA" else if Expanded "BB". Is there any way to get the value of InitialToggleState for any field in SSRS. Thanks in advance. Sathya Use True for Collapsed and False for Expanded. As explained at the following link http://www.manning-sandbox.com/thread.jspa threadID=14881&tstart=60 ...Show All

• Gheerish Form Authentication for Reporting Service 2005

  Hi, I am trying to implement Form authentication for the SQL Reporting Server 2005. I have followed the Sample project and instructions (Form Authentication Sample). But i am getting the following error before I can get to the Log on form. Any help will be much appreciated.. Rahman Exception message: Object reference not set to an instance of an object. Event code: 3005 Event message: An unhandled exception has occurred. Event time: 8/24/2006 4:39:52 PM Event time (UTC): 8/24/2006 9:39:52 PM Event ID: 39ae35193fee4075a08547317f91f7e8 Event sequence: 2 Event occurrence: 1 Event detail code: 0 Application information: Application domain: /LM/W3SVC/1/Root/ReportServer$SQLSERVER2005-7-128009291791 ...Show All

• dummies Does SQL permit use of a column alias directly in the CASE statement?

  Our Case statements can get very long and complicated and I would like to maintain just a single "Case" and than depending on the type of set I'm processing, use this generic "Case" statement to properly decode the value. My SQL code is listed below. Select 'PCAR' as [vtyp] ,Case When [vtyp]='PCAR' and substring(veh_vin,8,1)= 'A' Then 'Cyl = V-6 Fuel = Gasoline' When [vtyp]='PTRK' and substring(veh_vin,8,1)= 'A' Then 'Cyl = V-8 Fuel = Diesel' When [vtyp]='PCAR' and substring(veh_vin,8,1)= 'B' Then 'Cyl = V-6 Fuel = CNG' Else ' ' End as 'Engine_Decode' From veh_owner Where substring(veh_vin,10,1) = '3' --Selects on cars Union All Select 'PTRK' as [vtyp] ,Case When [vtyp]='PCAR' and substring(veh_vin,8,1)= 'A ...Show All