Answer Questions

• Amritha Chand 2005 Management Studio Slow to start in some cases (have disabled certificate check)

  If I open SSMS from the start menu it opens instantly. If I double click on a sql file in explorer it takes about 10 seconds for it to open (either in the existing instance, or a new one if one is not opened already) . If I try and open it by double clicking on a sql when visual studio is stopped at a break point, it takes about 20 seconds. How can I speed it up The path was local so this didn't help. I noticed this weekend that if I remote desktop to the computer, the files open instantly. Any idea why the slow down would not occur in this case Check what is the path defined on Query Analyzer to open and write the results, if that is based on a network drive then it ...Show All

• Web Explorer SQL Server 2005 install failure over 2005 Express CTP

  with the following log: Microsoft SQL Server 2005 Setup beginning at Wed Jun 28 19:02:06 2006 Process ID : 1220 E:\Servers\setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2006/5/28 19:2:5 Complete: LoadResourcesAction at: 2006/5/28 19:2:5, returned true Running: ParseBootstrapOptionsAction at: 2006/5/28 19:2:5 Loaded DLL:E:\Servers\xmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2006/5/28 19:2:6, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillib\persisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writ ...Show All

• Saurabh Kulkarni Coalesce with Sum

  I am having a problem with syntax. I am trying to sum a column where some of the values will be null and because I want to include the rows where the column may be null I am attempting to coalesce to zero. Below is my sample: SELECT * FROM dbo . Student w LEFT JOIN dbo . StudentDailyAbsence q ON q . StudentID = w . StudentID Group BY q . StudentID Having ( SUM ( Coalesce ( q . AbsenceValue ), 0 ) = 0.00 ) COALESCE ( SUM ( q . AbsenceValue ) = 0.00 , 0 ) I have tried using the coalesce statement a couple of ways with no resolution, pls help!! Thanks for putting me on the right track. I actually got the result I needed by modifying your first example a l ...Show All

• vtortola Can not deploy calculation...

  Hi, I had a calculated measure which simply tries to create a Margin Profit. This is the simply Measure divided by another measure. The problem is that when I try to deploy this measure with a Parent Hierarchy of measures it will not deploy I get the error like this: Errors and Warnings from Response MdxScript(SSAS) (7, 8) The 'Measures' dimension contains more than one hierarchy, therefore the hierarchy must be explicitly specified. Rgds., Hi PGoldy, Thanks for your information. I had to try to change the [MEASURES] to [Measures], it's work I can deploy it. thanks very much for your help. Cherming Hello. Can you explain what you mean by "Parent hierarchy of measures" For this c ...Show All

• nikos_22 How to install Windows Application(C#) with SQLExpress in a system which is having SQLExpress already?

  Hi All, I have created an installation application which will install the application with SQL Express and .NET Framework 2.0. If i install this application in a Fresh system(i.e which is not having SQL Express), it is installing the application with new database instance successfully. But if i try to install the same in a system which is already having SQL Express, throwing "Object reference exception" because it is not able to create the new database instance. Can anybody help me out . Regards, Doppalapudi. Hi, why don’t you use the already existing SQL Server Exress instance HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• b0bd0gz splitting generate scripts by object

  I am running 'generate scripts' to maintain the database schema. Is there any easy way that the generated SQL file can be split into several files by object to simplify version control Hi, for some reason this is not available anymore. But you can have a look at the SMO classes and the quick samples here to see how you can get things done: http://www.wardyit.com/blog/blog/archive/2006/07/21/133.aspx HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- There is no easy way to do that using SP1. The good news is that this functionality was added to the Generate Scripts Wizard in SP2. Hope this helps, Steve ...Show All

• Taylor Meek ODBC support

  Can CE be called from an app. that makes ODBC calls Thanks. Ah, be that as it may, OLE DB and the .NET Framework providers are also industry standards. Yes, ODBC is certainly the oldest, and least flexible but granted, it's still in wide use. ODBC is supported in both OLE DB data access interafaces and .NET providers. The tiny SQLCe database is small because its support is focused on current technology. If it was more flexible in its interfaces I expect it to be larger and less useful for its intended purpose. Two: 1) The existing (calling) application uses ODBC calls; 2) ODBC is the only industry standard for database access. It is an indication of MS's market power that they can ...Show All

• bakintunde Errors on install of SQL Svr 2005 Enterprise

  Greetings, I have attempted a full install of 2005 Ent on our W2k3 Enterprise server. When attempting to install all services (SQL Svr database, analysis, reporting, notification, integration, client services/components) I get the message: "The features specified are not valid for this edition of SQL Server". I got the same thing when attempting to install with various subsets of services. Then I tried just database services and client components and got the message: " There was an unexpected failure during the setup wizard. " Perusing the core.log, I see: Fatal Exception caught while installing package: "10" Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the fil ...Show All

• Boise83716 Debugging In Business Intelligence Studio

  I've been trying to get debugging working in BIS, but I can't seem to do it.  If I am using the full blown version of Visual Studio I don't have any problems.  I have read that TSQL debugging is limited to Visual Studio Professional or higher, however, there is no indication where Business Intelligence Studio is in the Visual Studio continuum.  I don't know if it is considered lower or higher than Professional. Anyway, if it is possible to use BIS for debuggin TSQL, then how does one go about doing it   I've have been competely unsuccessful to date.  I have attempted to install and use the Remote Debugger, but that hasn't worked for me.  So, I'm left to conclude that BIS doesn't support TSQL debugging. M ...Show All

• Jianxing Can't connect to reporting server using SQL Server Management Studio

  Dear all, I can't connect to the reporting server using SQL Server Management Studio. Do I need to put any port number to the exception list of the firewall Thanks. Best regards, Michael Wu What error do you get Try using the server name or report server url (the default is http://<servername>/reportserver ). ...Show All

• Amjath Best Way To Update Existing Rows

  IUpdating existing rows in a SQL server 2005 destination table --I have a CSV file and every row needs to perform an update on a production table The most straight forward is to use an OLEDB Command Data Flow Transformation Object that sends one SQL statement per row coming in. How do I configure this object That might be okay if you've only got a small number of updates, however if you've got a large set, I prefer landing this set to a temporary table and then doing Set based updates in a following Execute SQL task. Can you please tell me how I can set up the Execute SQL Task to do set based updates in the Control flow thanks in advance Dave UPDATE t SET t.<col> = te.<c ...Show All

• Barbie G Iterating the rows of a script component

  Hi There, Can someone please let me know what is the best way to iterate the output rows of a script component and stick in those ids in a where clause of a select query (to retrieve additional info from a database) Is this possible at all If not, what is the best way to deal with this situation Thanks a lot!! Thanks Jon. I really appreciate your response. I will try your trick and will let you know soon. Sam_res03 wrote: Jamie, Thanks a lot for your reply. I think I am almost there...So I have one one column in the recordset. Is this what I should do By using a for each loop container, with foreach ado enumerator I can get the id and store in a variable. Next can I have a dataflow task in the fo ...Show All

• R.Arjun Slowly changing dimension - always shows rows as changed?!

  I created a simple type 1 slowly changing dimension, setting all the columns to "Changing Attibute". The first time I run the package it sees all rows as new and imports them into the dim as it should. Next time I run it put 100% of the rows into the "Changing Attribute Updates" and runs an update on all 90,000 rows - updating the rows to exactly what they were before If I take the DIM and the Source in SQL and join on every row the join succeeds (meaning the rows match perfectly). Shouldn't the SCD object just ignore the rows if they match Or does it assume that ALL incoming rows are either new or changed (if so why is there an output called "Unchanged Output" ). Is there some "gotcha" I am mi ...Show All

• JustbobChico Assistance in connecting a SQL Server Client to SQL Server sitting in a shared environment

  Hi, I need to connect to a SQL server thats running in say abc.trident.com and also sits in a shared environment.. I have couple of questions 1) That SQL server is accessible from my network, yet when I swtich on my enterprise manager I am unable to view that in the list of running SQL servers in the populated list. Is it because its sitting in a shared environment I am unable to view that 2) What is the connection striing I should use to connect to the server..When I try to configure a SQL server registrations it normally asks for SQL Server name along with the user authentication Should I mention fill the Server: field as  abc.trident.com or // abc.trident.com/abc.trident.com to connect to the clus ...Show All

• daverage sqlcmd, bulk insert and affected rows

  When I use sqlcmd to "bulk insert" data, I don't have the message "... rows affected" on the output. I do have this message for select and insert statements, though. In osql it works for all the cases (no matter whether I use -Q query or sql input file). Is it an sqlcmd bug or rather a feature by design Is there any work around different than using osql Thanks, You are right, your example works for me, unless I use bulkload.txt with 500,000 rows and not 10 rows. I use both SQL Server 2005 v. 9.0.2047 and SQL Server 2003. v. 8.0.2039, the behavior is the same on both. Probably I will not need this functionality eventually, but this remains strange. Thanks, Hi, I use SQL Server 9.0.2047 and I a ...Show All