Answer Questions

• wrtoomes 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

  64 bit Server 2003 with Sql 2005 64-bit I can't seem to do a lot of things. Like... backup the database through the SQL agent. I'm catching flak from the client who was told by a microsoft rep that SQL 2005 works like a charm.... It's too late to move away from SQL 2005, we've already migrated systems over to it, and now I'm stuck. This error happens when trying to export to a flat file using Export Wizard(right click database and choose export ...Show All

• Constantin Cristian Failed to generate a user instance of SQL Server

  Hello all, I unisntall products as it are recommended (VS 2005 and SQL Server 2005 beta 2) in readme.txt of MSDN products subscription... I install VS 2005 Pro and I have no problem during install. Now, if I want to open database, I have this error mesage : "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." In MBSA report, I see that the folders of SQL ...Show All

• Leksey Dynamic Transformations

  Hi I have a dts that is creating a table with not a fixed number of columns. The number of colums depend on a couple of factors based on the data that I'm pulling from other tables. After some processing I need to dump all the data in the "dynamic" table into an excel doc. My problem is with the transformations within the transform data task. I don't know how many fields I will have in my table and this needs to be mapped to colu ...Show All

• KiAsU List all databases accessible by a login

  Hi all. I am new to SQL-DMO so sorry if what i am asking is really easy. Is it possible to get a list of all objects (including databases) which are accessible for a particular login. So far I have: Dim oSQLServer As SQLDMO.SQLServer Dim oSQLDatabase As SQLDMO.Database Dim oSQLLogin As New SQLDMO.Login Dim oUser As New SQLDMO.User oSQLServer = New SQLDMO.SQLServer oSQLServer.Name = _oSQLServer.Host ' Check se ...Show All

• Mikeymac Newbie question: adding a single value to a list in a stored procedure

  I have two tables. UserIds is a collection of users, with UserId as the primary key. Contacts simply maps pairs of users. Think of it like IM, where one user can have multiple contacts. UserIds ---------- UserId - int, primary key Username etc Contacts ------------- UserId - int, the UserId of the user who has the contact ContactUserId - int, the UserId of the contact I also have a stored procedure named GetConnectedUserIds that retu ...Show All

• Steve Severance Code Completion of SQL Statements in 2005

  Will the new tools for SQL 2005 give us code completion of SQL Statements, e.g. if I type the following sql USE pubs GO SELECT pub. FROM   publishers AS pub When I type the "pub." will I see a list of the available columns in the publishers table.  This type of feature has been available in TOAD for years and years, will SQL Server programmer finally get this in the 2005 release. Cheers, Colin ...Show All

• Prashant_Rai cannot convert between unicode and non-unicode

  I keep getting the error message below when attempting to import a text file (flat file) to an SQL Server Destination using SSIS. This database has recently been migrated from SQL Server 2000 (where I used a DTS Package that worked fine). I plan on doing further manipulation to the file after importing but have so far tried to keep one step at a time. I have tried using a smaller files and different tables but still get a similar response. I bel ...Show All

• Colin Reid Development Procedures

  Hello, Recently my partner in crime (so to speak) and I have been asked to develop procedures and/or methods for our software development group. Currently we're running SQL Server 8 with several Access apps and Crystal Reports. In a nutshell, I'm looking for resources. We're supposed to develop a process (we're both DBA's) where our development team can formally submit new stored procedures, views, or whatever they've come up with to s ...Show All

• MCastellana Using stored procedure as OLE DB source with parameters from package variables

  Hi Guys, (I have searched this forum extensively, but still can't find the solution to this problem) Here it is: I have step in my ETL process that gets facts from another database. Here is how I set it up: 1) I have to package variables called User::startDate and User::endDate of data type datetime 2) Two separate Execute SQL Tasks populate those variables with appropriate dates (this works fine) 3) Then I have a Data Flow T ...Show All

• the_skipster Reporting Services Setup Issue

  Hi All, I am running setup.exe (RS 2000 Enterprise), and ra issue during the following step - "specify credentials that are used at run time by ReportServer service to connect ot SQL Server Instance..." My local SQL Server is running under "Local System" account, and I have SQL Server 2000 SP4 installed on Windows Server 2003. Any help to resolve this setup issue is much appreciated! -Lawrence ...Show All

• daveremy display filter info in Report Builder

  hi all, is it possible to display the value of filter on the report (Report Builder) instead of displaying Filter: Productions with: All of (Month in (prompted)) which is not informative. thanks ! Hi Bob, will this solution that you suggested work with parameters which have multiple selections Thanks! Hi Bob, thanks a lot for the info. was looking high ...Show All

• Pochero 1802 access denied

  Hello everyone, I got a strange problem when installing sql express on an empty windows xp sp2 machine. When I try to create a new database within a directory, which existed before installing the server (e.g. c:\programme), i get an error message something like "1802 access denied, cannot create database". But when I try to create a new directory on the harddisk (e.g. c:\oliver) and create the database into this directory, the ...Show All

• heraino Web Site Admin Tool problem in VS2005

  All, When I create a new project and try to use the WSAT security tab, I get the following : There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the proble ...Show All

• Andrew Revvo Ignore Null in a Column that otherwise needs a Unique Value

  In Access, when you specify a unique key for a column, you can also specify IGNORE NULL, in which case there can be more than one record with NULL, but if the field is not NULL, then only one record can exist. How do I do the same thing in SQL Server. I have a table with a column that identifies a Previous Entry. If the column is Null, then there is no previous entry - this may occur often. If the column is not null, then there is a Previous Ent ...Show All

• Lexin Shan Customer Issue how can i connect to sqlserver2005 express by ado

  hr = m_pConnection.CreateInstance("ADODB.Connection");   if (SUCCEEDED(hr))   {                 if (FAILED(m_pConnection->Open("Provider = sqloledb;Server=(local);Database=c863;Trusted_Connection=yes","","",-1)))            {             &nb ...Show All