Answer Questions

• bigftballjock Accessing Remote SQL Server Management Console from the web browser?

  How does one access a remote SQL Server from the web browser Thanks, -Conrad There is no builtin functionality for that. But Microsoft offers a Web Administrator (don’t knwo if that one is also capable for SQL Server 2005) http://www.microsoft.com/downloads/details.aspx FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&DisplayLang=en HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Zenaku213 Feedback Requested - What Content Do You Want to see for SQL Server Express?

  We’re in the process of assessing the content that exists to help people learn and use SQL Server Express.  This includes demos, tutorials, whitepapers, Webcasts, Starter Kits, and any other type of content you could imagine.  So this is a great chance to TELL US WHAT YOU WANT!  We’ll integrate your feedback and make sure that we try and address the most requested areas of content.  Please be as specific as you can. F ...Show All

• Michael Dye Job To Execute A SSIS Package Fails - The Command Line Parameters Are Invalid

  I have created a job to execute a SSIS package located in the SSIS Package Store.  When starting the job I receive an error.  The history log reports: Message Executed as user: DOMHARRPROMAST\SQLMAIL. The command line parameters are invalid.  The step failed. This is the command line: /DTS "/File System/DataWarehouse/AgencySCD" /SERVER ntharrsqlt500 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF What am I doing wrong ...Show All

• chemaster Active (non executed) objects will still drain performance!?

  Even if objects(tasks, components) are not explicitly called (say they are under another CtrlFlow constraint which doesn;t meet expr_condition), they will still eat up performance. We have a pkg that has 3 DFTs that will either transform FLFFtoXML, CSVtoXML, or PIPEtoXML. When we execute this pkg it takes roughly 15 secs to complete, but for every DFT we disable, it shaves 5 secs off. We did some debugging and found that an entry of: DLLGetClass ...Show All

• DavidT Unable to set Default Schema for a group

  We're using Windows Authentication with our SQL Server.  We've added a domain group to the SQL Server groups and would like to give it a default schema.  The properties window is the same for users and groups but the default schema field is enable only for user entities.  We cannot add a default schema to a group.   Is this by design,  a bug or a problem with our SQL Server installation Updated on ...Show All

• cruelasix Sql Server Business Intelligence Development Studio

  I installed all the software that comes with sql server 2005 express including: sqlexpr.exe, sqlexpr_adv.exe, sqlexpr_toolkit.exe. All the installations were successful. However, Sql Server Business Intelligence Development Studio could not be found from start menu. I am not sure whether it got installed. I need it to develop reports. What could the problem be Any solutions Regards sandy   I have th ...Show All

• sriramnaga MS SQL vs free Databases

  Hello I need to write an application which must use a database system as a backend, but i have not choosed which one to use. MySQL and PostgreSQL has all the features i want. the most important is database performance. anyone has an idea which database performs faster thanks in advance A major consideration for your choice of database should include not only features and performance, but the development environment. You really nee ...Show All

• Leo H SSIS Excel Source: Index is not valid

  An Excel Source Data Flow object ( which used to work fine ) sudenly started display the following error box: TITLE: Microsoft Visual Studio ------------------------------ Error at Create BusStop Table [DTS.Pipeline]: The index is not valid. ADDITIONAL INFORMATION:Exception from HRESULT: 0xC0048004 (Microsoft.SqlServer.DTSPipelineWrap) What could the cause be What is the meaning of: HRESULT: 0xC0048004 How could this info be used ...Show All

• lamojo What are the current best practices for standardizing report layout and appearance?

  I am accustomed to the Actuate enterprise reporting system in which it is very easy to define reusable page formats that standardize things like page layout, margins, logo placement, page header and footer formatting, etc. You just drag and drop a page layout from your component library to inherit from it, and ensure that all your reports have the same consistent format. What if any features and tools are there to accomplish this in 2005 Reporti ...Show All

• MArkyMArc Linked Server to Sybase 11 problem

  Attempting to create a Linked Server to a Sybase 11 db. Did the following - Used DSEDIT to create a data source. Ping(Test) works - Created a System DSN using the Sybase System 11 driver - Created a Linked Server with following options     General Tab       - Provider as - MS OLE DB Provider for ODBC Drivers       - Data source as the DSN name created above       ...Show All

• AndreaC Trouble importing csv with flat file source

  Hi, I am having trouble importing a CSV file with double quote as a text delimiter.  The problem arises because one of the text fields has double quotes embedded in it.  This file loads perfectly in SQL 2000 DTS, but SQL 2005 SSIS will fail on the flat file source.  I would appreciate any input on this. Thank you, Nick Russo Seems like bit of step backwards. Why not log it via MSDN Product ...Show All

• bchadraa MSFT 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

• ErtanO SP1 Installer Can't Connect

  The installer for SP1 can't seem to connect to my unnamed instance of SQL Server 2005 Developer, even though: I'm using Windows Authentication (don't ask...) I can connect with no problem using SSMS using those exact same credentials Anyone know how to get this to work I've downloaded the installer from our MSDN Subscription, so I can't imagine what the issue could be (and I'm just a dev, not a DBA). Thanks, Rob ...Show All

• ef SQL express on pc / svr questions

  I have a few questions about SQL express. Will SQL express make my workstation (regular PC on network) act as a server Or does it just allow VB express / Web Developer Express to write code that will work on an actual My SQL server The goal is to make a simple DB that will then be used on a website on a live server which has My SQL on it. I don't need SQL express on that server also do I MY knowledge about SQL is next to null. Thanks ...Show All

• kklasman Transact-SQL Script Job Step

  Is there a character limit when using the TSQL job step To clarify... I am trying to create a temporary table in a job step. When I copy and paste the script into the job step (TSQL) the command gets cut off after 3043 characters-including white space. I cannot type anything else into the command field. Any help is greatly appreciated... Rob Thanks for your help... I am using SQL Se ...Show All