Answer Questions

• ericcwhung Percentile

  Hi, l would like to calculate 80% and 95% percentile of a column from my table in SQL server 2005. Does SQL server 2005 provides such built-in function, if not, how should l do Any suggestion (Suggest to MS : Please include percentile as a built-in function on the next services pack). Thanks and happy labor day! Lookup the NTILE and RANK functions in Books Online. -- David Portas, SQL Server MVP Whenever po ...Show All

• wilyCoyote Text in to Datetime Question

  Using SQL 2000 I have created a DTS Packages to import data from our back office database, which uses DBF files. This works great, however the way in which the dates are stored in the DBFs are as follows: - 4th May 2006 = 05/04/A6 (The A was a desperate bid by the developers to get by the Y2K issues) Now the data is in SQL, I have created a view for each table, which re-orders the date data so it is displaye ...Show All

• arunhegde Report Deployment Problem on SQL 2005

  Hi everyone, I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error: " The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. " Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still ...Show All

• Geert V Disconnecting from engine does not closes database

  I connect Managment Studio to MSDE 2000SP4. Open database, open some object, then disconnect from engine (not simple collapse DB objects). In other programm try to drop database. Until you don't close MSSQL MStudio, database is in use. In older version collapsing DB objects in tree closes DB. I have "Drop connections" checkbox for that case. It works in SQL2000 and I see it in SQL2005. Pl ...Show All

• Steelhand Query Designer in SQL 2005 Mgmt Studio a let-down?

  Greetings, all. Thanks for all of the great postings in this community. However, one question I have doesn't seem to have been addressed. In SQL 2000 Enterprise Manager, a user could right-click on a table, and choose Open Table>>Query. This option brings the user directly to a query designer very similar to the query designer available in SQL 2005 Management Studio. However, I have been frustrated by the following: - The Open Table ...Show All

• Islandstone007 Howto do totaling in column wide in matrix table

  Hi Can some one help me please I am using matrix table and i need to do total column wide say example           priority 1      priority 2        P 3            $ 100           $ 500         $ 200&nb ...Show All

• Joszef Input parameter to function in SQL query

  I am trying to use a Execute SQL task in which I call a query and get back a scalar value. I THINK I have it set up correctly, yet I am getting a very unhelpful error message of: Error: 0xC002F210 at Determine Previous Trade Date, Execute SQL Task: Executing the query "SELECT[Supporting].[dbo].[fGetOffsetTradeDate]( , -1) AS [PreviousTradeDate]" failed with the following error: "Syntax error, permission violation, or other nonspec ...Show All

• TAO DE ZHI Restore Master Key

  Do we need to know the database master key password inorder to restore the same from a Master Key backup What if the scenario is like, I have Master Key backup file but do not have the password specified at the time of creation Any help is appreciated. satya To recreate the same symmetric key that you used for encryption, you need to use the same algorithm, identity_value, and key_source in the CREATE SYMMETRIC KEY statement. ...Show All

• Kasic Slobodan can't open adventure works example

  after running msi, can't open this solution C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\Standard, select the file Adventure Works DW.sln ---------------------------error msg Microsoft Visual Studio The application for project 'C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services Project\standard\Adventure Works DW Standard Edition.dwproj' is not installe ...Show All

• Lance199 XML Tools in VS 2005

  This Channel 9 presentation [1] was not a very good side-by-side tutorial that can be used to follow along while using VS 2005 but it was a good start and very good insight into what is now possible when using the VS 2005 XML Tools that have first showed up in Beta 2. Hopefully we'll start seeing this type of information available for SQL Server 2005 and more importantly how to use VS 2005 with SQL Server 2005 when developing proj ...Show All

• Tyler Clendenin Can it be a bug in SQL CE?

  Hi! I use SQL CE with VS.NET 2003. I find the following bug second time. The table has an " ID int IDENTITY(0,1) PRIMARY KEY,". That is my row identity. I add rows to the table, then I made some select and update queries. Then I realized that the ID order not in the general order (from 0 to ........) For example: 6,7,8,0,1,2,3,4,5. Of course row 6,7 and 8 was added the very last. The content of each row is not mixed, ...Show All

• alan93 Random Failure of Lookup in Pre-Execute with 0x8007000E

  I have a SSIS package that I can run three times in a row and various lookup components will return: Error: 0xC004701A at Foo, DTS.Pipeline: component "Lookup Date" (166) failed the pre-execute phase and returned error code 0x8007000E. Without changing any input data or the package I can just hit F5 again and occasionally get past this or sometimes get stuck on it. Any ideas what that error code means Are you certain it has "frozen" in ...Show All

• Grahamrounce SQL express database + IIS

  hi all, i have implemented a program, that is divided into two parts, a window form and a website.  they both use the same database(SQL express). (the website is not meant to be published online, but on a local host) Everything works great, when i am in the VS enviroments. but when i publish the website the following happens: if i use the website first and login, thus accessing the database, even if i close my explorer , ...Show All

• strider-_- SQL Server Profiler and Sysmon monitoring local vs. remote

  Most people have heard the suggestion to monitor a SQL Server from another machine because Profiler and Sysmon consume a lot of resources. Monitoring a server locally also introduces a Heisenberg uncertainty principle type of problem where the act of measurement alters the state of what is attempting to be measured. I heard a SQL Server MVP making a case for not monitoring remotely because of the network bandwidth demands. Are there situations w ...Show All

• Arvind Surana OLD MEDICAL PROGRAM IN ACCESS 1.1 CONVERTED TO 2003, DOES NOT RUN.

  Thanks Mr. Wachal. We did everything exactly what you have suggested us to do. The MDB file is now in Access 2003. BUT, BUT, the program, that was written over 12 years ago, does not understand the new file. It is not able to open the file. It seems that the old software only understands Access 1.0 or 1.1 MDB files. So, what can I do to with this old medical software, wery useful and practical, but unable to be upgraded with a newer data ...Show All