It's a file that can be found in your folders. Since you don't want to create a copy, design the directory of this file such that you can include it in both of your applications!

Hi, I have a list of table that I need to make them available for auditing by using that particular procedure. I had in mind to call that procedure in a cursor which identifies the table names, builds the script for that procedure by passing the table name and the source to the procedure and executes it. This procedure will be repeated for all the tables. This will avoid hard coding the procedure for all the tables (which I have over 150). Yes yu're right they should be as listed below; DECLARE Alter_tables_cursor CURSOR FAST_FORWARD FOR select table_name from information_schema.tables where table_name<>'dtProperties' and table_type<>'VIEW' OPEN Alter_tables_cursor DECLARE @tablename sysname FETCH NEXT FROM Alter_tables_cursor INTO @tablename WHILE ( @@FETCH_STATUS = 0 ) BEGIN EXECUTE 'sys.sp\_cdc\_enable\_table @source\_schema = N''dbo'', @source\_name = N''TBL\_ACTIVITY\_ACT'', @role\_name = NULL' FETCH NEXT FROM Alter\_tables\_cursor INTO @tablename END DEALLOCATE Alter_tables_cursor Thanks for your reply.

How many space is there left on your harddisk? Did you check whether you have enough Virtual Memory left? I are Troll :)

Hi. Since it seems like this type of questions comes up every now and then. So, here's a quick list of other resources to look at: For something to use in the lab, dataq is one of the main companies that businesses go to for low-cost/mid-range solutions. A very cheap whay to get a few I/O pins and have it in a packaged form is: DI-158 Starter Kit Low-Cost USB Data Acquisition Device http://www.dataq.com/products/startkit/di158.htm[^] * Low-cost, compact, USB data acquisition starter kit. * Record data with 12 bits of measurement accuracy at rates up to 14,400 samples/second. WinDaq High Speed Acquisition software required for recording rates over 240Hz. * Convenient USB interface. * Four ±10V or optional ±64V fixed differential inputs. * Four digital bits for general purpose I/O. * Two 0V to 1.25V digital to analog output ports. Another pre-built board to consider is: http://www.xdimax.com/sub20/sub20.html[^] SUB-20 Multi Interface USB Adapter USB to I2C, SPI, GPIO, RS232, RS485, Ir, LCD * Full Interface Crosspoint - converts any to any * USB to I2C Master and I2C Slave, USB to SMBus * Up to 8MHz USB to SPI Master and SPI Slave * USB to GPIO - 32 GPIO, PWM Outputs * USB to ADC - 8 Analog Inputs (A/D Converters) * USB to RS232, USB to RS485, USB to ModBus * USB to IR (USB to Infrared) Adapter * 8x2 LCD, Leds, Push Buttons * Field upgradable and customizable * NI LabVIEW Support If this is for an end product or for a board, and you want to use Ethernet for connectivity, then Lantronix has a number of good solutions: Good solution for a board: XChip Direct SoC http://www.lantronix.com/device-networking/embedded-device-servers/xchip.html[^] Embedded Device Gateway SoC Co-Processor XChip * Connects to host microcontroller for serial to Ethernet (LAN) applications * Robust networking and applications firmware included – no coding required; zero royalty licensing agreement * Integrated 10-100 MAC/PHY; 256K SRAM; up to 230 Kbps data rate * Compact 12mm x

Do you find any difficulties to use Add() Function, cmd.Parameters.Add("@fromDate", SqlDbType.System.Data.SqlDbType.Date) cmd.Parameters.Item(0).Value = todayDate; Using Add() function you can avoid datatype conflicts here. Education is not a way to escape poverty — it is a way of fighting it.

I think that solved the problem. I stil have to takle the performance issue, but THANKS alot for your help

ALTER TABLE MyCustomers ALTER COLUMN CustId IDENTITY (100,1); Education is not a way to escape poverty — it is a way of fighting it.

Save this as a query, call it something like qryMaxLogID SELECT MAX(LOGID) as MaxLogID, UserID FROM CHECKINOUT group by UserID where CHECKTYPE = 'I' Order by UserID; Then, reference it in your existing query like this: "select USERINFO.Name,DEPARTMENTS.DEPTNAME, main.CHECKTIME FROM (DEPARTMENTS RIGHT JOIN USERINFO ON DEPARTMENTS.DEPTID = USERINFO.DEFAULTDEPTID) inner join qryMaxLogID on userinfo.UserID = qryMaxLogID.UserID inner join INNER JOIN CHECKINOUT as main ON qryMaxLogID.MaxLogID = main.LogID;" I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

There is a stored procedure available in the System Stored Procedures in Sql Server. It is called sp_rename It accepts 3 parameters viz. @objname nvarchar(1035), -- up to 4-part "old" name @newname sysname, -- one-part new name @objtype varchar(13) = null -- identifying the name For renaming a column, execute the following EXEC sp_rename @objname= 'TABLE_NAME.OLD_COLUMN_NAME', @newname = 'NEW_COLUMN_NAME', @objtype = 'COLUMN' N.B.~ For your reference, the @objecttype correspond to system tables which track of the folowing type: 'column' 'database' 'index' 'object' 'userdatatype' Hope this helps Vote me :) Niladri Biswas

Glad to be of service.

Hi, on top of what the other chaps already said: 1. how did you establish there are backslashes present? don't trust the Visual Studio watch windows, the only thing you should really trust is your own code: try Console.WriteLine(cmdText) 2. if SENSORID is a numeric field, the values don't need any double quotes; with quotes you turn them into strings. :) Luc Pattyn [Forum Guidelines] [My Articles] DISCLAIMER: this message may have been modified by others; it may no longer reflect what I intended, and may contain bad advice; use at your own risk and with extreme care. modified on Friday, June 12, 2009 10:01 AM

What do you mean, "the selected value remains the same even though I change the selection"? You're original question was how to work around the event firing during initialization. Now, however, it seems the problem is something else. If you want help around here state the problem clearly. Read the first post, How to get an answer to your question. only two letters away from being an asset

Did you check Microsoft KB? If not, maybe you have one of their described scenarios: Selected collating sequence not supported by the operating system[^]

Post the code. Either you love IT or leave IT...

Have a look at the following post[^]. Maybe this will give you some insight into a solution. I think it might be something to with the BETWEEN statement. Excellence is doing ordinary things extraordinarily well.

Here I know nothing , I know nothing ...

Quoted from this[^] website; xp_logevent {error_number, 'message'} [, 'severity'] :) I are troll :)

Thanks again for your help. I will try to follow the steps that you have given me. thanks again thats already a great start.

http://forums.devshed.com/ms-sql-development-95/how-to-get-all-the-constraints-on-a-table-372351.html[^] Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Take a look into the information schema views (under system views in Management Studio) INFORMATION_SCHEMA.COLUMNS is the one you want Never underestimate the power of human stupidity RAH