Answer Questions
Dhanhamsan Gunalan I can't show a calculated member
I need to show a calculated member in a report. Reports works fine with calculated measures, but when you try to use a calculated member then raises an error which says The following system error ocurred. Invalid procedure call or argument. Any ideas Can I use calculated members I'm using RS 2005 April CTP. Thanks in advance. We submitted an issue with MS about this and were told that this was by design. ...Show All
Shughes Unable to run "Management Studio(ssmsee.exe)" for Sql Express edition
Hi, I have downloaded Sql Express edition for Yukon. After that I installed the UI - Management Studio (SQLServer2005_SSMSEE). I checked and I was able to open and work using the Management studio. Afterwards I installed some "SQL Server 2005 Express Edition Documentation and Samples" from the following link ... http://www.microsoft.com/downloads/details.aspx FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&DisplayLang=en#filelist Now after i ...Show All
Shai Zohar - FXM Help Designing an App. to be Run from a Job
Hello, I'm working on a project that uses SQL Server 2005 and C# 2.0. I need some ideas of the best way to design/implement an application that will be executed from a SQL Server job. The general idea is: a SQL Server job will call [ something ] and pass a couple of parameters to [ something ], then [ something ] will query a database and gather other information, then [ something ] will do some processing of data, and finally [ something ...Show All
Praj1 Have to install to c:\ ?
I'm having a hard time with installation of SQL 2005 on Windows Server 2000. I'm trying to put everything on d:\ but I think it is failing as a result. Is there anything I should know about this Thanks in advance. -Greg As a follow up on this, as soon as I installed everything to C:\ everything worked stellarly. In listening to the traffic here, it appears 98% of SSRS users are using a non-distributed configuration. While the product sup ...Show All
TFSFailedInstall Instantiating ReportExecution2005 fails with forms authentication
Greetings, I am using forms authentication with reporting services. When I Instantiate the ReportExecution2005 interface in a web app I get the following error: <html><head><title>Object moved</title></head><body> <h2>Object moved to <a href="/ReportServer/logon.aspx ReturnUrl=%2freportserver%2fReportExecution2005.asmx">here</a>.</h2> </body></html> I a ...Show All
allears42 STRANGE SQL Query
When I try to execute the below query: select * from jobmaster where status in ('Active') and materialtypecode in (1,2) and unit='IMPERIAL' and superusercode='S051000014' order by controllercode,jobname through ADO I got the error message: Invalid column name controllercode When I execute the same above query in MS SQL Query Analyzer it is working. Is there any workaround Could it be that ...Show All
MilkMover SQL Update Query
The scenario: I have two tables in two dbs on the same 2000 sp3a SQL server. My LaborEmployee table in db1 has HourlyRate, grade & step fields. My GradeStep table in db2 has grade, step & payrate fields. When I run; Use db1 SELECT LaborEmployee.Hourly, LaborEmployee.grade, LaborEmployee.step, LaborEmployee.EmployeeName, db2..gradestep.payrate FROM LaborEmployee, db2..gradestep where LaborEmployee.Hourly = db2..gradestep.payrate ...Show All
prinso What is the ADO DataType for nVarchAR(max)
I can't seem to get nvarchar(max) to work with ADO 2.8 using sql native client. I am creating a stored procedure and every time i attempt to add a parameter to the command object of type nVarChar(max) I receive the error "Parameter object is improperly defined" here is the code to add the parameter cmd.Parameters.Append cmd.createparameter(@piComments,adLongVarWChar,adparaminput,,me.comments) adLongVarWChar is the ad ...Show All
MRoy SQL Server 2005 has shipped!
This morning at 9 AM in shiproom, we did official signoffs for SQL Server 2005! SQL Server 2005 is in the bag! Congratulations ! I am eager to get it going. Does it require to uninstall June CTP / Sept CTP before installation thanks, Nitesh That is very exciting news! :) Muy buenos dias con quien tengo el gusto Leonardo Rodriguez wrote: Well Done! ...Show All
Craig McMurtry Managing SQL Server Agent
Hi, I would like to know what are the possibilities to mange the Sql server Agent in the Sql Server 2005 express edition whit the Sql server mangement studio express, because I can't see it . thanks Hi, you can’t manage it, because it isn’t there: Look at: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All
Dong Xie ExecuteSQL task has changed
Since the last IDW. The column "ParameterName" has been added to the ParameterMapping tab of the ExecuteSQL task. I enter a statement of SELECT * FROM TABLE WHERE COLUMN = I map to a input variable. The default name of the parameter supplied is "NewParameterName" My task now fails with Error: 0xC002F210 at Execute SQL Task, Execute SQL Task: Executing the query "SELECT * FROM TheBigOne WHERE HostName = " failed with the ...Show All
Genyus Retieving ODBC Settings.
I'm having some issues grabbing ODBC Settings. First off I need to present a user with the options to select thier DSN, Server, UID, PWD, and Database settings. I have come up with a way using the SQLBrowseConnect function to obtain the Server and Database information I need. Therefore, I have a semi working version of the program. I just need a way to make the program a little more user friendl ...Show All
JayTaplin Using VB2005 Express to access a SS2005 Express Edition DB: O/S Error 32
Looking for help in diagnosing this error: Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\cartracker.mdf". Operating system error 32: "32(error not found)". An attempt to attach an auto-named database for file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\cartracker.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. ...Show All
Sajay - MSFT SSRS Subscription jobs in SQL Agent
We have been using SSRS for many months now and have a substantial no. of reports developed and running in Production. We noticed that subscriptions on the reports were created as jobs with uniqueidentifier names on the SQL Agent. This happens even when the subscriptions are not active anymore i.e. run-once subscriptions which have already run. And when these jobs are deleted manually, they get recreated automatically even for the inactiv ...Show All
Chunda Inner Join matches non-equal fields??????
Hi group, This morning we had an issue with a simple join between 2 tables e.g. table1 and table2. Both tables have 1 column called 'fielda' with datatype varchar. Let's assume the following values: Table1: hello Hello Table2: hello This statement joins the tables: select a.fielda from table1 a inner join table2 b on a.fielda = b.fielda It returns: hello Hello What the $#@#$ Why doesn't it return 1 value: hello Any ...Show All