Answer Questions

• amol_16 Unhandled Exception in Management Studio

  At work we run a large SQL Server 2000 database that is usually administered using Enterprise Manager. I recently started playing around with SQL Server 2005 Management Studio and have been encountering an interesting problem. Whenever I browse tables/views in the Summary window, and then select a table/view (by hitting enter or double clicking) Management Studio encounteres an unhandled exception (below). Oddly, this behaviour only occurs when ...Show All

• ProgrammingHunter setting variable value

  hi ! I am trying to set the variables value through Execute SQL task and create directory through the FileSystemTask by setting the user variable as source. The User variable has the Directory path to create the directory, but when i set the source as the user variable it complains that its value is empty. Execute SQL TAsk happens to work correctly when i check the watch window the user variable is set correctly . but value is not setting ...Show All

• Anonymous Date MSOLAP 2000 SP4 and Pertlib errors

  Hi all, I just installed MSOLAP 2000 SP4, and now every 4 seconds or so I'm seeing 2 new messages in the Application log. This first one is from MSSQLServerOLAPService: The description for Event ID ( 2003 ) in Source ( MSSQLServerOLAPService ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event ...Show All

• Phil Mac WebParts not found for Reporting Services

  I created my first Webpart .aspx page in SharePoint 2003. I created a new Document Library and assigned my webpart page to that library. Now when I go to Document Libraries, click on that webpart, I get the page but I no longer see the buckets for the layout..nor do I see the Explorer to allow me to try to add webparts. How do I get to this screen again that allows you to drag and drop items into my page It's just a blank page with a header righ ...Show All

• DonRajah unable to connect to SQL Everywhere in VS2005 designer

  I've just downloaded SQL Everywhere CTP, installed the mobile framework 2.0, and attempted to build a the sample on Steve Lasker's blog http://blogs.msdn.com/stevelasker/archive/2006/06/12/SqlEvCTP.aspx . However, when I attempt to create a new connection to the Northwind.sdf file in VS 2005 designer, I don't get SQL everywhere (or mobile) in the list of available datasources. If I choose "other" and ">NET Framework data ...Show All

• akramm Transmission Queue problem

  " noWrap width="1%" bgColor=#b71c0c> 1. Yosi   29 Temmuz 12:19     secenekleri goster Gonderen: "Yosi" <yus ... @bizitek.com> - Bu yazar n yazd mesajlar bul Tarih: Fri, 29 Jul 2005 02:19:00 -0700 Konu: Service Broker Cevapla | Yazara Cevap Ver | let | Yazd r | Sadece Mesaj | Asl n goster | Kald r | Kotuye Kullan m Bildir I'm trying the service broker features of SQL Serv ...Show All

• Hrishikesh Biniwale Full Text Search resultset count

  For performance reasons I am limiting the resultset to 100 rows. However, I would like to have the performance but need the total count of rows found. How can I keep the performance gain from limiting to top 100 and still get the total count. Could I do something like this: select top 100 count(id), field1, field2, field3 from .... Would this return 100 in the count field Thanks I think T-SQL does not suppo ...Show All

• yvading1482 How to show KPIS on a webpage?=

  I want to show KPIS on a webpage How can I do this     Somebody please know how to do this Hi Luis, Check out this article from Mosha about ADOMD.NET source code for querying KPIs in Ananlysis Services 2005 in ASP.NET, I hope it answer your questions. http://www.sqljunkies.com/WebLog/mosha/archive/2004/12/06/5433.aspx sample code: http://blogs.msdn.com/olivier_pieri/archive/2004/12/06/275811.aspx Regard ...Show All

• James Hague creating flat file and SQL Server 2005 hangs...

  i m using the hands-on labs for SQL server 2005. Step 6 age 14 i went thro and it make my SQL server 2005 hangs when i try to use the flat file destination. You'll have to provide more info. The flat file destination doesn't use SQL Server in any way shape or form. What does your dataflow do What colour are all the components in there (assuming you are running this in BIDS). Do you get an erro ...Show All

• DannyAdler Printing Blank in Landscape

  I've a report which is quite wide, and I'd like to print it in landscape.  In using the ActiveX control to change the print settings, the Preview looks great in Portrait, yet when I change it to landscape I get 8 pages of blank. If I change it back to Portrait, I get an error saying there was an error rendering the report. Has anyone had any luck with this Thanks. I don't think the error has anything to do with the blank pages. Gener ...Show All

• DomChi How do i execute commands inside a CLR SQL Server Trigger?

  Hello, the examples from MSDN like the following, don't run on my computer. A System.Data.SqlServer don't exist. No SQLCommand Type, no SQLContext.GetCommand Method and so on... Ist there something wrong with my installation or how do i execute commands inside a CLR SQL Server Trigger Regards, Markus Imports System Imports System.Data Imports System.Data.Sql Imports System.Data.SqlServer Imports System.Data.SqlTypes Imports System.Text.Regular ...Show All

• Frank Hileman Get the Report Model Fields of a particular report?

  If I have a Report Path and I want to get at the fields associated with this report's Model (not the fields in the Report!!!), is there a way to do so using the ReportingService2005 or the VS.NET 2005 ReportViewer control I have played around with the ReportingService2005.GetItemDataSources() and the ServerReport.GetDataSources() (ReportViewer) methods, but with no luck. I imagine that this functionality must be available becuase the Model fiel ...Show All

• Quad-Com Beginer question - calculated aggregation

  Hi, I have two measures: quantity and price. The default aggregation sum is not valid for price, because I dont want sum(price), what I want is somethin like: sum(quantity*price)/sum(quantity), in other words, a weighted mean. How can I do that I think that I have to place some code in the CALCULATE section, but I don't know exactly how. Thanks. You have a few options. Probably the eas ...Show All

• Randy Cragin AS2005 - MDX Debugger

  OK - I am quite sure that I have heard there is some kind of MDX Debugger in AS 2005, but I can't seem to find it. Also, I am unable to find any documentation on how to use it (if I could find it). Can anybody help Thanks Deepak... I just noticed that the tutorial contained a reference to the debugger, and Teo's book should be in on its way. Only BOL reference I saw so far to the MDX Script Debugger was in AS 2005 Tutorial ...Show All

• kimkim Cannot Set Connection String For Bulk Insert Source Connection

  I came across something strange today. I was wondering I was doing something wrong. I want to go through a directory and get files and assign the Fully Qualified File Name to a User Variable. I want to use that variable as a connection string within Expression in Bulk Insert Task Source Connection,  Data Flow Task and File System Task. It is working fine within Data Flow Task and File System task. It is NOT working for Bulk Insert . ...Show All