Thanks !! i wasnt aware the filters in a server side trace was applied only after the info was collected. I suggested the server side trace mainly to avoid the...

faster simpler better coding relies on moving business logic to the application layer. This is proven in many SOA implementations. The DB should stick to simple crud operations. The stored...

the remaining diff backups on sunday went thru fine so i guess this is a one off , most probably something interefered with the backup operation. like mentioned ealrier...

it would be a good idea to identify what events your trying to capture and then look up an appropriate DMV.

Else if you right click the extended event in sql...

Are you trying to process the cube remotely?

The points above are pretty comprehensive and from real world experience i know that most developers will pick a few favorite points from here and implement them. One additional point...

Since the touchscreens will have thier own local copy of sql express , i would suggest that you build the system to sync on demand instead of creating a replication...

You can use the data collector as template of how to go about setting up this tool. Mainly there is a datawarehouse , sql agents and underlying extended events.

SELECT a.* FROM OPENROWSET( BULK 'c:\test\values.txt', FORMATFILE = 'c:\test\values.fmt') AS a;

your looking for something like this , additional details available in BOL

edit :- sorry didnt read the question properly ,...

Just adding my two cents , you could simply create the application using SSRS which will save a lot of time with setting it up , simply write your queries...

Could I ask why your setting up email in the database ?

Idea lly you should try and use some application code, esp with sql 2000 there are too many loop...

Just so you know , the access approach works fine when ur dealing with few touchscreen app, once the number of users increase the SSIS implementation is going to be...

the way i see it there is aprimary key if you split the header from the lists

for examples all rows which start with H would go to a table Header...

http://www.sqlservercentral.com/Forums/Topic1041144-391-1.aspx

http://msdn.microsoft.com/en-us/library/cc645993.aspx

express doesnt have SSAS in it