Answer Questions

• E Hauck Error exporting a subreport to Excel!?

  Hi All, I have a report sonsisting of two subreports. When I export it to Excel I get an Error!! I played around with it and I found out that if I use ReportItems in my page header it will cause this error! Does anyone have any idea why Is this a bug or there is some work around it! Thanks. hi, this has been cracked already.... hehe microsoft did not bother to provide anything on this. but we discovered a work around. and i ...Show All

• KWWF Report Builder Error When Running Report

  Hello everyone, I've come across an unusual error on some of our machines. I'm trying to track down why only certain ones will give an error. I thought it might have something to do with .NET 2.0 not being installed, but I assume that they wouldn't even be able to launch Report Builder if this is the case. I'm at the point now where I've been told these machines have .NET 2.0. I plan on trying to verify soon, but I thought I'd get everyone's ...Show All

• FishBlub Apply sql2k post sp4 fix 2162 on cluster

  I applied sql2k post sp4 fix 2040 and 2162 on active node of the cluster without error, the version number is 8.00.2162. When failover the cluster and double check version number again, it's 8.00.2040. That means fix 2162 didn't push to passive node. So I tried apply fix 2162 on current active node but stopped with KB904660(ENU) setup error: An error in updating your system has occurred. Can't find any log file, and OS is win2k3 enterprise editi ...Show All

• originsnone Am I missing something???

  So I'm using the new Microsoft SQL Server Management Studio (aka Enterprise Manager)... 1. So I load it up, add a few sql servers to it. Mess around, close it, open it again and lo and behold it didn't bother to keep any of my settings or any of the SQL Servers that I had added and anoyingly asks me for login information to add another one.  Unless I'm missing something, you just threw out one of the best parts of Enterprise Manager. Please ...Show All

• MSDN Viewer Remote Debugging in SSIS ?

  Hello   I've just heard that Remote Debugging should be possible in SSIS, but how Some of the projects we run require a lot of memory and it's sometimes slow to debug on the local machine Yes i know i can reduce the input rows, but in some cases i need all the data for testing. Does anyone know how to remote debug No, I haven't heard of Kevin. if you hear anything back I'd be keen to hea ...Show All

• Prakash19 Processing Task : Is it possible to process a cube on a remote server ?

  I'm trying to process a cube on a remote server in a different domain using the AS Processing Task in Integration Services. Is there any way to do this This task uses the OLE DB Provider for Analysis Services 9.0 The problem is that I can't make a connection to my remote analysis server. I give the ip adress as the server name and log on with specific username and password. Then when I Test the connection it gives this error : " ...Show All

• mheller Accessing AS cubes

  Hi, Does anybody knows a good tutorial or some information about accessing analysis services cubes with reporting services thanks I think the following link will give you some information about how to query OLAP Cube from Analysis Service. http://msdn2.microsoft.com/en-us/library/ms156334(SQL.90).aspx In addition to that I suggest the web casts posted in the microsoft web site are good resour ...Show All

• Patrickssj6 Token (A-DBN) show always master after alert

  I try to create a job for an alert that should backup the log of the database which passed adefined threshold in an alert. Therefore I created an alert for this threshold which starts a job in which I would like to use the token (A-DBN). Doing debugging with print statement shows always the database name "master", although my alert is defined for a user database. Bug or USer error and if it is an user error, what did I wrong ...Show All

• Sean Bales Which Edition of Sql server can run on XP with utility to create table?

  Hi everybody,     Which Edition of Sql server can run on XP with utility to create table like query analyzer and enterprise manager Also for viewing the records. By the way, free or evaluation copy only for windows XP OS. Please specify details. Thanks. den2005 Thanks Mark, I would try it if it works. I'll let you know. Dennis The free express edition can ...Show All

• Scott_Morrison Report Builder fatal error

  and yeee it’s me again :-) cannot load the report buider from http://localhost/reports result is always: Source: .NET Runtime 2.0 Error Reporting EventID: 5000 EventType clr20r3, P1 reportbuilder.exe, P2 9.0.242.0, P3 4258a543, P4 reportbuilder, P5 9.0.242.0, P6 4258a543, P7 3558, P8 b, P9 system.argumentexception, P10 NIL. any possibiblities to solve this kindest regards from austria Irie Mikky hmm hmm hmm it seems the report builder c ...Show All

• softstor Help with SSIS error

  I execute my package to transfer a full database SQL 2000 to SQL 2005, and the transfer fails with this error: TITLE: Microsoft.SqlServer.DtsTransferProvider ------------------------------ ERROR : errorCode=-1071636471 description=An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Arithmetic overflow error converting numer ...Show All

• softgeek delete text character

  hi, for example ; select price from table query results:195dollar I want to see query result only numeric:195 how can I do Allen White wrote: You could try this: select convert(int, price) as price from table That would round the value to the nearest integer value. Don't working :( You could try this: select convert(int, price) as price from table That would round the value to the ...Show All

• Netmon using Checkpoints in nested packages

  I am building a set of packages to load different things, some of which have relationships with the others. Therefore I want them loaded in a certain order. I have built a main package that executes the set of packages to control the flow of the packages. Now, I want to implement checkpoints. Ultimately, I only want to deal with the main package that controls everything. So I figure the main package needs checkpoints enabled. When packages a ...Show All

• xensu Killer problem with Scheduled Reports

  I'm running on SQL 2000 with SRS. Standard install ( I think, it was all set up by IT) I have reports that run fine in the Report Manager but when they are run through a schedule (email) some of them (albeit most) "rsProcessingAborted" because of a report error. Looking at the logs it seems generally based around comparison failure because of datatypes, eg (from the logs): Microsoft.ReportingServices.ReportProcessing.Rep ...Show All

• Blazing Moose connection strings for "create database" queries

  I'm using connection strings to SQL Server Express that have the form "DataSource= .\SQLEXPRESS;AttachDbFilename="(path to my development directory)\CurrentDevelopmentDB.mdf;Inte grated Security=True;Connect Timeout=30;User Instance=True" I'm assuming this works because the DB is already there, created "manually". How might I build a connection string for a SQLCommand for a "Create DataBase" query I'm confused ...Show All