glad this was helpful for you , Leena; I've never found a practical use for it so far, but it is good to know; of course there is always more...

eric could it have to do with disk permissions?

for example, on my win7 laptop, i cannot write to c:\mydb.sdf, but i have no problem writing to C:\Program Files\Microsoft SQL...

would that mean you have to add a dml trace to the server so you can capture the user/application name/hostname and other information, i guess to complement the changes CDC...

no, sorry DR; a function cannot call a stored procedure, only extended stored procedures;

the reason is a function is not allowed to affect objects, and since a stored procedure could...

i think you'll have to use MAX(*) functions and a group by statement:

SELECT

Dt ,

MAX(Wire) AS Wire,

MAX(Convergys) As Convergys

FROM YourTable

Group By Dt

malware? it's just my crappy dev site that holds all my ugly screenshots and script examples; i don't see anything wrong, can you pm me whatever you are seeing?

like Wayne said, there should be an event for OnFormClose you cna use to prevent the form from being destroyed if a process has not completed; also, you should also...

Gaby if you are inserting single rows at a time, even if there are lots of them per second, scop-identity() should work fine.

if you have a single statement that is...

look at the error you are getting; it should be very obvious;

if i used your function for a table named "Customers" and a WHERE statement that was "CustomerName LIKE 'c%'

what...

ricky i'm just confirming what you are seeing; for me so far, if the try catch is in a transaction or using a transaction, i get the same failure; I...

In SQL you have to use dynamic sql and the EXEC(EXECUTE) statement.

Oracle is the same, but you would use EXECUTE IMMEDIATE,

ie execute immediate 'drop table TEMPTBL';

it...

raju you are very welcome; you should get some other great feedback as other posters get their coffee and hit this thread as well.

ahh gotcha Satish; a zip+4 database is a little different. i think the issue becomes "that's my proprietary data" that if someone cloned, they could build their own app for...

not enough info i think Satish; still a lot of variables out there;

your database is 30 gig, but if i were a client of yours, how much of that data...

raju i can only tell you my experiences and the way we do things at my shop; you can review them and see what you like, since there's no real...