Answer Questions

• Richard Hough Displaying Fields from Multiple Datasets (RS2000)

  Hi guys, I have this problem of displaying fields from multiple datasets. When I drag a field from the first dataset into a table, it works and displayed correctly. However when I dragged a field from a second dataset, it will be shown as =First(Fields!FirstName.Value, "DataSet2") for Strings and =Sum(Fields!StatusFlag.Value, "DataSet2") for Integers I just want the integer from that single row but it sums up all the rows. When I removed the SUM keyword, the IDE will show build errors when I try to build the report. Is there any way to get around this thanks! Use the First keyword for integers as well. According to the data types, the IDE will always choose SU ...Show All

• tdtdtd Use Variable as Table Name

  I am trying to write a stored procedure that accepts a table name as an argument and then displays all of the columns of the table. My code does not work and I don't know why any ideas set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [selectTable] @tableName varchar ( 50 ) AS select * from @tableName ; I get this error: Msg 1087, Level 15, State 2, Procedure selectTable, Line 5 Must declare the table variable "@tableName". Please help. OK that worked. Now I'm trying to compose a statement that uses other variables but I'm getting an error. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ...Show All

• Brad.K problem with query

  Hello , Actor ANO ANAME A1 L Tree A2 D Pond A3 M Lake A4 J Worthy A5 T Gross A6 L Leaf   Movie MNO MNAME M1 Work a lot M2 Sleep too little M3 Too much fun M4 Laugh and Cry    PLAY ANO MNO Pay A1 M1 $77.00 A1 M2 $80.00 A2 M2 $93.00 A2 M3 $88.00 A2 M4 $91.00 A3 M2 $74.00 A3 M3 $89.00 A4 M2 $75.00 A4 M3 $85.00 A4 M4 $55.00 A5 M1 $50.00 A5 M4 $61.00 A6 M2 $77.00 A6 M3 ...Show All

• BarrySumpter Creating offline (local) cubes using XMLA, or any other way..

  Hi, I realise this subject has been discussed a lot but there seems to be no definitive answer. The company I work for creates many cubes (currently using many SQL statements) for the sales regions at the end of each month and we need to move to a better platform, hence analysis services projects. Is there any "easy" way to take a cube created by an analysis services project and save it to an offline (local) cube Currently I am trying to use VB.NET 2005 to process the XMLA definition from AS2005, which is easy to get at. The VB code is: Dim myClient As New Microsoft.AnalysisServices.Xmla.XmlaClient Dim l_result, l_XmlaCommand As String l_result = "" Try ...Show All

• Bhavin Mistry406063 SYSAdmin users do not have permission to see records in a view?

  We have a third party application and wish to create a report based upon a view. The strange thing is logged in to the server as a SQL SYSAdmin account, we cannot view the data via the view. SQL Admin accounts are setup correctly and there is nothing different on this particular server. No errors are returned just a blank view with no records. Could this be a permissions problem or orphaned schemas in that particular database I thought SYSAdmin could view and do just about anything and the people who use this particular database would not have the know how on denying permission to the SYSAdmin role. Thanks N Thank you, I can see the logic in that. Nice way of denying sysadmin read permis ...Show All

• Danny Tuppeny NotificationText

  Hi I wish to know why my notifications don't send the resulting text to my email. I get the email but with an empty body. I searched the NSDistributionLog table and the field NotificationText is NULL. Does anyone knows if I am missing some configuration or something Thanks a lot in advance.. Try turning on verbose logging in the config file to see if that sheds some light into what's going on. HTH... Joe Hi I don't know what is happening but the file notifications are generated correctly with the same xslt. But the smtp are generated with an empty body. I don't think that the NotificationText field is relevant since the records for the file notifications also have nulls but are written correct ...Show All

• Vassilux Help with declare and cursor

  I keep getting the message Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'declare'. Msg 156, Level 15, State 1, Line 4 Incorrect syntax near the keyword 'declare'. What am I doing wrong declare @dbname varchar ( 8000 ), declare @countyname varchar ( 200 ) , declare @sql varchar ( 8000 ) declare county_name cursor for select distinct county from Zipcodes open county_name fetch next from county_name into @countyname declare dbname_name cursor for select name from sys.databases where name like 'Property%' and name <> 'PropertyCenter' open dbname_name fetch next from dbnam ...Show All

• ChaosUK Remote execution of package via dtexec and "Access Denied"

  I am finishing a port of a project that was done with RS2000/AS2000/DTS2000. The cube process is triggered remotely by a Korn Shell script from Services for Unix that runs a DTS package: dtsrun.exe /S "$ANALYSIS_SERVICES_HOST" /U "$ANALYSIS_SERVICES_USER" /P "$ANALYSIS_SERVICES_PASSWORD" /N "$PACKAGE_NAME" I have finished porting the AS and RS parts to their 2005 equivalents and now I am trying to get the cube processing converted. I have built a SSIS package that processes the cube and I have deployed it to the SQL Server in MSDB. When I am logged on to the SQL Server box directly, I can execute the package via the Management Studio and from the command line via: dtexec /Ser "$ANALYSI ...Show All

• parlance how can i use comma like a decimal separator in Sql Server Express?

  I need HELP "update product set price='1,99' where cod='001'" I need COMMA... not DOT In oracle i use "alter session set language='Brazil'"... but... in SQL SERVER Take a look if maybe that will help you: ms-help://MS.MSDNQTR.2003FEB.1033/tsqlref/ts_sp_da-di_2tk5.htm Moving to the "Transact-SQL" forum. ...Show All

• soanfu Performance problem: 2000 vs. 2005

  I copied a 2000 database onto 2005 on another box. Running the exact same SELECT query, with 7 tables joined, is running in less than 2 minutes on 2000 and almost 3 hours on 2005. The 2005 box is "bigger and better". I've compared the sp_configure output. There are differences in max worker threads, cost threshold for parallelism, and priority boost. I don't think any one of these is significant. I checked the server properties and the database properties and, again, I did not see what I would consider any significant differences. The 2005 instance has 4GB memory, as opposed to 2GB, but not using that much. In fact, the Total Server Memory (KB) for the instance indicates around 1,230,000 for some reason. We need to reso ...Show All

• Scott D. Nelson Set log message within script task

  I have a script task in my control flow that does some validation checking. If one of those checks fails, I want to fail the task and send an appropriate message via email. I've accomplished this by updating a package that is then used as the source for the email message. However I also want my message text to appear in the package ...Log.xml file. Currently it only says that the script task returned a failure result. There must be some way to do this, and I hope some guru out there can help me. Thanks, Phil No. The two work quite differently. Our BOL topics on scripting are quite thorough, I hope. You can find them here http://msdn2.microsoft.com/en-us/library/ms345171.aspx , including a comparison of Ta ...Show All

• ChaosBlade SQL Server does not exist or access denied.

  Server Error in '/orion' Application. Which SQL Server version are you using Beside from knowing that, make sure that you adressed the remote server the right way. It should be adressed with the right name / instanceName and (if you are not using the default port) the right port number, e.g ServerName,Portnumber or servername\instanceName,Portnumber If this does not help, write back to the forum which server version you are using. HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- I am using SQL SERVER 2000 connectionstring = "user id=sa;password=sa;initial catalog=orion;data source=20.0.0.25"; This is the connection string i am using at present how to find port ...Show All

• john_paul Keep package alive forever

  Hi there, Does anyone know how i can keep an ssis package used for real time reporting alive no matter the amount of errors it gets So for instance the server im streaming to is shutdown for maintenance, and the connection dies, its needs to just keep re-trying. In other words the maximum error count is infinite. i dont just want to set max err count high, i want it out of the picture all together. Thanks We currently replicate. but due to performance issues starting to rear their heads, we have changed our structures on our ODS to include only data marts - therefore we need to transform all that gets replicated to our ODS Thanks for the reply. Yup gonna go ...Show All

• Zhen CREATE SCHEMA fails Inside an If Block

  Hello All, The below "CREATE SCHEMA" sql statement fails if it is inside an IF block. It runs fine if i run it without the IF block... --------------------------------------------------------------------- IF NOT EXISTS ( SELECT * FROM sys.schemas WHERE name = N 'Customer' ) BEGIN CREATE SCHEMA Customer AUTHORIZATION [sys] END ---------------------------------------------------------------------- Did anyone encountered this issue before.... Thanks.. Make this as dynamic SQL. Like the error message you get back says, CREATE SCHEMA must be the first command in the batch. So to do a CREATE SCH ...Show All

• Cla82 performance issue,help please

  Hi, I have a table,which increases fast, 1,000,000rows/day. insert/update/delete/select on this table. an index on accout column was created, and we often use this account column in the where condition. like : select name,account,amount... from mytable where account='12345678' update mytable set ... where account='12345678' How to increase the performance on it partition the table Thanks, any ideas will greatly appreciated. table structure: account int, name varchar(20), desc varchar(50), amount money, tr_date datetime, balance money one account may have one or more records. Ditto. Also, can you post the structure of the table, inclu ...Show All