Hi David,

Apparently MySQL4 will have these features built in anyway and will include stored procedures.

Sorry, not until Version 5. Also triggers.

Cheers,

Frank

thanks antares686,

kinda stupid today. I forgot that I'm already registered with codeguru. See you on that lists

Cheers,

Frank

Hi,

can you provide more information on what you are doing? What are you trying to add. How many records are in the table? ...

Cheers,

Frank

Hi,

I don't know if it is possible to restrict the registration of SQL Servers in EM. But there is another thing you should keep in mind. Many developers are at...

Hi drjones23,

what I can't understand is you say that this data is your corporate financial data. This is a) quite sensitive data and b) mission critical data. In this case...

Hi,

here in the office we strictly use MS products. That's management decision and it's ok for me. I like Access as a frontend to SQL Server, because you can do...

Hi,

I use triggers to monitor data changes in some tables.

What actually happens in an update is a delete and an insert operation. SQL Server maintains therefore two special tables...

If you're looking for open source you might take a look at http://www.sapdb.org. To my knowledge it powers all? SAP solutions.

Cheers,

Frank

Hi, matt1,

could it be you've started two topic on this in different categories?

Cheers,

Frank

Hi,

if you just want to place a 4 as first digit , you can use charindex to determine at which place the '.' is and then put a new string...

Oops,

should have been reading more carefully. Now I got it, but don't have an answer.

Cheers,

Frank

Hi,

all you need is an image data field in your table and, case you're doing this with a vb derivat some experience with the ADO Stram Object. something like this

Dim...

Hi,

well in EM goto Security -> Logins.

Select your user -> right-click -> properties.

Select 'Database Access' Tab.

Check 'Permit' and 'db_owner' for each DB.

It's a stupid activity

Hi,

have you tried the fully qualified syntax 'master.dbo.sysfiles' ?

Cheers,

Frank

in addition to my previous post. On the General tab you can simply overwrite the value in the 'Restore as database' combo. You shouldn't forget this as well 🙂

Cheers,

Frank