Answer Questions

• robin l How to disable windows authentication?

  How can I disable the windows authentication dialog box when opening the RS website http://server/Reports Thanks in advance Thanks for your interest in helping me out James. The virtual directory security setting in IIS is Integrated Windows authentication. I have many users going to this site, and they are complaining that they have to type their username and password all over again, which is true, it should get the username logged in the pc trying to open the site and compare that against the security matrix defined in Reporting Services for the different reports and folders. This is why the IE security options wouldn't be a permanent solution. Do you have any suggestions to accomplish ...Show All

• wls1973 How can i output XQuery's key words such like "<,>" when using XQuery in SQL Server 2005?

  in SQL Server 2005, I have a codes like this: declare @zz varchar(1000) declare @x xml set @x = ' <root> <billID>1122</billID> </root>' select @x.query(' for $bi in //billID/text() return ">" ') it runs, but it prints "&gt;" not ">", I know maybe "<,>" are keys words in XQuery, but how can i output them someone told me to use "\", but it doesn't work. I used Stylus Studio, it prints ">", very well http://www.stylusstudio.com/xml_download.html but why Microsoft can't Help please Do you want it to be in an XML document that can be reparsed then the serialization will most likely generate &gt; (as you ...Show All

• PismoPat OK button doesn't Work In Report Manager RS2005

  Hi, i have a new instalation of RS2000 under Windows 2003 Server SP1 with a fresh reaplied Windows Service Pack 1 and RS2000 Service Pack 2. My problem is that any page of the report manager with a "OK" button, that button doen't do nothing, it is enabled bu doesn't do any action. Can't figure this one out Need Help Thank's PS: Is did work early on this machine but stop working without notice, or any change at all. Hi, We have installed SQL Server 2005 with Reporting Service in a Windows 2003 Box. While working with the Reporting Manager through the browser we are gettting a strange problem. Whenever we are making any changes through Reporting Manager and trying to save the OK or Apply button is doing abso ...Show All

• rwbogosian Timeout and Audit Logout and sp_reset_connection?

  Hello, We've been getting some intermittent timeouts from our live website (the timeouts normally, but not always, occur when getting the user details - but that could be just because that task is happening the most often). However the strange thing is that this happens intermittently - but often enough to be annoying! I started a trace to see what was happening. I thought maybe it was a transaction/ or some sort of blocking SQL statement - however I'm not seeing anything that clearly indicates this.(I suppose the timeouts would only occur when another SQL was blocking the same db object, right And I don't think the updating of the user details are performed regularly.) However I did find some oddities that could maybe help: When we receiv ...Show All

• markovuksanovic Database Modification (Insert/Update/Delete) Event Notifications

  Hello, I am new to SQL Server and am building a C# application which will use a local SQL Server Express 2005installation. My application will be interacting with a DB Schema with approx 250 tables and the schema is already defined. My application is responsible for monitoring changes to the data in the DB. It must watch for all data changes in the database (Insert/Update/Delete). I am looking for a way to monitor changes to the DB data due to Insert/Update/Delete activity. Is there a simple way in SQL Server for my application to receive events whenever the table content is modified. I have come up with a few ideas myself, for example adding trigger to each table to update an additional Event table that I could look at or even r ...Show All

• spoimala # manipulate field value from select statement

  Hi all, any assistance will be much appreciated on this one .... a bit clueless at the mo! I've been trying to execute the code below in which part of my select statement is a calculated value i.e. Right([ED],2) & "/" & SUBSTRING([ED],5,2) & "/" & Left([ED],4) AS ENDDATE code: SELECT vw_contract_dates.[ContractNo], vw_contract_dates.[Title], vw_contract_dates.[CC], vw_contract_dates.[Sponsor], Right([SD],2) & "/" & SUBSTRING([SD],5,2) & "/" & Left([SD],4) AS STARTDATE, Right([ED],2) & "/" & SUBSTRING([ED],5,2) & "/" & Left([ED],4) AS ENDDATE, vw_contract_dates.[CEILING], [CEILING]-[SPEND] AS Remain, vw_contract_spend.[SPE ...Show All

• TokyoDev SP2 failed only on the Database engine and now won't restart

  I have a clean SQL 2005 Ent. x64 SP1 clean with no user db's.....applied SP2 and everything showed "Success" except the Database Services (Error 29534)...... Time: 02/22/2007 08:29:50.134 KB Number: KB921896 Machine: TORCA8 OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790) Package Language: 1033 (ENU) Package Platform: x64 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: Cluster Installation: No ********************************************************************************** Prerequisites Check & Status SQLSupport: Passed ********************************************************************************** Products Detected Language ...Show All

• Jassim Rahma How to get statistics on DML statements per table

  Can I get statistics on which type of DML statements (e.g. insert, delete, update) that are executed by users on a table without creating triggers I want to be able to show the number of executed statements per statement type. I have tried the 2005 Profiler but it outputs the entire batch statement which makes it a bit more difficult to create statistics. Rgds Bob There is no easy way to obtain this information. You could also take a look at 3rd party tools that can get this sort of information from the transaction logs. ...Show All

• Sobia Attach database - error 602

  Hello, After re-installation of MS SQL Server 2000 (Developer edition), I wanted to attch I previously available instances in the Enterprise Manager. But, when I select "Attach database", I get the error: Error 602: Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes. When I run this "DBCC CHECKTABLE", I get the message that no errors have been found. What should I do IS that database detached properly previsouly If not try to use RESTORE statement from the backup file and also ensure the service pack level from the previous installation should match with it. SQL Server is finding a problem with the db when trying ...Show All

• Serapth Invalid Locator de-referenced

  In our application we use three database(access, sql server and oracle) to store configurations. We use a program to copy the configuration from one database to another. We use ODBC and MFC recordsets to do the copy. We recently updated the application and changed the the table schema's. Before we had two tables which each had a schema of one long as key and one image field. Now we have one table with one long as key and three image fields. Now when we copy to sql server from access we get the error " Invalid locator de-refrenced" when we have large data (about 1 MB) in one image field. Before the change in schema's we did not have this problem with an image field with a large amout of data. We are using the sql server odbc drive ...Show All

• kgs1951 Graphing missing values

  I need to create a graph that graphs device usage by day. However lets assume that the device is not used on weekends and is used once on weekdays (simple example). If I create the graph how can I have the graph show 0 on Sat and Sun when no values exist Say I run the report for Wed to the next Wed, I would like to show 1 for each Weekday and 0 for Sat and Sun. But the data would look like this: Date | Employee 8/16/2006 03:30 | Emp1 8/17/2006 03:45 | Emp2 8/18/2006 03:25 | Emp1 8/21/2006 03:34 | Emp1 8/22/2006 03:51 | Emp3 8/23/2006 03:37 | Emp2 Notice the gap for the weekend, I know I can graph this on a line graph and it will say 1 on the weekends just connecting the line over the missing data but that is not what I nee ...Show All

• taclejj How to divide a row data to multiple row in one table by SSIS?

  Hi, Experts, I have a data table from a old system. There are 10 data fields stored in one row at this table. How can I seperate those fields into another table to be 10 rows Any component in Data Flow can I use (I have tried several component...) by the way, the original table is a large table, contain 3,000,000 rows. Thanks for your all assistance. Not quite understanding the problem but it seems as tho you could use 4 seperate Unpivots. Am I right If so, use a MULTICAST to split the data 4 ways so as to use 4 different Unpivots. Then, after the Unpivots, bring them all back together using UNION ALL. -Jamie Thanks for Jamie's answer!! But the Unpivot component only for one piv ...Show All

• Wildmind "Hang" when deploying SSAS solution?

  I've noticed that BI Studio seems to 'hang' when I do a Build -> Deploy Solution. The output window will just say "Sending deployment script to the server" and the Deployment Progress window will just churn, with no commands listed. It's been running for nearly ~ 1 hr without feedback - how can I tell if AS is working or not CPU on the AS instance is idle. The one workaround I've noticed is to open the database directly in BI Studio, and make the changes there, but this is obviously less than ideal for multiple reasons. The target server is just "localhost" (which is correct). When I put profiler on it, I can see the large XMLA deployment script, but it doesn't reveal anything ab ...Show All

• Abdel1 how to configure TCP port for unattended install

  I've looked through every source of material on SQL Server Express unattended installs that I could get my hands on, but so far, I've come up with nothing that shows how to set the server engine's TCP port to 1433 . Since the SQL Server setup is part of a (considerably) larger install, requiring the customer to set this by hand is not really acceptable. Is there a way to do this with a command-line parameter (etc) Thanks in advance Josh i assume you mean to set the port to not 1433 as this is the default behavior I am a newbe and do not know what "SMO" or "VMI" providers are. You eluded to a "Script" that can set the IP port for ...Show All

• Dan Rough ReportViewer Height

  Hello, I try to embed my Reports of Reporting Services to ASP .NET Application. I use ReportViewer component of Visual Studio 2005. When I try to set Height property to 100% there is no report content shown. I tried to set SizeToReportContent property but there wasn't success. At the same time when I set Height to any particular value e.g. 400px, everything is OK. But of cousre I can't know particular height for every reports. Did you have any such problems Can you help me Thank you, I figured out a really simple way to get rid of the scrollbars. Put the ReportViewer control in a div and set the div's style to "overflow: visible;". The ReportViewer inherits this style and no more scrollbars. I also cannot get ...Show All