Answer Questions

• Celios No access from Application to SQL Server 2005

  Hi I have installed the 2005 SQL Server and its up running. I can connect to the database direct as administrator, but my simple test application returns an exception. SqlConnection con = new SqlConnection( "server=mercur\\sqlserver2005,database=AdventureWorks;integrated security=true" ); con.Open(); As the output confirms it might be the default settings. Im not familiar with the enviroment and will appreciate your help. Mosq ...Show All

• Michael Entin - MSFT Connecting Sql Server 2005 from ASP?

  Hi We are planning to move over to SQL Server 2005 in near future. At the moment Website is on a seperate server then the Database. OS for both the server is Window 2003 and currently our data is on SQL Server 2000(on which everything works fine). Part of the testing process we tried to connect our website on SQL 2005 and it does not work at all. I get this ---------------------------------------------------------------- ADODB.Connec ...Show All

• Marais_Kruger Can I create Packages programatically

  For example assume that there is a DTS That takes some SELLS data from an oracle database and sum the sells for each month. I can create the package visually, but what about if I want to create it programatically. I want to make a software  for Balance Scorecard in which the users dont need to know Integration Services. they should have a consoloe for asking where to get an Indicator value. and the program should create it programatic ...Show All

• Jose Ann Roche All tables and columns referenced by sql objects

  I'm trying to find all the tables and columns referenced by the sql objects (stored procs, UDFs, views, etc.) in a particular MSSQL2005 database. I can join the sys.objects, sys.sql_dependencies and sys.columns tables using object_id, referenced_major_id, referenced_minor_id, and column_id but I find that the more complex procs contain references to tables (sub selects, for example) that do not seem to appear in sys.sql_dependencies. I can ...Show All

• Jesper25539 Dyanamic Parameters

  Hi All, I am stuck with a report, could you please help. I have a dynamic stored procedure, which depending on Begindate and Enddate displays columns deptname and amount (depending on the month the amount field is going to sum and display the results in the appropriate date columns), that is sum(amount) in Jan05,Feb05,Mar05........depending on the Begindate and Enddate, it's displays the values. E X:- Deptname Jan ...Show All

• vb777 Prevent writing to the Transaction Log?

  I know this isn't exactly best practice, but is there anyway to perform DELETEs and INSERTs without writing to the transaction log Mike No. The only type of operations that can be minimally logged (in SIMPLE and BULK_LOGGED recovery mode) are Creation and drop of indexes Bulk loading of data Modification of BLOB data SELECT INTO -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserv ...Show All

• Gerlop Failed to generate a user instance of SQL Server

  Hi, I have visual basic team 2005 beta that come with sql server express, and i am trying to connect to a database on my local computer. And i get this message "Failed to generate a user instance of SQL Server due to a failure instarting the process for the user instance. The connection will be closed". If u ever heard of the Northwind database it is the one i am trying to use I don't know much about how to configure server, but i ...Show All

• ed_narayanan Urgent:The Query works in 2000 but fails in 2005

  The following query works in SQL Server 2000 but gives the following error in SQL Server 2005: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. Note that the tables in both database has the same data. ============================================ SELECT ID FROM VWCONTACT WHERE ID IN (SELECT DISTINCT top 2500 VWCONTACT.[ID] ID FROM VWCONTACT JOIN (SELECT [id] ...Show All

• Bassam.kareem Execute package via a web application failing

  I have created a web interface for an ETL.  The SSIS packages run via the GUI package utility and the command line; however, they fail miserably via the web application.  The web app discovers the package without a problem, as I can view various properties of the package within the web app.  However, when I call execute and step through the code a DtsError is returned referencing "System.__ComObject".  Any ideas string p ...Show All

• Randay Obtain sqlceresultset table schema with GetSchemaTable

  I have a SqlCeResult pointing to a table : Public conexion As Data.SqlServerCe.SqlCeConnection = New Data.SqlServerCe.SqlCeConnection( "Data Source=iPAQ File Store\GestionAlmacenN.sdf" ) Public ComandoCargaProductos As Data.SqlServerCe.SqlCeCommand = conexion.CreateCommand Public ResultSetProductos As Data.SqlServerCe.SqlCeResultSet Private Sub Form1_Load( ByVal sender As Object , ByVal e As Sy ...Show All

• anina79347 IsQueryStoredProcedure property won't stay set

  I'm using an ExecuteSQL task to fire a stored procedure. There is a property in the editor called IsQueryStoredProcedure that is disabled. However, in the properties window there is a property call IsStoredProcedure that is enabled and can be set. Problem is that it doesn't stay set. Is this a bug From BOL IsQueryStoredProcedure Indicates whether the specified SQL statement to be run is a sto ...Show All

• Walter Sobchak Create Trigger for View

  Hi, just started to write my first trigger for a view. Of course I got some errors, which I could could resolve except one. Whenever I run my script I do get the following message: Msg 213, Level 16, State 1, Procedure IO_Trig_INS_Zuordnung_Alles, Line 11 Insert Error: Column name or number of supplied values does not match table definition. The Code where the error occurs according that message is the following: CREATE TRI ...Show All

• .seb Restoring .cab file

  Hello, I am trying to move towards SQL Server 2005. I need to move my Analysis Services 2000 database to SSAS 2005 (both on different servers). What is the best way to do so. Also if I have the .cab file of the AS 2000 Database , Can I restore it in SSAS 2005 environment. Thanks in Advance , siaj Thank You Yan and Adrian. That pretty much what I wanted !! siaj Hi Siaj, You can use the AS2005 migration ...Show All

• BOBSONATOR Foreach loop with parallel execution

  Is is possible to get the iterations in a foreach loop to run in parallel What I need to do is to spawn an arbitrary number of parallel execution paths that all look exactly the same. The number is equal to the number of input files, which varies from time to time. Any help is appreciated! Regards, Lars Ronnback   lasa wrote: Thank you very much for your help Michael. I will try the proposed solution and compare performanc ...Show All

• Opher SqlServer2K5_BOL.msi

  In July I obtained and installed the dvd's SQLServer 2005 Developer Edition CTP so I assume this is the June 2005 version and VS2005  Team Suite Beta 2. I tried downloading the above file for Sql server 2005 Books online and it fails saying I need .Net 2.0  (  seems VS2005 installed .Net 2.0 Beta ) I am also having trouble understanding some concepts ( I am relatively new at this ) Why do I even need this SQL Server 2005 dvd   ...Show All