Answer Questions

• JohnnyWing Reporting Services error

  Hi, I am trying to implement a report using reprorting services and have just finished deploying it.  I am using the June SQL 2005 CTP. Books online then says to select Debug and Start after setting the TargetServerUrl.  However, I get the error message below.  Any help would be appreciated. Regards, Ned TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://loc ...Show All

• John Saunders Updating a record from table with data from a column of another record from the same table

  Hey guys, I have a table say as follows id, id2, field1, field2, date1, date2 I want to update the date1 field to the date2 field of the very next record with the same id2. In short I want to update a record id(x) by putting in the date2 field if id(y) in the date1 of id(x) where id2(x) = id2(y) and id(y) > id(x) (as id is a sequence). I have written a query as below: update t_remarks te set out_date = (select TOP 1 date_remark_entered fro ...Show All

• SMILEMan order by in a view in sqlserver2005

  Hi, I've a problem with a created view in sqlserver2000 that I'm now using in sqlserver2005. This is the view : CREATE VIEW hsarti01_VD1 AS SELECT TOP 100 PERCENT * FROM hsarti01 WITH(index(hsarti01_PK)) ORDER BY 1,2 desc,3,4 When I do the "select * from hsarti01_VD1" in sql server 2000, I see in the result that the order by is been using. but in sql server 2005 it's just using the order of the primary key and not the orde ...Show All

• Niko Pamboukas Welcome to the Notification Services Discussion Forum!

  I'd like to welcome you to the SQL Server 2005 Notification Services discussion forum.  This is a place where you can ask questions about scenarios, deployments, technical questions, or just simply troubleshooting questions. Notification Services is a part of SQL Server 2005 that enables event processing and notification distribution at Internet scale.   I hope it becomes a vital part of your organization's information distributi ...Show All

• Manmeet SQL Express Advanced commandline install

  I'm trying to install SQL Express Advanced Services from the commandline, but cannot get Management tools to install. Does anyone know the correct commandline to get this to work thanks, Daren I was trying to add SQL_Tools90 to the ADDLOCAL entry because that is the entry for SQL Std Edition. thanks, Daren Moving to the setup group for more chance of an answer Ah, ok, that's the problem. The tag for Ma ...Show All

• jpdev4 Question about dimensions and measures creation in Microsoft SQL Server 2005

  Hi, all here, I am new to OALP, I have question about dimensions and measures. Are dimensions and measures created before the creation of cubes Or they are created at the same time cubes are created Thanks a lot in advance for any guidance and help. Hi, aatik, thanks a lot. Hi Helen, You have to design you cubes first. You have to find out all the cube reports you'll need. After that you'll know which dimensions and measur ...Show All

• GazMan Custom Sql Exceptions through the CLR

  Friends, First off, congrats and thank you to everyone at Microsoft for all of the hard work they have put into Sql Server 2005 and .NET 2.0 - it is simply amazing technology. On that note, I was wondering if it was possible to create my own custom exceptions that I can throw in my stored procedures and then catch in my application code For example, say I wanted to create a Custom Sql Exception called "DuplicateEmailInSqlDatabaseTable ...Show All

• Dubloth Upsizing from MSAccess to SQLServer

  I am trying to use SQLServer for the first time and I am trying to use the upsizing wizard on Access to get moved over to SQLServer. I am getting the following error messages: Connection failed: SQLState: '01000' SQL Server Error: 2 [Microsoft][ODBC SQL Server][Shared Memory]ConnectionOpen (Connect()). Connection failed: SQLState: '08001' SQLServer E ...Show All

• tstubb SQL Express & Reporting Services

  Hi, I believe SQL Express is going to get Reporting Services in a point release. Anyone know when that might be I urgently need the functionality and the db is currently not big enough to warrent shelling out for the full SQL server package. Thanks Look Reporting Services in SQL Express with Advanced Services in SP1 of SQL 2005. Is this service pack available now. If so what is the ...Show All

• Franky Piferoen Deserialization failed: version 2.0 is not a compatible version

  I saw this question before with no answer. I'm trying to develop reports in SQL RS 2000 and Visual Studio 2003. My machine has both SQL 2000 & SQL 2005, SQL RS 2000 & SQL RS 2005, VS 2003 & VS 2005 installed. When I try and open an RS 2000 report in VS 2003, I get the following error: Microsoft Development Environment is unable to load this document: Deserialization failed: Version 2.0 is not a compatible version. The ...Show All

• santosh k singh Excel Destination Error: Column"xx" cannot convert between unicode and non-unicode string data types

  Good afternoon Trying out the Excel Destination in SSIS, I ran into the above error. I did try to ignore my 2 varchar fields and then it works fine. Thanks for any inputs. I'm jumping into this thread rather late, but I've had an experience with this problem that might be helpful to others. I've been trying to dump SQL query results into an EXCEL spreadsheet using SSIS, and that's when I first got this error me ...Show All

• KarthikG problem installing sql server express

  help i'm having serious problems installing sql server express and quite at a loss. i'm stuck at SQL Server Database Services and at Setting File Security. Can someone help Seeing the SQL Server Database Services log i get this: Action start 22:25:56: Write_sqlUserSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=Write_sqlUserSecurity <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return ...Show All

• Juozas Kimtys Default Schema and Synonyms

  database0.User1 has a default schema of database0.Schema1 and also belongs to database1. I have the following synonyms in database0: Schema1.Customers - points to database1.dbo.customers dbo.Customers - point to database2.dbo.customers User1 has execute rights in database0. I have a stored procedure in database0 that says select * from Customers I thought since User1's default schema was Schema1, it would automatically see ...Show All

• WebFinn Example code for consuming a SSIS datareader from ASP.net

  Hi, Does anyone have any or know of any demo code that shows how to consume data made available by a SSIS DataReader destination in an ASP.net app. Thanks in advance. -Jamie P.S. Doug if you're reading this, it'd be handy to have some examples such as this in BOL or maybe even something provided with the samples. Re: How do I consume a DataReader Destination in VB.Net - Microsoft Technical Forums ( http://forums.microsoft.com/msdn/Sho ...Show All

• Michael Duk Implicit Keep Together For Export?

  I have a report that has 3 nested lists.  The report looks fine when I view it in the browser but when I print it or export it to another format it appears that keep together is on for each list because some pages are only partially filled.  I do not have keep together turned on for any report control, and I don't have page break turned on for anything.  This problem results in the report being many more pages than it needs to be. ...Show All