Search results for query: *

I have a table which has a primary key,this key although numeric is not auto increment but is unique, I need to convert this column to an autoincrement field, can some ome help me with the tsql to achieve this.

I have been tasked with the following: Add a button to excel that when pressed will export a subset of data to a new excel spreahseet. I know how to add a new toolbar and button to excel and even how to attach a macro to the button. My question is how do I store the said macro in such a way as...

Help! I have been given a vb6 codebase for an outlook addin and have to make some changes to it, can anyone tell me how to get the source code to run from outlook in order that i may debug and test the add-in, I have set the start up property to be outlook in the vbp properties debugging window...

Does anyone have a 'Hello World' application to write to a console window?

Does anyone have a 'Hello World' application to write to a console window?

I have a client pc which throws up this error when I try to instantiate a .net assembly via a vb6 application. the 'expose a com' check box is checked and the code all works fine on another client pc. the Constantrs module is simply a list on constants. Anybody got any ideas?

Sorry should be SQL 2000 to SQL 2005

Can anyone tell me if there is an easy way to do this as I have done it a few times and it has proved to be a headache on each occasion. This would make my life sooooooo muuuuch easier if there is a solution.

Thanks Harleyquinn I managed to work this out about 5 minutes after I posted the query, but you are spot on!.

Help, Can someone tell me how to iterate row the rows in a sheridain grid control? Otherwise, if I can find them, I shall have to hire the A team.

Thanks that is just what I needed.

Can anyone tell me if and how to deteect whom has executed some sql when the sql is executed from an application. The purpsose of this is to, using a trigger, update an audit file with whom has changed what in the db.

Magic thanks for your help.

Does anybody know how to display the execution plan in 2005 ??

Your right! I knew it was something simple!! Many thanks.

Con some clever sole point out the error in the following delete script please: delete from subscriptionmembers inner join contacts on Contacts.contactid = subscriptionmembers.contactid where contacts.categorycode in ('CPAT','NMP','PAT','DEN','PRAC','DOC','TEA') I get the error Msg 156...

Really stupid question i know but in vb6 Dim App As CRAXDRT.Application what is the equivient in vb.net?

my fault an being dim i get it now.

Exellen but does thisexample need the class or an instance of a class, the resone i ask is when i replace form1 with my object name the error type object not defined pops up.

Does any body know if, and how to, it is possible to iterate around the list of properties an Object may have. E.G if the object personal has three properties , Title, First name, Surname, is it possible to eamine each property and check its name then extract the value? I hope this makes sense.