SSRS Report login error
	Cross posted: microsoft.public.sqlserver.rep ortingsvcs, microsoft.public.sqlserver.ser ver SQL Server 2008 SP1 on Windows XP I've created a data source in MS VS that is using Windows auth and test connections says it is fine. When I use the IE based Report Manager to run it, the following is returned:... more » By Jay  - 26 Nov - 1 new of 1 message

	Detecting that a row has been updated.
	Dear reader, We want to implement a signaling field in a row which shows when the row was last changed (inserted, or updated). With the insertion it is possible to define a default, can something similar be done with updating? Triggers would be a possibillity, but I would prefer a default which get... more » By ben brugman  - 26 Nov - 4 new of 4 messages

there is already an object named #instmsdb

Hi Gurus, I am attempting to install KB970892 on SQL Express 2005SP3, and I am unable to do so, due to a SQL suspended installation. When I try to continue the installation (which I have no idea what is it trying to install - I have inherited this server this way), the following errors occur: "there is already an object named 'sysmail_update_profileaccount _sp' in the... more » By ishaybas  - 26 Nov - 1 new of 1 message

Traversing Leaf Levels to satisfy a query

Can an index seek be resolved at an intermediate leaf level, or do all levels of the B-Tree structure, down to the Leaf level, have to be traversed in order to satisfy a query? I ask this, because in using a combination of DBCC IND and DBCC PAGE, it appears that Index Keys are propigated to all levels of the index, and if one... more » By cbrichards via SQLMonster.com  - 25 Nov - 6 new of 6 messages

	How to Install Tools on Other Nodes in a Cluster
	I have a clustered SQL Server instance (Standard Edition) installed on a 2-node Windows 2003 x64 cluster. When it was originally set up, the tools (like SSMS) were only installed on the active node, which I understand is the normal way the installation works. Since then I have added SP2 and, later, SP3.... more » By Charles  - 25 Nov - 5 new of 5 messages

	SSMS
	HI, I recently install SQL server management Studio for 2008. When i tried to check the server property on the remote server from this SSMS, i get this error could not load file or assembly 'microsoft.sqlserver.sqm I can not check property of database also. thanks ujjwol By ujjwol  - 25 Nov - 2 new of 2 messages

	Transaction Log Performance
	Outside of the obvious like space, can a large transaction log affect db performance? If yes, how? Thanks in advance By RG  - 25 Nov - 6 new of 6 messages

	Limit number of CPUs?
	Is there a way to set the number of CPUs SQL Server will use (SQL 2005 Enterprise)? I know you can do it per query, but is there a way to set it across the board (e.g., in the registry or in the configuration manager)? Thanks. By Neil W  - 25 Nov - 3 new of 3 messages

	Why use ssis?
	Hi all, I'm new to SQL Server Business Intelligence Development Studio, And I find it hard to use and buggy. If I can do the same using Linq and save time and headache, Is there any reason to use ssis? Is there any advantage? Thenks, Sharon. By Sharon  - 25 Nov - 16 new of 16 messages

	SQL Agent won't start after sysprep
	Hi All, after sysprep of an SQL 2005 the SQL Server Agent won't start as any other account but Local System. I did change the server's name to mach the windows server name: check servername select @@servername,serverproperty('m achinename') if both values are different then you need to exec sp_dropserver 'oldservername'... more » By Zoran  - 25 Nov - 4 new of 4 messages