Answer Questions

• IgorB How to import flat files into Microsoft SQL 2005 Express Edition automatically?

  Iam aware that Microsoft SQL 2005 Express Edition does not have agent or DTS capabilities, but how may I automate an import of flat files to the DB tables Must I use an external VB development of is there a way to schedule an import of flat files to Microsoft SQL 2005 Express Edition Hi Andrea, I'm trying to get it to work but I keep running into this error message: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. Authentication failed. [OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.] OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBIni ...Show All

• dbasharon Setting up and connecting to SQL 2005

  I have deployed a web server using server 2003 standard edition and have created a functional web site... Now I want to create a SQL data base and make a DB connection using ASP.NET using Dreamweaver as my HTML editor... This is where I get totally lost and confused...I have SQL 2005 instralled on my web server and have gone through the help files and some of the tutes but am still spinning my wheels... Can anyone please help this wanna be MSDN... I need help configuring my sql server and then connecting to it via dreamweaver and then creating a data base for data collection from my web site... Any help here would be awesome! Dadeo You can go here: http://www.learnvisualstudio.net/con ...Show All

• Dave Edelman Referencing system message types

  I need to handle system messages being put on my queue. I have 2 ways of doing this, by message_type_id or by name. As BOL only mentions names of message types I assume the only gauranteed method is the "by name" option. or can I guarantee the values of message_type_ids, the reason I thought the latter was possible was that Remus included ids in his recent performance blog post. Thanks The safest way is to look up the id by name at the procedure start and then use the id. The system message type ids are the same on all deployed SQL 2005 SKUs/versions, but we cannot guarantee this for future versions. HTH, ~ Remus ...Show All

• Enrique Blanco Backup Jobs Locking ??

  When you run a Backup Job (Database or TRN), is the database locked during the database If yes, to what extent Thanks There are no locks that are not compatible with any user locks, but only those which could prevent database from deletion, for example. ...Show All

• Stephen J.Vanterpool Creating sql server table from dts

  I am trying to design a SSIS DTS package that imports an Excel named range (acts as a table) into a SQL Server 2005 database table. The direct import (using the import/export wizard) works fine, but I need to use a DTS package with a data transformation step. The DTS fails to create/replace/or update the SQL Server table. Suggestions Kirk, Thank you for the response. Your book will arrive tomorrow and I expect it to answer my many questions. I am trying to use the SQL Server 2005 SSIS designer to produce a package (SSIS or DTS ) to copy a named range (proxy for an Excel 'table') from a network drive; convert the data types to what I want on the SQL Server 2005 server; delete the database table if it alre ...Show All

• DanMeyers How to edit someone else's report definition?

  I need to be able to share report definitions with other people in my group, so we can all edit and makes changes to each report definition if the need arises. When I tried to use a shared folder the other person could not access my report def, so evidently there is security applied. What's the correct method to do this Please point me at the documentation if it's listed somewhere - even an MSPress book would be fine. This is for both SQLRS2000 and 2005. thanks Peter Try this. You will each have a project in VS. Have the other user add an 'Existing Item' to their project..this is your .rdl file on the share. Then inside VS they should be able to open the .rdl file. ...Show All

• Aaron Oneal Sql Server 2000 to SLQ Broker - newbie question

  Hi! I have a legacy database in SQL 2000 which I want to submit transactions thru triggers to SQL Broker, until I eventually upgrade this db to 2005. Can you tell me if this is possible Thanks It is possible in theory, by setting up a linked server on the SQL 2000 instance and then submitting T-SQL statements (or stored procedures calls) on the remote server (e.g. using OPENQUERY). The Service Broker functionality is exposed entirely using T-SQL, so the SQL 2000 instance will simply invoke T-SQL to access the Service Broker. But the penalties of using remote queries from inside triggers are severe: - every local transaction that invokes the trigger on the SQL 2000 instance is now transformed into a distributed transaction ...Show All

• Fari SQL Mobile 2005 NVarChar Truncation Problem?

  I have a field in an .sdf database which is an nvarchar(350). I'm accessing the database using .Net Compact Framework 2.0 and have setup the SqlCeCommand as follows: SqlCeCommand command = this.conn.CreateCommand(); command.CommandText = "INSERT INTO Items (FeedID, Title, Link, Description, PublishDate) "; command.CommandText += "VALUES (@feed, @title, @link, @desc, @date)"; command.Parameters.Add("@feed", SqlDbType.Int); command.Parameters.Add("@title", SqlDbType.NVarChar, 75); command.Parameters.Add("@link", SqlDbType.NVarChar, 300); command.Parameters.Add("@desc", SqlDbType.NVarChar, 350); command.Parameters.Add("@date", SqlDbType.DateTime); command.Parameters["@feed"].Value = article.Feed; comma ...Show All

• Aaron Leiby Can't uninstall or reinstall SQL Server 2005 Dev

  Long story short: Installed SQL Server 2005 Developers Edition along with Visual Studio 2005. Everything worked as it should. Then there was a problem installing .NET Framework 2.0 Security Update. Fixed that by uninstall and reinstall of .NET Framework 2.0. Now SQL Server does not work. So I figured uninstall/reinstall. Only problem is that it WILL NOT uninstall. I have tried to uninstall manually per KB article (9009967). That doesn't work either. The error info that I'm geting is: LinkID: 20476 Product Name: Microsoft SQL Server Product Version: 9.00.2047.00 Message source: setup.rll Message ID: 50000 EvtType: stateengine\resourcemodule.cpp@ScheduleActionAction@sqls::ResourceModule::LoadStringW@0x716 I ...Show All

• CalinMac T-SQL Badly needed

  To one of our sql server database Table A , we need to migrate data from another sql server database Table B . Assume there are two columns in a table namely OrderID and Comments . Here OrderID is a foreign key. And therefore, I can have any number of comments for a Particular OrderID. Thru a TSQL query, I wish to have all the Comments data beside the OrderID seperated by comma like Ord1 Comm1, Comm2, Comm3 Ord2 Comm5, Comm6. Comm7, Comm8, etc., This is just the thing we used to do for numeric columns using GROUP BY statement as SELECT ORDERID, SUM(ORDER_TOTAL) AS AMT FROM B GROUP BY ORDERID Want to know how to achieve similar effect with Varchar type of data. I'm currently using Cursor to concat, but it is taking long l ...Show All

• Adam23 SSIS vs. Excel's CSV parser

  Hi All, I’ve been battling with a client who’s supplied us with what they consider to be a legitimate CSV file. 1st off let me say that I understand that there’s no CSV “specification” per say, but here’s the situation regardless. The client has a test string in one of their fields that looks something like this: He said "STOP" so, of course he stopped The CSV best practice requires that you double quote, so a valid CSV filed would look like this: He said ""STOP"" so, of course he stopped Once this is placed into a comma delimited CSV it looks something like this "Col1","Col2" "He said ""STOP"" so, of course he stopped","value in col2" --------------- ...Show All

• Bill_W Distributed Transactions between SQL2005 and SQL2000

  Hi there, We have two servers, one (we'll call 'SERVERA') has SQL2005 running on it. The second (we'll call 'YELLOWSTEONE') is running both SQL2000 and SQL2005 on it. The SQL instances on YELLOWSTONE are 'YELLOWSTONE\SQL2000' and 'YELLOWSTONE\SQL2005'. As a linked server, I have an entry for YELLOWSTONE which then links to the SQL Server of YELLOWSTONE\SQL2000 on the server network name of YELLOWSTONE. By them selves they seem to run fine. However, if I have trigger that Runs on SERVERA to do a distributed transaction on 'YELLOWSTONE\SQL2000', I get the following error: OLE DB provider "SQLNCLI" for linked server "YELLOWSTONE" returned message "Login timeout expired". OLE DB provider "SQLNCLI&quo ...Show All

• MEder SQL2005 Management Studio malfunction altering user after (SQL2000) db attachment

  I have encountered a frustrating problem [bug ] in MS SQL Server 2005 Management Studio -. Attach a SQL 2000 database -. A user exists which I need to associate with a login. -. I create the login (same name as user) -. I edit user properties, but the Login field is disabled (along with all Username selections). -. I try deleting the user, cannot because user owns some db schema element (nothing appears under "Owned Schemas") -. I try changing the db_owner flag on the user, but when I click OK I receive the error: Login name must be specified. (SqlMangerUI) -. I checked the database properties->security, removed the user (it disappeared), hit okay, tried previous steps again without success. What to do for now Creating a diff ...Show All

• Alastair Q Issue Exporting Date format to a delimited file.

  In exporting from a OLEDB connection to a flat file. In the originating table the field for DOB is in a varchar(10) format ex. 01/17/2007. The flat file connection destination is setup as a DT_STR. When you look at the OLEDB connection table preview you see it as 01/17/2007. When it is export to the delimited <CR><LF> <|> pipe delimited the format looks like this 01/17/2007 00:00:00. The issue would be resolved with a right ragged fixed width file. But this is not the requirement for the project format fot the file. I have tried delete and recreating the connections, and even tried doing a data conversation from the OLEDB connection to a char(10). Also, thourgh the transformation services with out any luck. On the flat ...Show All

• gulpie for xml hierarchy

  Hi I have a table that looks like this declare @VC table ( V varchar(100), VC int, depth tinyint) insert into @VC values ( 'TN', 1, 1) insert into @VC values ( 'TN', 2, 2); and I have for xml query select V as @value, ( select VC as '@value' from @VC pe where pe.V = n.V for xml path ('Value'), root('Values'), type ) as ME from ( select distinct VC from @VC ) n for xml path ('Value'), root('Values') that gives me something like this <Values> <Value value="TN"> <ME> <Values> <Value value="1" /> <Value value="2" /> </Values> </ME> </Value> </Values> However I need to reorder the xml to look like this acco ...Show All