Answer Questions

• Derson Andrade Where is the Business Intelligence Development Studio

  Hi folks, I installed SQL Server Express Advanced Edition and Toolkit. According to the documentation, I should be able to create reports using Business Intelligence Development Studio, but I can't find it. There is only a Microsoft Visual Studio 2005 menu instead. I'm just wondering if there is something wrong with my installation, or is BIDS inside Microsoft Visual Studio 2005 Any comment appreciated. ...Show All

• jeevankumar Remove identity

  Hi all, Is there a way to remove the identity from a column by using alter table thanx Hi, identity is no property, you have to create another column, copya the values to the new column and drop the old one. HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- Hi, "disabling" the property does the things behind the scenes I mentioned in my earlier post. In SQL 2k (I didn't check that in SQL2k ...Show All

• CBWoodSr High level of login/sec

  Hi All Perfmon shows max 3900 login/sec and avg is 1500. ASP.NET v 2.0 application uses this SQL 2005 server consists of 10 webservers. Max Pool Size on each was changed today to 300 (was default so I suppose - 100) and it didnt change logins/sec graph at all. Application uses SqlConnection object from ADO.NET v 2.0 obviously. Can someone explain - what could be reasonable explanation - is load that high Do we need 3000 as Max Pool Size ...Show All

• fedeburin How to define a null value in expression?

  I wanna send a null value to my stored procedures instead of a blank,and i cant use ReportParameter.Nullable Property.so I wanna write a expression like Iif(Parameters="",null,Parameters),but null is unrecognized identifier.how to express a null value thx! Have you tried using "Nothing" instead of "null" It's the VB version of null. thx Ryan Ackley MSFT ,u r right...my repor ...Show All

• yuval08 Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException

  Hi I have a SSIS project that has one parent package and three child packages. When I run the project on my development machine in debug mode it works fine. Also if i run the packages using dtexec on my development machine it still works fine. However the problem comes in when I try and run the project using dtexec on the staging server i get the following error: Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException: The value is too ...Show All

• RealmRPGer Excel 2003 Query Performance

  We are using AS 2005 and Excel 2003 as the client front end. I have one particular view built in an Excel Pivottable that takes about 10 minutes to return results. I was pretty sure that the aggregations should support a quicker response so I used XMLA on the server to look at the Sessions whilst the query was running. Using this I grabbed the MDX and ran it interactively to see if I could figure the problem .... it returned in 1 seco ...Show All

• MLCollins Dynamically determining the SQL statement?

  Hello all, I am working with a client who will be creating "template" report for users to be able to customize.  The customization settings will be stored in meta data on a SQL Server somehere. Part of the customization features will allow users to filter the data that they view.  There may be 20 plus filters on any given report and they may want to filter in many different ways (i.e. sometimes to an Equals, other times an IN (), other ...Show All

• peterneo Programmatic generation of History snapshots with varying parameters

  When you call CreateReportHistorySnapshot it generates a snapshot of the specified report with only the default parameter values. How would I generate snapshots based on parameters specified at runtime I think you would be better off using a LinkedReport. This is what they are for. So you can use the basic report yet different parms, Security, folder etc... But your way will work to you just have to writ ...Show All

• zoggs Named Pipes Provider: Could not open a connection to SQL Server [2]

  Hi I'm a complete sql/asp.net newbie and want to try this tutorial: http://beta.asp.net/GuidedTour/ First I installed: Visual Web Developer 2005 Express Edition Beta 2 systemsettings\software shows the "sql server 2005 express edition ctp (sqlexpress)" installed mmc\service shows me the SQL Server (SQLExpress) is running Following the guided tour I use the commandline, type cmd, and type in the commandbox:   "C:\Program Files\Mic ...Show All

• Jephthah Problems with SQL 2005 Export Wizard

  I am trying to transfer data from SQL Express to SQL Server 2005. The data is from Paypal Commerce Starter Kit from ASP.NET site. I have tried several options (Optimize for many tables, Run in Transaction). However the data is not exported. This is the error I am getting: TITLE: Operation stopped... ------------------------------ The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error i ...Show All

• Istvan Majercsik Licensing of SQL

  I previously asked about migrating MS Access to MS SQL 2005 and was informed with the size of my operation that an SQL Server license with 12 device CAL licences would be my best approach. In an experiment, I loaded SQL Server from the Visual Studio 2003 on one of my PC's in my personal workgroup, then wrote a quick VB 6.0 data access to the SQL table using a oledb connection. I installed the quick data access program on another PC in my wor ...Show All

• Scav SQL Server 2005: Upgrade to Aug CTP VS.NET invalidates CLR

  I get the message that (CLR) v2.0.50215 not installed properly. The August CTP release of Visual Studio seems to be installed properly. Does this mean that both SQL Server 2005 and VS.NET have to keep versions synchronized I guess so. I might add that this is under XP 64) VS June, July and Aug CTPs are not compatible with any SQL Server build, they will be in Synch again for the next CTP and for RTM. ...Show All

• Peter Haynes identifying procedures marked for autostart

  Hi all, Is there a method of identifying all the procedures in a database that are marked for autostart i.e. select name from sysobjects where blah = 'autostart' Thanks, rocr Startup procedures must be owned by the database owner of the master database and located in the master database. SELECT name FROM master.. sysobjects WHERE xtype = 'p' AND OBJECTPROPERTY (id, 'ExecIsStartup' ) = 1 To see ...Show All

• willmacs Walkthrough Failu "Creating a Mobile Application w/SQL Server"

  I am attempting to go through the "Creating a Mobile Application with SQL Server" walkthrough found in the SQL Mobile Books Online help file. Towards the end of this document (under SQL Server Mobile Tasks), they show how to create a new subscription. Unfortunately, after step 10--when you are asked to click finish--I get the following error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Failure to connect to ...Show All

• mookiebud Filter parameter based on prior parameter

  Hi guys, i have some report parameters that are dropdowns, and i would like to use whatever is selected in them to filter subsequent dropdowns. I know that the report designer automatically makes parameters dependant on each other, but that has been stripped out of the rdl, i need to replace it with more targeted filtering. So assuming that parameter A and parameter B get their values from a dataset, how can i filter parameter B's conte ...Show All