Answer Questions

• arunvenkata complex SQL (for me) step 2

  hello, Lets look this Proc : set nocount on create table Histo ( Id varchar ( 10 ) primary key , Week varchar ( 10 ), Project varchar ( 10 ) ) insert into Histo ( Id , Week , Project ) select '47' , '2006-12' , 'Internet' union all select '48' , '2006-13' , 'Internet' union all select '49' , '2006-12' , 'Intranet' go select * from Histo go SELECT Project , [2006-12] , [2006-13] FROM ...Show All

• Michael Creamer Death of ODBC

  ODBC is not supported as a data source in SQL Analysis Services 2005. ODBC is not supported as a data source in SQL Reporting Services 2005 Model Designer. Any thoughts Joe Lukasz, Thanks for your reply.  I can see from your explanation that it's not easy to support ODBC in the Model Designer.             - Are there any plans to support ODBC in the f ...Show All

• Vignesh Kannappan - MSFT SOAP Lite client error problem with CGI code - Help

  Hi, I have been working on a soap client project for over a week now and can not figure out what I am doing wrong. I am not an expert using Perl or SOAP so any help would be "greatly" appreciated. I get basic errors throughout, starting with: Error - SOAP::Transport::HTTP::Client::send_receive: POST It seems as if the user access information is not carried through as it should, but I truly have no idea what the problem is. Her ...Show All

• GaryInJapan Is it possible to use a Like operator in conditional split

  Hi I would like to know if we can use a LIKE operator in the conditional split. I have a Flat file as a source and I want to filter out some of the URIs while loading into the  table. Is there a way to do that using Conditional split. If no, please suggest some other way to do this I cannot use a == to filter out the URIs. Your help is very much appreciated Regards Meghana There is no LIKE operator, but y ...Show All

• codemanwa Semi-additive measures in AS2005 Standard Edition

  I am not able to find any work-around for semi-additive measures (specifically Avg) in Analysis services 2005 Standard edition. (Aggregation type 'Avg' is not supported in Standard edition, however 'Count' works!) Any suggestions would be appreciated. Regards, Mahesh There was a great deal of internal work done deep inside the runtime engine to support semi-additive measures. If all it involved was wr ...Show All

• cpvgd Microsoft Visual Studio is busy

  I get this message in a balloon that pops up frequently when I am trying to work in the SSIS designer. For example, I get it when working in a DataFlow task, trying to open editors for the OleDb Source and Destination. Is anyone else getting this What could be the cause, it seems to get sluggish. Thanks. Have you recently installed any other software that interfaces with Visual Studio ReSharper, for instance ...Show All

• SHISHIR WAHI Connection pooling not working in Clustered Env.

  Hi, We had deployed a .NET application in a non clustered environment with conection pooling and was working fine. Now we had moved to a clustered env and connection pooling stopped working. Is there any cluster aware setting that we need to look at. Please let me know your thoughts. Thanks in advance Can you be more specific on what went wrong Any error code, exception stack will be helpful. ...Show All

• FKy VS2005 and SQL Reporting Service

  Dear All, I am using the VS.NET 2005 professional edition but it doesn't have reporting service project at all. I am planning to use the SQL Server Express 2005. I want to use the reporting service 2005 and report server as well. Could anyone please let me know how can I get a copy of Reporting Service embeded into VS.NET 2005 and Reporting Server for deployment even evaluation copy or from anywhere in SQL server 2005 installation disk Rea ...Show All

• mvermef Deserialize ACL problem

  I'm developing a custom security extension to Reporting services. In my authorization class I have a problem to deserialize the ACL (secDesc parameter). I have many examples and I’m doing the same excepted for one thing I’m not in form authentication but I’m in windows authentication. The problem is in the method 'DeserializeAcl(byte[] ...)'. I encounter this kind of bug : BinaryFormatter versions incompatibility : Excpected version 1.0, rec ...Show All

• Naga Satish Rupenaguntla CREATE ASSEMBLY failed because method 'get_Count'...

  Hi All, I am trying to create and assembly which saves the results of a XML query. The dll, when called from a exe, works and saves the results to file as expected. However, when trying to create the assembly I get the error: " Msg 6215, Level 16, State 1, Line 2 CREATE ASSEMBLY failed because method 'get_Count' on type 'ADODB._Collection' in external_access assembly 'Interop.ADODB' has invalid attribute 0x1003." ...Show All

• JimJBq securing Local System, password expiration, occasionally connected MSDE

  Numerous articles (e.g., http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.asp , even one that I wrote, http://www.dbazine.com/sql/sql-articles/cook12 ) state that to secure SQL Server, the SQL Server services should not run as Local System. That advice is useful only if making the change is not overly disruptive or is even allowable. My two most recent clients have absolutely rigid password expiration pol ...Show All

• marek_adamczuk Retrieving multiple Result Sets from within a stored procedure

  A coworker of mine came to me with a question about a stored procedure he's working on. In this case, he has a stored procedure which invokes a second stored procedure. He wants that second stored procedure to return two result sets and then make use of both of them in the original stored procedure. I know how to make a stored procedure return multiple result sets (just do two select statements), but how would you utilize those from the original ...Show All

• Stephen Englefield-Grantham How can I retrieve Stored Procedure Parameters using smo

  Hi I am writing a little app that generate some code . I need to write a function to retrieve all sp parameters.and whether the param is output etc.. How can I do it THanks I will try again . Look at this link he mentiones something about it http://sqljunkies.com/WebLog/euang/archive/2004/04/01/1889.aspx Thanks again for  your time Thanks for your reply I have writte ...Show All

• GJGrosso Report Manager - Blank Reports Page

  Hi, I'm getting blank page when I open the Report Manager: I've got a header - "...Reporting... HOME", and then just empty space. I had it working fine a week ago. Any ideas The RS runs on Win2003 Std, SQL 2005 Std. Thanks I'm connecting as administrator. Speaking about permission... Which permissions are you talking about Thanks ...Show All

• Sven Beneke Job Fails

  I have a package that runs fine when manually executed, but if a job is created that executes the package the job fails. The job is run as the same account that runs sql server agent. The error message that appears is to see the job history but the job history just says the package failed. When I try to add logging no log is created. This is really not important but after reading your post, I created 1 desktop ...Show All