Answer Questions

• Wayner7 limitations of express edition

  What are the limitations of sql server express edition   For example oracle released Oracle express and its limitation is of maximum user data size of 4 gb.  Have a look at the following document, which compares the SQL Server editions: SQL Server 2005 Features Comparison SQL Server 2005 Features Comparison - this chart is not so detailed as I need. In comparison table for SQL 2000 was item about http/https connectivit ...Show All

• snesbit Where has my SSIS Package gone?

  I created a Package in the Import\Export Wizard, requested it be Saved on the server, and ran the package. But I can’t find any trace of the Package under SQL Server Management Studio. Where has it gone TIA, Barkingdog P.S. I remember the “old” days of sql 2000 where packages were proudly displayed, prominently, under the ”Data Transformation Services” option folder. Sigh ); ...Show All

• Cika service broker message on remote instance not working

  I was trying to send a message on a different instance in the network using service broker. I have created the endpoint and route both the side. I could see that the messages are in the transmission_queue in the sender side with no error in the status. What could be the reason. I am doing the following: CREATE ROUTE inst02 WITH SERVICE_NAME = 'SERVICE2', ADDRESS = 'tcp://10.14.43.149:2341' in the send script i am using this: BEGIN DIAL ...Show All

• Eric Kiersky Change Column Order

  How does one go about changing the column order of the data moving thru an SSIS package   It'd be nice to able to do this at any point in the package for readability, but where I really need it is in the Flat File Output.  I need to deliver the columns in a specific order, and I can't figure out how to do that. This seems to be such a basic question, but I can't find it in Search anywhere.  My apologies if it's already been answer ...Show All

• LaurieCSI SQL Express SP1 Upgrade

  Hello, When upgrading an MSDE Service Pack 4 named instance to SQL Express we were able to use the command: setup.exe /qb- UPGRADE=SQL_Engine INSTANCENAME=<instance> SECURITYMODE=SQL and the upgrade would complete successfully accepting the SECURITYMODE as SQL Server Authentication (mixed mode). If we excluded the /qb- silent parameter the upgrade dialog would allow us to select Windows Authentication or SQL Server Authentication. ...Show All

• simonec sys.objects vs. sysobjects in master..sp_ stored procs

  use master go create procedure sp_GetObjects as select * from sysobjects ; calling this procedure from different databases will return different results (behavior similar to 2000). use master go create procedure sp_GetObjects as select * from sys.objects ; calling this procedure from different databases will return results for master db only...  (ditto for all other sys. catalog views) how can I create database agnostic stored procedures u ...Show All

• KarlFollman Load Balance Clustering on 2005?

  My company is planning on using a datacenter for our customers.  These are manufacturing plants from which we collect batch and trend data (currently stored in SQL Server) If we move to a centralized database model we may need Load Balancing.   I  read that SQL 2005 will accommodate this so I called MS Support and no one could confirm this. My dilemma is that I need to report upon what our options are for the datacenter.  ...Show All

• mateid Err while importing data containing value of date field is of yrs.1800

  hi Dear All How can i import data in SQL Server 2000 which contains the value of date field from 1800 yrs to till now eg. 15/12/1860, 10/10/1896, 10/10/2006 but if i change the year of date value to 19 then it's imported. anybody can help me please! Thanks in advance Rahman Are you trying to use a smalldatetime field to store the data ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/htm ...Show All

• troptommy SQL DMO Support in SQL Server 2005...

  Hi,     We have a C++ application that uses the raw SQL DMO COM interfaces to connect to the SQL Server 2000. When this application tries to connect to SQL Server 2005, it failed to connect for obvious reasons. I tried to use the latest SQL DMO interfaces and, to my surprise, in the June CTP, I didn't find any header files that contains the COM interface definitions for the latest SQL DMO. Is this something that MS ...Show All

• Srinivasa Rao Probem in using the Copy Database wizard

  I am trying to migrate from  Sql server2000 to Sql server 2005 with the help of Copy Database Wizard of 2005. It is failing in the Last step. That is when executing the Sql Jobs.Could any one help me out Thanks Ram Vajrala Any answer for this problem Thanks. Another problem is NetBIOS. My dev server is on a different subnet to the prod server and because SQL2k5 still insists on using ...Show All

• frusciante Cube Actions, how can I create a Command line action

  In Analysis 2000 there was a command line action type , how can I do the same action in Analysis Services 2005 Analysis 2000 command line action: Defines an MDX statement that can be executed as a command line and displays the contents of the current directory: "cmd /k dir"     Peter, I believe the problem is in the "Expression" you supplied to the command line action. It ...Show All

• Svladim Cached Report and Windows Authentication

  I want to use cached reports with Reporting Services 2005. But when I edit the execution properties of a report, an error message answser that I can't use cache because it has a connexion to Analysis Services with Windows Authentication. I understand why I can't do that, but I still want to do so, because the reports take too much time to load. How can I do that Thanks. You can configure the datasource in the report to run using st ...Show All

• Mark Rockmann sqlmangr.exe program error (Please help)

  Whenever I run the sqlmangr.exe after the system reboot, the sqlmanagr.exe generated program error. "sqlmangr.exe has generated errors and will be closed by Windows. You need to restart the program." I am using MSDE 2000. The OS is Windows 2000. One thing I noticed is that sqlmangr.exe will not crash if I disconnect the system from the NETWORK. (By unplugging the network cable.) YOUR HELP IS APPRECIATED. Well, I've tried to ...Show All

• info2knowledge Error 9104

  Why does the server return Error 9104 "auto statistics internal" I can't find an error description in BOL, MSDN or through a groups/forum search either. We running Sql Server 2005 (no sp yet) on Windows 2003 server. Thanks Hi Mark, I only have the severity level, 16. I don't capture the state in my error trace. We migrated to 2005 in mid-March and this error has been returned twice. ...Show All

• ndomain New contest - $10,000 and all it takes to start is an idea...

  Just announced, a new contest for SQL Server Express. Do you like to use technology to build cool and useful stuff Do you think you could do it with Visual Studio Express and/or SQL Server Express Would you like $10,000 cash Well then we have a contest for you! Learn more at www.MadeInExpressContest.com . Cool stuff. MJ ...Show All