Answer Questions

• Logan1337 Take Id-s From returned rows, and make a new SELECT

  Hello, I have a question on sql stored procedures. I have such a procedure, which returnes me rows with ID-s. Then in my asp.net page I make from that Id-s a string like SELECT * FROM [eai.Documents] WHERE CategoryId=11 OR CategoryId=16 OR CategoryId=18. My question is: Can I do the same in my stored procedure (without sending it to page) Here is it: Thanks, I'll try. If there will be questions, with your permission, I will ask it ...Show All

• Mahesh Sawaiker Oracle and Analysis Services

  We have a world wide ERP built on top of Oracle and .net. We have no way to change Oracle for SQL Server at this time. But, we would like to use the Excel OLAP features. From what we've seen, the OLAP features in Excel only work on top of SQL Server's Analysis Services. Is this true Could we have Oracle and just Analysis Services installed What would be the cost of such a solution (could you point a price table) Thanks ...Show All

• Dave McCall How can I make a Matrix Transposition in SQL ?

  Can we do matrix transpose (rows become columns and columns become rows) in standard SQL 1 2 3 4 5 6 7 8 9 changes to 1 4 7 2 5 8 3 6 9 how about the situation when no of rows <> no of column let's consider the no of rows it's fixed and known before running the SQL statement. thanks. Here is a Standard SQL Version ;) --Use sample data provided by Louis SELECT id, MIN(CASE WHEN P.pkey = 'a' THE ...Show All

• roothekoo SQL 2005 & Windows Password Policy

  We run a few shared hosting servers in the UK, now we used to run mssql 2000 and moved to 2005 in december 2005. Microsoft SQL 2005                                      9.00.1399.06 Microsoft SQL Server Man agement Studio      9. ...Show All

• sparra06 Error in the PROCEDURE....

  Hi,   i m trying to run a procedure...but everytime i run it...it gives me some error as: ------------------------------------------------------------------------- Msg 468, Level 16, State 9, Procedure FIN_INFO__Get_Cash_Payments_Info, Line 46 Cannot resolve the collation conflict between "Cyrillic_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. ------------------------------------------------------------------- ...Show All

• GDA cmdexec subsystem failure

  have a scheduled job that has been running fine for 2 years, but this week I keep getting the following error: 0x469A75B7998F8142A910FA7E9983CCDF has caused an exception in the CmdExec subsystem and has been terminated. the enterprise manager shows that the job failed, but the app still shows up in task manager. the .cmd file has a single step in it that calls the .exe file and does an "if errorlevel = 1" option that displays an erro ...Show All

• Gerry Fan Failed install of SQL Server 2005 Developer Edition on Win XP Pro

  I've tried installing SQL Server 2005 Developer Edition 3 times now, from 2 different CDs. I keep failing with the same error message: "SQL Server Setup Failed to compile the Managed Object Format (MOF) file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\etwcls.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup He ...Show All

• sog SQL Server 2005 incorrectly claims I don't meet minimum service pack level requirements?

  This doesn't make any sense. I am trying to install SQL Server 2005 on SBS 2003 with Service Pack 1. According to Windows Update, there is nothing left for me to install. However, I am getting this error (while installing SQL Server Express and the Developer Edition): "Your operating system does not meet Service Pack level requirements for this SQL Server release. Install the Service Pack from the Microsoft Download Center at http://go.m ...Show All

• woh Unpublishing an article

  Hi: If I want to unpublish an article thru Enterprise Manager, it does not allow me to uncheck it at publication properties. It only allows me to uncheck articles if I delete the subscription first. Does anybody know how tp do this in Enterprise Manager without deleting the subscription Thanks SQL Server 2000 does not support unpublishng an article with active subscriptions. This has been relaxed in SQL Server 2005 and works ...Show All

• Reshu ASPNET account permissions

  I am new to Reporting Services and still learning, but it is a very nice exciting program. I built a new Report and was experimenting with Grouping in reports and using the parameters. Now I would like to Deploy the report to the Report Server so I can use this report on our intranet, however I get the error that the ASPNET account does not have the proper permissions. I am sure that I need to set up ASPNET to have "write" abilities. ...Show All

• Tom S62093 Excel connection properities -

  In my package I need to change the filename name for my input Excel based on a the contents of an external file.  I want to read the external file, get the filename/location from this file and then dynamically set this as the property for the Excel Connection.  I saw some posts related to this but did not understand which tasks I need to use and in which order.   thanks My connection string is Provider=Microsoft.J ...Show All

• cica AS actions available through RS in SQL 2005.

  Hi, I'm looking for any documentation explaining how RS can use AS actions. Can someone please help me Is it feasible Thanks in advance. Thanks. Reporting Services does not expose AS actions. This is on the list of features we may add in a future version. -Albert Note: you can still setup AS actions in the cube that trigger t ...Show All

• Stevejh No witness, primary shutsdown, bring failover online

  First of all, Great webcast today. My question is, I have everything up and running and would like to know what to do when the machine my primary is on quits or has a some type of disaster. Do I need to manually run recovery on each db that was mirrored I'm not currently running a witness. thanks ok, so you're running high protection mode. I will have to correct myself here first, running in either high ...Show All

• rayfusion I don't understand why is nothing is always evaluated to false

  The following in one textbox of my report is always evaluated to false when the field package_pack_value and give an error in the str conversion function that follow saying the 'number' is nothing. = iif ( Fields!Package_Pack_Value is Nothing , "<Null>", Str ( Fields!Package_Pack_Value.Value ) & " " & Fields!Package_Pack_Unit.Value )   I have read all the forum and search a whole day but nothing... Maybe is the a ...Show All

• FranklinIssac Cannot insert the value NULL into column 'NotificationBatchId'

  Using Yukon Apr 05 CTP Have defined the custom fields for the subscription (like the Stock Name and Stock Price) Error while the SubscriptionsEventRule gets executed the NSFireDeveloperDefined1 stored proc (that contains the SubscriptionsEventRule t-sql) throws up this error "Cannot insert the value NULL into column 'NotificationBatchId' " This columns belongs to the NSTestNotifications table. Should this column be a bigint "ident ...Show All