Answer Questions

• iamAlan SQL Tables and ASP page

  We are getting emails from loyal site visitors telling us this.... Well, it gets odder. I figured that if something from the previous day came in where you're supposed to be that maybe you'd come in the next day where something else was supposed to be. Yep, the last part of your That's a Plenty segment comes on 36 minutes into the 10/13 show (which starts in the middle, not with Dave's intro and ends in the middle of something when you come on - which I don't think is completely explained by it being pledge drive). But there's still a piece missing. You said that you played 6 versions, but I've found only 4, 1 on the 12th and 3 on the 13th. I don't know where the other 2 versions went. Incidentally, I have 9 versions in ...Show All

• Roy mm Reports run under my credentials, not those stored on report

  I've created a report in SSRS 2005 that sources from a SSAS 2000 cube (on another server). In BIDS (running on the SSRS 2005 server) I'm using a shared data source with "generic" credentials to access the data. The generic credentials I'm using is an account that has datareader access. In BIDS the report runs, builds and deploys just fine. No problem so far! My problem has to do with running the report from the Report Server. The only way I can get the report to run from the Report Server web site is to modify the data source and pass my credentials in the report (thereby overriding the credentials stored in the report). Why would this be SSRS is running on a Windows Server 2003 machine and I've installed the SQL 2005 SP1. ...Show All

• Arjan Ligthart Rounding a number

  Hi, I need to round a number in a table to either 2 or 4 decimals: =((Sum(Fields!Total.Value) -Sum( Fields!Total_used.Value))*100)/(Sum(Fields!Total.Value)) & " %" This results in a number like 91,1243656438345% I would like it to be rounded to 91,1244% or 91,12% Is there any builtin round-function, that does not just turn the number into an integer Thanks for your help You might just need to change your format settings to conform to your use of a comma (,) as opposed to a UK full stop (.) for the decimal separator... I've discovered that the use of comma or dot as seperator is automatic depending og language settings... So in this case I don't need to do anything... finally something is ...Show All

• vdv_phuong Does .NET support mySQL connectivity?

  If so, what category does this fall under (ODBC, etc). I need to be able to send queries and updates through C++ .NET 2.0. You can connect to MySQL through ODBC, but there seems to be a more native driver for it, too: http://dev.mysql.com/doc/refman/5.0/en/connector-net.html ...Show All

• Wellnow Problem after applying snapshot publication to subscriber

  Hello all, I have a unusual problem with a snapshot publication that I am having a hard time troubleshooting. The servers in question are all SQL 05 Enterprise. Here is the scenario: Staging Server - This server acts as the publisher of the snapshot Production Server - This server is the subscriber of the staging snapshot Cascade Servers - These servers receive transactional updates from the production server The staging server applies the snapshot to production successfully. From there the production server has a transactional publication which the subscribers are the cascade servers. This model worked for a long time where we would generate the snapshot apply it to production and the updates would be sent to the cascade serve ...Show All

• Vishal Shah Child packages: Execute them all out of process?

  HI, I have some parent parent packages that calls child packages. When I added a bunch of packages, I faced the buffer out of memory error. I then decided to set the child packages property ExecuteOutOfProcess to TRUE. I noticed that the execution time is longer now. Is this a good practice to set the ExecuteOutOfProcess to true If so, is it normal that the execution time is longer Thank you, Ccote ccote wrote: HI, I have some parent parent packages that calls child packages. When I added a bunch of packages, I faced the buffer out of memory error. I then decided to set the child packages property ExecuteOutOfProcess to TRUE. I noticed that the execution time is longer now. Is this a good pr ...Show All

• davidg12 Report Builder and NULL values

  Hi, I am trying to create a report with Report Builder, using a simple data model residing on SQL2005 reporting server. The problem that literally drives me crazy is that I can't find any way to handle NULL values in my report. Say, a table has 3 numeric columns, and I need to create a formula to make a sum of those 3 columns. This would be an ordinary sum for the same entity, not an aggregate. So I create a new formula with following body: Field1 + Field2 + Field3 The problem is, each one of the 3 columns can have NULL values, and if any column actually is NULL, I end up with empty sum value, instead of having sum of those columns that do have values. What I need is one of the following: - a way to check for NULL values ...Show All

• MusicMan2006 Open a file in Management Studio

  Hi, The most thing I hate in Management Studio is when I select File/Open/File and then select a SQL script file to open, Management Studio displays a "Connect to Database Engine" dialog box. In SQL Server 2000 Query Analyzer, open the file in the current connection. Is there any setting to change in MS in order to get the same behaviour as QA, please don't tell me for security enforcement reasons you cannot. Thank you For security enforcement reasons you cannot... ... Well, that seemed to be the best idea when we shipped SQL Server 2005. But then we heard from the people who have migrated from SQL Server 2000 and they didn't like having to click Connect or Cancel all the time. We've modified the default behav ...Show All

• Kyle_W Transform-Pivot in SQL Server 2005

  Is there any equivalent for Transform-pivot of MS Access in SQL Server 2005 I have this query in MS Access that I need to migrate to SQL Server 2005 TRANSFORM Sum ( CD1 ([CheckAmount])) AS [The Value] SELECT "Total Amount of Checks" AS Type, tblResult.AccountNumber, tblResult.CheckDate, tblResult.Status, Sum ( CD1 ([CheckAmount])) AS Total FROM tblResult GROUP BY "Total Amount of Checks " , tblResult.AccountNumber, tblResult.CheckDate, tblResult.Status PIVOT IIf ( IsNull ([statusdate]), "Outstanding" , Format ([StatusDate], "Short Date" )); Give examples of some rows from the tblR ...Show All

• Leo12 dependent parameters (datetime)

  Hi, I have two datetime parameters in my report: start_date and end_date. Is it possible to make a rule(restriction) for the user to not be able to chose start_date>end_date or to prompt him when he tries to run the report Thank you, Mihai ...Show All

• Shazen Use of temp table

  Hi there In Control flow of my package I have  created a temp table. How do I use that temp table in my next task which is Data flow task. I want to use my temp table as source in data flow task. I have set retain connection property of my connection as true.\   Thanks and Regards Rahul Kumar, Software Engineer Hi OOh ...ok you have to use Globale Temproray table for that, it should be verified that after the execution that what is the session managment. You have to Just use ## sign instead of # one for creating Globale Temproaray Table Hi As you use other Tables. but remember if the Session end then The Temproray Table will be lost... you can also ...Show All

• UlliDK Web Service Task always failing

  Executing the simplest of Web Service tasks consistently fail with the error: "Object reference not set to an instance of an object". This really isn't a very helpful message for this task, and there's nothing from the task editor that can be adjusted. I am using SP1, the HTTP connection to the service tests OK, the WSDL file downloads OK, and the methods and parameters appear OK. Suggestions Richard This does not work for me also.. Same issue same failure. The configuration process accesses the methods ok, but fails at run time. Here's the entire error message as displayed in Visual Studio 2005: SSIS package "ConvertMoney.dtsx" starting. Error: 0xC002F304 at We ...Show All

• Handschuh WMI Connections and Server name

  Hi, I am using For Each container loop to read set of data in to variables and populating my WMI reader Task. WMI reader task uses WMI connection. I am assigning the Server Name for the WMI connnection during the run time of for each loop. Expression for WMI Connection is like that Expression ServerName @[User::WMIConnection] I have verified the my @[User::WMIConnection] variable has the proper server name like \\servername but it is not poulating the serverName filed of WMI connection. I also tried to assign the ServerName property using Script Task but DTS.Connection("conn") does not have the ServerName property. Please Guide Use Script Task, to set the ConnectionString property of the WMI connect ...Show All

• AmrishDeep Throw sqlException

  I'm using VS 2005, c#, asp.net and SQL Server 2005 for a web application. I want to throw a sqlException from one of the methods if there is any problem with DB connection or execution of the query. I have written the following code, but I'm getting error: try { } catch (SqlException sqlEx) { throw sqlEx.Message; } When you are having connection problems, you will most likely be getting a ADO error rather than a SQL Server error -and that will usually be caught as a SqlException. However, a query execution error is a different animal. Obviously, syntax or query compilation errors will be immediately tossed back as SqlExceptions. But a logic error, a design flaw, and even a 3 ...Show All

• Shyam Amrawat SSIS: error while trying to get set the table list

  i have a SSIS package on a server that transfers 4 tables from one database to another. The pakage runs fine with an admin account who is the creator of the package. The package was created and imported to the server. A non admin user, is able to connect to SSIS and browse the packages but when he runs the pakage, he gets the following error: Error: An error occured while trying to get set the table list to transfer. "An exception occured while executing a Transact SQL statement or batch." Does anyone know how to fix this Any help is appreciated. RookieDBA wrote: It is stored on sql server. this link should help: http://msdn2.microsoft.com/en-us/library/ms141053.aspx ...Show All