Hi Chris,

thanx for your answer helped me a lot.

regards,

bryan

Hi guys,

thanx for all your response, but i noticed that i have not made it clear enough. below you see two tables. table dummy is the situation

from where i want...

Hi

Thanks for the answer but i do know about this feauture,

But this is not what i am looking for. The table where i want to

Insert the records in should finally...

Hi,

thanx for the quick answer. the last one did the trick. i know you should use the right data type in the first place,

but when taking over an existing environment...

solved the problem myselve.

bryan

Hi ,

Thanks for the reply. I already had something like that:

select convert(char(11), columname,105) from tablename.

but thank anyway for mentioning it.

Bryan

Hi,

thanks both of you for the reply. i'll just do that as you suggested.

bryan

Thanks for the quick answer.

now i've tried this but i get the following error:

Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

This...

No not using sp_.....

My problem is not solved yet. i hope someone can help me on this one. maybe it's a user issue??

so normally when you create a stored procedure in the master...

the name is random. not a specific name op this SP. let's call it test.

Hi Adi,

thanks that dit it for me. to bad that just simply granting create table does not work. i am used to work with oracle , where this works much...

Hi ,

Could you be more specific?? I think you are talking about a windows clustered environment? If so maybe this link can be of any assistance:

http://www.eggheadcafe.com/software/aspnet/30492326/long-failover-time.aspx

kind regards,

Bryan

Hi,

Before i gave the user this permission i've tested several issues regarding the linked server. Like dropping, renaming etc. This all was not possible, so therefore decided that this was...

Thanks for the hint

ETA: Estimated time of arrival