Answer Questions

• Stuart Baker message box in rdl

  hi everybody i m using dynamic connection in rdl file firstly i m showing username and pwd . after this user name and pwd i make a connection string for my report. when i m entering invalid pwd, than report generate an error. and stop. is there any way by which i can trace error and flash a message box to user about his invalid user name or pwd. thanks If you use the report viewer controls, you can trap the ReportError event in your code. Otherwise, the error message will always be embedded in the report. ...Show All

• Lenoire77 Sql Express database issue

  Hi This ones taken all day to find, now I just need to know how to fix it. I have a c# app that has an sql express database in the project, every time I run the app a new copy is copied to the debug folder and all my updates, inserts etc get over written each time (thought it was my update routine not working). I've changed the database property to don't copy and the app can't connect to the database at all then, has anybody got any information on how to either stop the database from being overwritten or how to correctly set the don't copy property. Thanks Inadvance Duncan I ran into a similar situation. You have 2 separate but related problems really. 1. Your database is being ove ...Show All

• Morrissey99 install reporting service 2005

  Hi I tried to install reporting service after i had installed sql server 2005, I find reporting service checkbox is disabled, so i can not install it. Why it is disabled, and how i install reporting service. thanks I resolved the exception error thanks to the post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=573569&SiteID=1&mode=1 after reading the post , I downloaded the refactor software . I tried to install it , but it could not be installed due to error: "Error 1001: The SavedState Dictionary contains inconsistent data and might have corrupted." I traced the propblem until i found that DXCore (software provided by same company of refactor) was the reason. I ...Show All

• kpmkhaja JDBC Connectivity problem

  An application on our sql 2005, x64, server is trying to connecto to our HP 3000 using JDBC (from MiniiSoft). The applicaiton fails. Are than any administrative tools from Microsoft that I can use to see if the JDBC connection is good (We are new users of th app and it is possible that we have misconfigured the app but be want to check that JDBC is working as a first step.) We use jre 1.4.2_11 TIA, barkingdog P.S. I have heard about a Microsoft JDBC product. We haven't tested it and don't know if it can talk to an HP 3000 (which uses a MiniSoft listener) Microsoft JDBC driver is supported to connect to Micrsoft SQL Server. http://msdn.microsoft.com/data/ref/jdbc/ Your ...Show All

• Ridhi Dua Oracle REF CURSOR

  Good day! Does SQL Server has aby analog of ORACLE's Ref Cursors ex: "type [name] is ref cursor" Thanks you! You could use the output cursors for your scenario. But there are more efficient ways to do this in SQL Server using temporary tables for example. In most cases you don't really need a cursor. So if you want to retain the exact logic, you could use output cursors but there are so many differences between PL/SQL (more richer programming language) & TSQL that it is not going to be a simple conversion. And there is no package object in TSQL so you will have to either create a schema instead of package but this just provides a namespace mechanism. You will have to handle permission ...Show All

• sangeetha shanmugam Problem with multiple measure groups

  Hello! I have two measure groups (MG1, MG2) with measures called M1 (inside MG1) and M2 (insideMG2). For example M1 and M2 are sales amount. The total for M1 is 150 and for M2 100. If I start my analyses with a dimension that is only related to measure group M1 I see the following behavior. Dimension M1 M2 Product A 25 100 Product B 75 100 Product C 50 100 Question 1: How can I avoid AS 2005 to repeat the total value for M2 Question 2: If I define a calculated measure that brings the value from M1 and M2 together. How can I avoid that AS 2005 calculates each cell for M2 even though M2 has no realtion to the dimension Thanks in advance ! Ole If a dimension is not related to a MG and yo ...Show All

• DragonC# Whereis the AdventureWorks and MaxMinSales sample projects/.mdf files (server databases)?

  I installed the samples (Start-->Sql Server 2005->Documentation-->Sample-->Build, however, I cannot locate any projects or .mdf files for these filenames. Hi, If you are asking for the location of the files, it will be in c:\program files\Microsoft SQL Server\MSSQL\Data. Refer http://msdn2.microsoft.com/en-us/library/ms143804.aspx also. Hemantgiri S. Goswami Doing a search on MSDN for "AdventureWorks" gives plenty: http://search.microsoft.com/results.aspx mkt=en-US&setlang=en-US&q=AdventureWorks ...Show All

• HPD DBCC MemoryStatus dump and help 'Insufficient memory'

  Hey guys. Today morning at about 9:58am I had an insufficient memory exception in SQL. I've reserved 12gb memory for my SQL server. I've pasted below the dbcc MemoryStatus dump gotten from SQL log. It also gave me a BPool::Map: No remappable address found My SQL Server version is 8.00.2148. Enterprise Ed. Can you see any problems in the below pasted log 2006-08-09 09:58:11.63 spid175 BPool::Map: no remappable address found. 2006-08-09 09:58:11.69 spid101 Buffer Distribution: Stolen=156843 Free=1634 Procedures=17623 Inram=0 Dirty=108669 Kept=0 I/O=0, Latched=1220, Other=1286875 2006-08-09 09:58:11.69 spid101 Buffer Counts: Commited=1572864 Target=1572864 Hashed=1396751 InternalReservation=510 ExternalReservation=130 Min Free=15 ...Show All

• NathanM Permissions issue- a previous windows group still has full cube rights

  Previously, a windows group was added to a 'full access users' role. It was removed and the cube was processed and deployed, replacing rights, but people in that group still have rights to see the data. They are not listed in any roles. I've looked through all local windows groups on the supporting server and the group in question is not in any groups (ie, if they were in administrators, then they'd have full access through that). The people in the group are not administrators or domain administrators either. Is there somewhere else I could check on the machine to better find the source of the problem and get the group removed In general there are 2 places to check: One- role membership. And you ch ...Show All

• Neil East Ordering date in asc order ?

  SELECT LEFT(CONVERT(CHAR(11),convert(datetime,task_date),109),3) + ' ' + RIGHT(CONVERT(CHAR(11),convert(datetime,task_date),109),4) as Date, SUM(CASE a.status_id WHEN 1000 THEN b.act_point ELSE 0 END) as Programming, SUM(CASE a.status_id WHEN 1016 THEN b.act_point ELSE 0 END) as Design, SUM(CASE a.status_id WHEN 1752 THEN b.act_point ELSE 0 END) as Upload, SUM(CASE a.status_id WHEN 1032 THEN b.act_point ELSE 0 END) as Testing, SUM(CASE a.status_id WHEN 1128 THEN b.act_point ELSE 0 END) as Meeting, SUM(CASE a.status_id WHEN 1172 THEN b.act_point ELSE 0 END) as Others From task_table a,act_table b where a.status_id=b.act_id and a.user_id=(select user_id from user_table where user_name='Raghu') and a.task_date like '%/%/2006' GROUP BY L ...Show All

• pmeinl SQL Injection

  I want to inject a "where" criteria parametrically, but I can't get this to work: CREATE PROCEDURE dbo.CopyTestCases @Criteria varchar(255) AS declare @t table(NID int not null); set transaction isolation level serializable; begin tran; insert into TestIT (Product,CatID,Category,Title) output inserted.TestID into @t( NID) select Product,CatID,Category,Title from TestIT where @Criteria order by TestID; commit; GO I get the message " An expression of non-boolean type specified in a context where a condition is expected ". How do I fix this Like I stated earlier if you searched for exec sql in the forums you would come up with alot. The first result is where i grabbed ths syntax for this whic ...Show All

• b-man 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 Ah, ok, I was wondering if it had something to do with text encoding as well. Glad to hear it works! Sung Nevermind! I figured it out. I was doing an INSERT INTO SELECT FROM... and the column I was selecting from, TaxID, had to be converted to Unicode first. So it ended up looking like this: ...Show All

• Nilkanth DTS Wizard SQL 2005 - Enable Identity Insert

  I have a large number of Access tables that I need to periodically bring to SQL using the DTS Wizard in SQL 2000 (via Ent. Man). I am only interested in bring over the data from the MS Access tables as I had a separate script (application drive) that would create the SQL tables. The problem is this: with SQL 2000 when bringing over the tables, the check box for 'Enable Identity Insert' for each of the tables was checked , this worked fine. With SQL 2005, this checkbox is not checked hence, I have to click 'edit' for each of the table data being brought over and check the 'Enable Identity Insert' box manualy. My question is whether there is a way to have SQL 2005 have this 'Enable Identity Insert Box' checked by default as it did with SQL ...Show All

• mcmarquez SQL 2005 freezing unexpectedly & needing constant restarts

  Hi. I have an installation of SQL Server 2005 Enterprise edition installed in an environment with 20 users (developers + testers) working on it. The problem is that it seems to lock up every hour or so with no indication (or none which I can distinguish). Team Foundation Server is also using that instance of SQL. Can anyone point me to a site with troubleshooting tips or assist me with this issue It's very strange for a product which can handle *much* more than 20 users simultaneously. And secondly, I've given server admin permissions to a user connecting remotely through management studio, but she cannot restart the server, the "restart" options is grayed out. What could be causing this Thanks, Razvan ...Show All

• BrianMitchellTX Upper level members are not adding up correctly in SSAS - revised

  I have created a cube in SQL 2005 / SSAS but am having a problem with the upper level members. It seems that these members are not rolling up correctly. The cube contains daily data, if I look at the monthly values, these are not correct. That is, the sum of the daily values do not add up to the monthly values calculated in the cube. The monthly values should be a simple sum of the daily values. At first, I thought it may be a rounding issue but the differences between the values pulled from the cube and the manual sums are too large. In the FACT table, the measures have the data type of real. I have verified that the numbers in the FACT are indeed the #s loaded into the cube, i.e. if I pull data at the lowest level of all the dimension ...Show All