Answer Questions

• Mosesm Execution plans - SQLCE 3

  Does SQLCE 3 cache execution plans Or even make use of them Thanks Tryst Hi Iyla, and thanks for the reply. Do you use specific software for bench-marking Or do you just put your own code into specific areas of the code you are testing Thanks Tryst This quesiton is better suited for the Sql Mobile forum. I'll move it there. Thanks. I'm using my own code to measure how long it takes to execute one way or another. In some cases you can see 10x gain from using parameters (usually on bulk inserts). Not only your command is prepared, there's no need to convert data to strings to create SQL statement and to convert these strings back to binary to be used by SQL Mobile engine. ...Show All

• is98 rookie sql question

  SQL, It's up and running, 2000. Looking in enterprise manager at the server, Green right handed arrow(running) with a red squiggly line What is that (mean) Thanks From a technet article... "As far as that red squiggly line – I doubt that you'd want to get rid of that – it means that you have a connection to that SQL Server. This is a good thing" http://www.microsoft.com/technet/archive/community/columns/questions/03-01-00.mspx mfr=true Thanks, Sam Lester (MSFT) Funny that querys would not run or complete until that red line was gone. ...Show All

• Xiaobo Gu Does SQL 2005 encryption on x64 work?

  Are there any known issues with EncryptByKey/DecryptByKey on x64 machines I have a test script where I create a sample table and encrypt a column and later decrypt it. It works fine on my x86 box. When I run the *exact* same test script on an x64 server I'm getting unprintable characters back on the DecryptByKey. I cannont find anything I'm doing different between the two. Has anyone seen anything like this before We have not seen this problems yet but I will take a look and attempt to repro this. Would it be possible to get a copy of the script you are using (obviously, please remove all private/sensitive info first) Thanks, Sung Ah, ok, I was wondering if it had something to do with text encoding as wel ...Show All

• MattinSpace SQL Big number Registries

  I have a lot of registries ~3000000000 and it increases constantly with a big number of registries... I need a solution to make my select return the results as faster as the mahcine can... Is there any good solution to make that....I'm using some king of particioning the main table in other ones separeted by days...but it's to dificult to maintain... Thanks OK, Can you give me an example in how to use partitioning in SQL 2005 or 2000 for the case of select a period of time PS: The select is created by the user selecting a period of time....so he can put a value that may return a large quantity of rows... Thanks for helping You will have to use a partitioning strategy to manage such large tables. Creating ...Show All

• iJonny Set filter to date Now()

  I want to set a filter to calculate the date range to be 1 year ago to last month. Is this possible ps. Im working with a AS cube. It's possible. Just create your mdx uniquename value off of the now function ie "[" & Year(Now) & Month(Now) & "]".... but what if the current date is in Jan Well I guess you didn't say what data source you were using - it might not be analysis service, but regardless, you can make an expression or value out of Now() and put that in a filter. Correction its for a date range of the current year January- the month prior to excution, (So Now() minus one month). Can anyo ...Show All

• SnakeSV Stop Processing on Key Errors AS 2000

  I'am using MS AS 2000. I have added to my fact table keys which are not included in my dimension tables. Then I process the dimensions and the cube. I fully processed the cube and used the default process options (Stop Processing on Key Errors; 0). But the cube processed without an error. The invalid records in the fact table are just ignored. Why Thanks for any reply, HI Cornelius Have you specified that your dimension keys are unique If you look at the query that is run when you process the cube and see if it is doing any joins, as it could be joining to the dimension tables in the query, which would then exclude any rows that don't have valid dimension keys, in which case the cube would process succesfully. Hope this he ...Show All

• jitendra badkas Credentials used to run this report are not stored

  Hi all, When I create a new report subscription in report manager, I got this error Credentials used to run this report are not stored any idea Thanks, Jone Could you use a Windows domain account and it's password Then, you will need to check the box for 'Use as Windows credentials when connecting to the data source' also. Jarret I don't think there is an email extension for Reporting Services, you might be able to find something out there that will add this functionality though. I haven't heard of any, but I haven't looked either. I think you will need to leave your exchange server in the SMTP Server name. Jarret ...Show All

• zerovelocity choose from SQLDMO /SMO

  in my classic ASP 3.0 application I would like to back up and restore SQL Express database. Should I use SQLDMO or SMO Whats the difference Allen, I am using SQLDMO in my C# application for backing up and restoring MSDE 2000 database. Backup operations run fine, but Restoring fails. I've tried to KILL all the connections from the application but get the "cannot use KILL to kill your own process" error. Any ideas to solve this problem Thank you in advance for your help. JC Thanks for your answer.I am using SQLDMO for backing up and restoring Sql Express database. While Restoring if i have any users connected to db ,restore fails.. Whats the solution for the ...Show All

• AksaiGora SQL Server Query

  I have a query as follows: SELECT dbo.v_AgentProductsTotal.AGENT_ID, CASE WHEN total > u_limit THEN ((u_limit - l_limit) * (rate / 100)) ELSE ((total - l_limit) * (rate / 100)) END AS comm FROM dbo.t_CommTables INNER JOIN dbo.t_Products ON dbo.t_CommTables.TABLE_ID = dbo.t_Products.TABLE_ID INNER JOIN dbo.t_CommTableRates ON dbo.t_CommTables.TABLE_ID = dbo.t_CommTableRates.TABLE_ID INNER JOIN dbo.v_AgentProductsTotal ON dbo.t_Products.name = dbo.v_AgentProductsTotal.name this produces results similar to the following: AGENT_ID | comm 1 | 135.00000 2 | 18.000000 3 | 9.0000000 4 | 27.000000 5 | 9.0000000 1 | 150.00000 1 ...Show All

• laboremus Cant get Reporting Services working

  Machine is Sql server2000 sp4 Running IIS 5 Also Running SqlServer2000 sp3 I approached machine installed sql server2005 developer edition. Prerequisites installs .net framework 2.0. Then 100% successful System Requirements. Then 100% successful Install. I discover reporting services service did not start and wont start. I discover that i need to modify rsreporting.config to point to IWAM_NTSERVER2 for asp.net logon. Then the service will run . But still can't navigate to it. In the configurator, The web identity is red x. I discover sql browser service not running. I needed to install sql server 2000 SP3. browser now runs. All services are running but cant navagate to http://localhost/reports$SQLSERVER2005 SQLSERVER2005 ...Show All

• StarSS Return Top row from a ResultSet - SQL Server (TOP)

  Hi all, I need to return only the top row of a ResultSet that is generated from my Query but can't seem to find anything in SQL Server 3.0 Mobile that allows me to do that. I know in SQL Server (Desktop) I could use the TOP keyword. The query I have is as follows, and just need the top row. Now the returned resultset will, in time, be massive, and there is just no way I can afford to return this amount of data in my application only to take to the top/first row. The query I have is as follows... SELECT * FROM tbl_NSP_AnswerSet WHERE (DateCompleted IS NOT NULL) ORDER BY DateCompleted DESC (I want the last record that was inserted into the database) Thanks Hi SELECT * FROM tbl_NSP_AnswerSet WHERE ( DateCompleted ...Show All

• nglow Persistant variables

  Greetings SSIS friends. Is it possible to create a persistant variable in an SSIS package dreameR.78 wrote: Greetings SSIS friends. Is it possible to create a persistant variable in an SSIS package Meaning what, exactly Hi Phil, I will try your suggested method. Thank you. The variable retaining its value after the package is run. dreameR.78 wrote: The variable retaining its value after the package is run. I suppose there are progmatic ways of doing this, but the "easy" way that I can see is to use SQL Server based package configurations. At the end of your package, you issue an Execute SQL Task to update the configuration table to set the value of the variable in ...Show All

• QWERTYtech SSAS Cellset help urgently needed, please

  Hello, I am trying to write an SSIS package which will extract data from a cube, which cab then be inserted into a table in a SQL database I started by creating an ExecueSLQL ask, but the results I got back seemed to include other stuff, not the same results I would see if I ran the MDX in a query window. So I was unable to map the results to my SSIS variables for the next container to use in the package. EG this query: WITH MEMBER [Measures].[AttributeID] AS '1' SELECT {[Measures].[ Balance], [Measures].[AttributeID]} ON COLUMNS, {[Date].[Calendar].[Month].&[2006-Feb]} ON ROWS FROM [Accounts Brings back (in Management Studio): Balance AttributeID 2006-Feb 83,812,057,273.89 1 But ...Show All

• selva_kumar Download for redistributable SQL Server Express Edition?

  Where do I find the setup files needed to redistribute sql server express installation files I downloaded the SQLEXPR_ADV.EXE but the files disappear as soon as you cancel the installation. I need the sql server setup files to package with my program fr distribution. THANKS SO MUCH Thanks for prompt reply. Yes, I know and that is exactly my question (Second, when you doubl-click the file SQLEXPR_ADV.EXE, it starts to extract all packed files into a temporary directory. You can see a progress window and it will tell you the temporay directory where you can find unpacked files and folders. Then it will start to perform setup. After setup finishes, this temporary directory will ...Show All

• Jason Conner Error: Create element cannot appear under Envelope/Body/Execute/Command

  Hi, I am using java and trying to do HTTP access using the msmdpump.dll. I am generating the Execute xmla, which contains a <create> inside the <command>, in the sequence shown below, <Execute> <Command> <Create> I know that this is the right schema, then why does ssas give the error, "The Create element cannot appear under Envelope/Body/Execute/Command" How should I not create my xml schema what should its structure be I know that it has something to do with being a Major object or so, but how to re-structure my execute xmla Thanks in advance Regards hello, can it be because of the namespace what's the namespace that you have for Create element while ...Show All