Answer Questions

• e-wrench Triggers

  Hi, i an new here. I just started with Sql Server 2005 Express. But my problem is not in technical issues, but programming. Now, to problem. I have few tables, Meas, Analog, Discrete, Acc and Terminal. Meas is main, have some field of it's own, one primary index key, and on foreign key. Foreign key is coming from Terminal table. Terminal table is stand alone, cause it has no other connections to any other table in this model. Analog, Discrete ...Show All

• DaveDonaldson Process blocking itself since SP4

  Hi, Since installing SP4 we seem to encounter issues where a process seems to block itself. Has anyone seen this issue. Is this a feature Thanks, Dave Please refer to the following for more details. This may be the reason The original posting can be found in many places, for example: http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server/23496/SP4-reports-queries-blocking-on-themselves There is also a KB article on this: http: ...Show All

• CraigLee Another Stored Procedure Question...

  Hi, Is it possible whithin a Stored Procedure send the table name as a parameter And some Columns to Ex.: CREATE Procedure Xpto @TableName as @ColumnName as @SomeValue as nvarchar(10) AS SELECT * FROM @TableName WHERE @ColumnName = @SomeValue Thanks JPP Hello... I would not use a table to hold values like this... Those information is already in the DB and there is no need to denormalize it. If there are ...Show All

• jla6653 Combining text data rows

  I am working with a database derived from text documents. One of the tables (TEXT001) contains the text of the documents with each paragraph of each document assigned to its own row with a paragraph number in a SectionNo column. I want the entire text of each document in a single row with its own unique number (so that I can do a full text search with SQL Server 2005 that will search and return the entire document as a result). How do I comb ...Show All

• Andrej Kasnik Template Parameters Dialog Box Not appearing(Stored Procedures)

  Hi,    While i am creating a new stored procedure Template parameters dialog box is not appearing even after pressing (Ctrl-Shift-M) . Is there any alternative way to do that. Please help me. Make sure the query window has focus, then try Query > Specify Values for Template Parameters... in the main menu. Thanks It worked. ...Show All

• NopV How to not send subscription report if no data

  I have a report that may or may not have data. I have a subscription setup for this report. The subscription has a defined To list. I would like to NOT send the report if there is no data on the report. I did this in SQL 2000 by raising an error from the stored procedure if there was no data. However, that approach does not seem to work with 2005. Is there another way to accomplish this It shouldn't have worke ...Show All

• Sid Sidhartha Managed index in Fuzzy Lookup Error

  If we run the package with fuzzy lookup without selecting the "manage index" option it runs great and select the data and inserts data within the table as expected. If we run the sam package after selecting the option for "manage index" it gives error: Error: 0xC0202009 at Data Flow Task, Composite Lookup [15209]: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult ...Show All

• Ronald S Calling Visual Foxpro 7 COM

  Dear Experts, We are creating instances of COM Objects written in Visual FoxPro 7 in our SQL Server 2005 stored procedures. The problem is that VFP Automation Manager which shows number of connections to number of objects is showing 3 connections to 3 objects(instead 1 to 1). We are releasing the object in SQL Server 2005 using the sp_OADestroy @Object but the Automation Manager leaves 1 connection to 1 object. The Automation manager co ...Show All

• domls Database Mirroring, client connections all ODBC so what methods are recommended?

  As stated in the subject I have a situation where if database mirroring is employed for either manual or automatic failover, all the client (including web connections) connections use ODBC not ADO, or OLEDB etc... so what methods are recommended Client side redirect is not available so I could not employe the "Data Source =A; Failover Partner=B..." option. Right now the method employed (pre database mirroring and basically employing ...Show All

• wwwalrus OLAP Data Distribution

  Hi Guys, I'm having a bottleneck with my RAM due to large OLAP data. Disregarding additional memory, I want to distribute the OLAP data to different disk so that Disk que will be distributed, in these way it can lessen the bottleneck. Is there a way to do this thanks... thanks... For AS2K you can move the data folder to a different drive and folder - but e ...Show All

• Snoo68 Converting a parent-child table into a genrational table / text file

  I need to convert a parent - child table into another table or a text file containing in a generational format. eg. child / parent / grand parent / great grand parent / .... Does anyone have a stored procedure of code to do this I'm working with a dimension having 250,000 + members, writing code is fast enough for much smaller hierarchies but with a dimension this size we need something fast. Thank you Hi De ...Show All

• 2005User How can we improve the cover rate of the model?

  Hi, all here, I found that in my case when I trained the data mining models, the model cover rate is very low (in my case, the train data set has 82 rows but the case occuring in the models I trained is only 25). How can I improve the cover rate to improve the quality of the models (if it is possible in SQL Server 2005) I am using SQL Server 2005. Cheers. Hi, yes. my training data set is quite small which is some university marks data ...Show All

• Dolphins XML source

  I used a URL to xml feed as source and it worked great. A nother URL I visit requires me to add the lastvisited time to the URL. Any suggestions how to do this in SSIS (Assume I can select time lastvisited from database but how do I add it to the url and make it execute every 5 min for example) Regards, Throstur I'm assuming the URL is in the connection string of an http connection manager, is that c ...Show All

• atimsa I am practicing by building a PM Online App

  In my Project table. I have a column called projSeqNum (Project Sequence Number) I was with a fellow techie -data modeler- and I think it was just placed with an int data type. I think a 4 length. My question is what would be the correct data type here. There could be 100's of thousands of unique Project ID's so I need something sturdy but not overboard. Any ideas Should I use a varchar data type ...Show All

• Naemoor Exporting Data from Database to a csv file

  Hi, How do I export data from my database table into a Comma separated value file format. I am using SQL Server 2005 with vb.net Thanks Hi Greg, Thank you for the reply,I am writing a program in VB Express (SQL server express 2005) and I have to do it through coding...I tried data reader writer.writeline but it didn't work out... Do you have an idea how can I do it using ADO or BCP but throu ...Show All