Answer Questions

• DtD SQL Server 2005 Service Pack 1 is now available

  Microsoft announces the availability of SQL Server 2005 Service Pack 1 (SP1) with Database Mirroring, SQL Server Management Studio Express, additional options for ISVs, and normal feature fixes. SQL Server 2005 Service Pack 1 can be found here: http://www.microsoft.com/sql/sp1.mspx And Now I have also Solved it my self. What I have done is that When this window Authentication Mode appears i starts the sql server 2005 service.Then clcik the next button.That's all we have to do. I have now sql server 2005 SP1 installed on my system. Also we should also stop sql server browser service if it is runing . I Hope This Also helps Others. I have downloaded SP1, but I do not see SQL Server Management Studio. ...Show All

• CaptainSmudge Number of nonempty cells in a collumn

  Hello! How can I find "Totals" of rows with filled data E.g.: Date1 Date2 Date3 Date5 Date6 Date7 date8 1-Jul-06 2-Jul-06 5-Jul-06 10-Jul-06 11-Jul-06 2-Jul-06 3-Jul-06 6-Jul-06 11-Jul-06 3-Jul-06 4-Jul-06 7-Jul-06 12-Jul-06 4-Jul-06 5-Jul-06 8-Jul-06 5-Jul-06 6-Jul-06 9-Jul-06 6-Jul-06 7-Jul-06 7-Jul-06 8-Jul-06 9-Jul-06 10-Jul-06 Totals: 10 6 5 3 1 ...Show All

• yanivpinhas Multiple join between two tables

  Hi, I have two tables, let's say "Main" and "Dictionary". The Main table has several fields that point to records in the same dictionary table. Because of the multiple joins I couldn't get any results if I use an expression like: SELECT Main.ID, Dictionary.Text AS Data1, Dictionary.Text AS Data2 FROM Main, Dictionary WHERE Main.Data1 = Dictionary.ID AND Main.Data2 = Dictionary.ID What kind of join expression should I use I have to generate this expression programmatically, so it's quite important to keep it as simple as possible! Thx! Ors That's exactly what I needed! Thx! Ors Pls could someone help ...Show All

• Jimmys3000gt Expression-based Data Source + subscription = No-go?

  Set up reports to use expression-based data sources and everything works fine as far as executing and viewing the reports. The ConnectionString expression includes the credentials, and the "No credentials required" option is selected. Unfortunately, am getting this when trying to create a subscription for same report. WTF eportingServicesService!processing!3!12/20/2006-12:20:07:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'XXXData'., ; Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot create a connection to data source 'XXXData'. ---> System.InvalidOperationException: The ConnectionString property h ...Show All

• Albion Simon How to Deploy .mdf Files

  Hi Guys, I have a problam. I wanna deploy my application that it has data.mdf file. When I install and test it I get this message: --------------------------- Microsoft SQL Server Login --------------------------- Connection failed: SQLState: '42000' SQL Server Error: 5133 [Microsoft][SQL Native Client][SQL Server]Directory lookup for the file "C:\Program Files\MyDic\Database\Data.mdf" failed with the operating system error 5(Access is denied.). Connection failed: SQLState: '42000' SQL Server Error: 1832 [Microsoft][SQL Native Client][SQL Server]Could not attach file 'C:\Program Files\MyDic\Database\Data.mdf' as database 'MyDic'. --------------------------- OK   --------------------------- I have to mention that: ...Show All

• mae ann Reg URl

  I have a table which is displaying reports. One of the colums in the table is a hyperlink. Onclicking Hyperlink it should take me to http://itreports.teamfreeze.com/errors/detail.aspx id = Files!ErrorID.Value I wrote a small function that takes the ErrorID as the parameter and returns http://itreports.teamfreeze.com/errors/detail.aspx id = Files!ErrorID.Value. I called this Function in the JumtoUrl in the Navigation Tab. But it does nt work. Can anyone help me. ...Show All

• kblackwell Paged Result Sets

  What is the recommended mechanism for selecting paged results from SQL. Presently I pass various params including the request Max Items Per Page and the requested page. The I execute the query as a count with the search params. Then comes the paging logic, which validates the page number against the request page and number of hits etc. Then a temp table and record variables are created for the results. Then I run the query again with a cursor and select the appropriate Items into the temp table based on the paging values (First Item and Last Item). Then I return the temp table & some additional return params with the Total Hits etc. The Stored procedure is accessed via an ADO.Net client and the system.data.IDBReade ...Show All

• jwaddell Sql Server 2005 and Sql Server 2005 Express Edition

  I have Sql Server 2005 and Reporting Services 2005 installed in my machine. Can I install besides this products Sql Server 2005 Express and Reporting Services 2005 Express. Can they be both in the same machine Will I get any problem doing this Thanks, Marco Thank you for your answer Samuel, Marco. Yes, both the Engine, Reporting Services, and Analysis Services are instance aware components, thus you can install them more than once on the same machine without any problems, as long as you give them a distinct instance name. Integration Services, Notification Services, and client components (tools) are the opposite. They can only have one copy per machine. Th ...Show All

• Álvaro Peñarrubia Management Studio Express - error when attempting to run a query

  Hi, I have installed Visual Studio 2005 on my PC, and SQL Server 2005 Express was also installed. I decided to install the Management Studio Express, and the installation completed without any error messages. I created the ASPNET account after having installed the Northwind database on my PC, and I have created a test web site (ASP.NET) that creates a SqlConnection, and retrieves some data from the Products table in the Northwind database. The query returns the results i ask for, so that means that the accound has been set up properly. My problem appears when I try to run queries using the Management Studio Express. I have managed to add the sql server, and I can browse this in the object explorer, getting a listing of all the tab ...Show All

• Alex_UTL Case statement

  Hi I am having a few problem with a case statement. I have a table with customer data in and I need to bring back all the rows which have data missing from 2 different columns. customer table CustomerID Name SoftwareVersion 1001 TEST1 V5 1002 TEST2 V5 3 TEST3 V5 004 TEST4 V6 ect.. CustomerID Table ID 1001 1002 1003 1004 ect... I have a need customerid table and I need to list all the customers who are not in this table or whos id does not match the new listings, alos there is a softwareVersion Table list all the newest software so the same will need to be done for this. Thanks Rich yes SnMSDN he didnt make much clear wha ...Show All

• fruce SQL SERVER SETTINGS

  When SQL Server and Web site are both on same machine, it runs fine, can get data and display in web page. but when trying to get data from remote SQL Server, it gives error. What's the setting for SQL server configure and security settings in different versions MS SQL 2000 | MS SQL 2005 ============================================== Framework 1.x | Framework 2.0 | Thanks alot. Please provide some setting help for the OK, perhaps you are using another port than the default one 1433 and you disabled SQL Browser. This service acts like a redirector service. Any request comming in ...Show All

• Eby *Complex* Grouping in View - help needed

  Hello, I am having difficulty to find the right SQL query to create a View as i illustrate below. Senario: Criteria Table Idn Key1 Key2 Key3 TagId 1 A C B 100 2 A NULL B 200 3 B D NULL 300 Data Table DataId Key1 1 A 2 B SubData Table SubDataId DataId Key2 Key3 1 1 C B 2 1 Z B 3 1 X B 4 2 D Z And below is my expected Vi ...Show All

• kangalert Error on using VB in calculated members AFTER stepping up to Enterprise version ??

  I have "succesfully upgraded" ( ) our SQL2005 from standard to Enterprise version. Before, following set worked like a charm: CREATE SET CURRENTCUBE.[Now CY] AS strtomember("[00 - Time].[00 - H - Calendar].[Day Name].&[" + format(now(),"yyyyMMdd") + "]"); But when I process the cube now, I get this error: Error 1 MdxScript(Sales) (58, 74) The '[now]' function does not exist. 0 0 It seems like the reference to Visual Basic has been lost somehow Curiously following calculated member works, even it also uses now() CREATE MEMBER CURRENTCUBE.[MEASURES].[Now] AS now(), FORMAT_STRING = "yyyyMMdd", VISIBLE = 1; Any suggestions please ;-) / geert larsen denmark ...Show All

• Stéphane Beauchemin Stored Procedures and how to call them from C#

  Hello Everyone, I have created a stored procedure something like this : CREATE PROCEDURE [dbo].[Get_Lots] AS BEGIN SELECT _id, description FROM LOT RETURN 0 END GO I want to know what would be the return parameter in above procedure. Secondly, If I need to get the value in DataSet using C# how can I do that....If someone can provide with an example..... Thanks, Harsimrat Use the data application block from the enterprise library as your data access layer. Download it and you'll find lots of examples. http://www.microsoft.com/downloads/details.aspx FamilyId=5A14E870-406B-4F2A-B723-97BA84AE80B5&displaylang=en ...Show All

• Gravy Easier way to convert Non-Unicode to Unicode

  I have built a large package and due to database changes (varchar to nvarchar) I need to do a data conversion of all the flat file columns I am bringing in, to a unicode data type. The way I know how to do this is via the data conversion component/task. My question is, I am looking for an easy way to "Do All Columns" and "Map all Columns" without doing every column by hand in both spots. I need to change all the columns, can I do this in mass More importantly once I convert all these and connect it to my data source it fails to map converted fields by name. Is there a way when using the data conversion task to still get it to map by name when connecting it to the OLE destination I know I can use the wizard to cre ...Show All