Answer Questions

• vmishka Problem with simple subquery in SQL2005 AND SQL2000.

  When I use the simple query with a subquery shown below, this is the error message I get in SQL 2000 AND SQL 2005 "Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression." And here is the query I use: SELECT docSections . SectionID , ( SELECT docSectionText . colText FROM docSectionText WHERE ( docSections ...Show All

• Ben Hur cannot login

  Well, I've tried every suggestion by helpful people in connecting to a database I created, to no avail. I created a db, called, nodes10.mdf. Test connection works. Right now I get: Cannot open database "nodes10" requested by the login. The login failed. Login failed for user '<server>\<user>'. Before you call me on my syntax, the problem is with logging in , not my insertString. code: SqlConnection conn = new SqlConnectio ...Show All

• Karthik Raman export to PDF showing solid black images

  I have a report with multiple tables.  The last column in each of the table is hidden based on a formula.  Using Visual Studio, I export to .pdf, no problem, all looks good.  When I do this via the Report Manager web interface it looks fine until I export it to .pdf, then...anytime that column is hidden, an additional column seems to appear that is solid back.  This 'additional' solid black column actually appears to the r ...Show All

• Brian Fitzgerald Management Studio and dbo requirements

  Why is it that Management studio continues to raise an error to a user that does not have db_owner permissions, but is a member of the db_ddladmin role. I have tried to remove the amount of people who have db_owner in my development environments and in place grant db_ddladmin and db_securityadmin. The problem is that management stuio ( in 2005 ) and enterprise manager ( in 2000) raise an error when the user isn't in the db_owner role and is ...Show All

• WmS Cannot connect to SQL Server 2005 login in ASP.NET connection String

  I have spent a day trying to figure this out.  I am using ASP.NET, VS 2005 Professional (on my local machine), and SQL Server 2005 on a remote server.  When I try debugging my application, it runs fine until I click the button and then it can't authenticate using my SQL Connection String in my Web.config file.  I am about to lose it. The error I get is: Cannot open database "integration_services_en" requested by the login. ...Show All

• Harold Solomon Is there a style sheet or theme sheet available for reports

  I'm currently building several reports which need an identical look/feel to them. I know that I could create a template which would incorporate any of its properties into any new report that uses it. However, it doesn't look like those properties are inherited by the child report. I need to be able to modify the look/feel of all my reports and I'd rather not have to make updates to each individual report. Is there a way to either set up the temp ...Show All

• Renzska Multiple tasks in the same assembly

  Hello, All the SSIS tasks (and components come to mention it) exist in their own assembly file. Is there anything that stops us from putting multiple tasks into one assembly Assuming you can do that, is there a reason why this perhaps should not be done Thanks Jamie Actually, the percent sampling and row sampling transforms are in the same DLL.  There is nothing to stop you from having multiple tasks or multiple components in the s ...Show All

• du4 problem in using xp_cmdshell to run dts package

     When I run "dtexec /f E:\Temp\SSIS1\SSIS1\Package.dtsx" in command window,it is no any problem. But if I run it with exec master..xp_cmdshell 'dtexec /f E:\Temp\SSIS1\SSIS1\Package.dtsx' in SQL2005 management studio,it show error as below.    The SQL server run as Administrator now,but it run with LocalSystem before.    Any suggestion Microsoft (R) SQL Server Execute Package Utility Version 9.00. ...Show All

• JRHudnutt Group Header Alternating color

  I am trying to get alternating colors on group headers. The rownumber() doesn't work; that only seems to be the count of rows in the group. Does anyone have any great ideas for this Thanks! BobP Wow, thanks so much, Simone! I've been banging my head against the wall on this one for the last hour, trying to think up ways to do it in SQL, using the Previous() function, etc. This worked like a charm! ...Show All

• Mike Nason SP1 Installer Can't Connect

  The installer for SP1 can't seem to connect to my unnamed instance of SQL Server 2005 Developer, even though: I'm using Windows Authentication (don't ask...) I can connect with no problem using SSMS using those exact same credentials Anyone know how to get this to work I've downloaded the installer from our MSDN Subscription, so I can't imagine what the issue could be (and I'm just a dev, not a DBA). Thanks, Rob ...Show All

• Roger Luo Validate Subscriptions, turn it off

  I added Validate Subscriptions to my publication using the procedure outlined in BOL. Procedure is listed below. I want to stop the validation for this publication. I do not want to validate any longer. How can I stop this process To validate transactional data using SQL Server Enterprise Manager At the Distributor, expand Replication Monitor , expand Publishers , and then expand a specific Publisher. Right-click a transactional pu ...Show All

• Stephane GOUDEAU SQL 2000 stops to increment @cpu_busy value, sp_monitor does not work anymore

  1) After a couple of months of work SQL 2000 server stops to increment @@cpu_busy. If you query it you’ll get a constant value as well as error: select @@CPU_BUSY Arithmetic overflow occurred. 134217727 2) If you execute sp_monitor you'll get nothing but errors: Arithmetic overflow occurred. Arithmetic overflow occurred. Arithmetic overflow occurred. This happens only on multiprocessor machines. SQL Service pack 3. ...Show All

• Saruk SSIS Requests...

  May be it's too late, but I think this requests could be scheduled at least for a SP1 if it's not possible for the RTM. 1) Execute Task without debugger: it would be very nice to be able to execute a single task without going in debugging mode. Just as you would ask "Start Without Debugging CTRL+F5" but for a single task 2) Customize default properties for task and component: when you drag a task on the package you get a default value for the ...Show All

• mutantbc Previous Row Calculations (sql server 2000)

   if anyone know a way that you can look up a value from the previous row in a View to do a calculation on (in sql server 2000) for example: expr1=PreviousRow.Expr1/30 + expr2 - expr3 =100 so the next row is expr1=100/30 + expr2 - expr3 =300 so the third row is expr1=300/30 + expr2 - expr3 =100 or tell me if it not possible please and special thanks to Umachandar Jayachandran - MS for help. Hi, H ...Show All

• Leandro Pardo Lost ability to Debug CLR Stored Procs after SQL 2005 upgrade to SP1

  OS: Windows XP Pro, SP2 SQL: SQL Server 2005 (Server 9.0.2047) SP1 VS: Visual Studio 2005 RTM.050727-4200 -------- After upgrading our SQL Servers to SP1 we have lost the ability to debug .net CLR stored procedures. The debugging process worked fine until we installed the Service Pack. All other features we use test out fine after the upgrade. The only and very important feature that does not work is debugging CLR procs. In fact this problem ...Show All