Hi,

thanks for reply. I read the article, corrected the index on the table and it works.

Cheers,

Frank

Sorry, there is no space. I'll start a new topic on this

Cheers,

Frank

Yes, that's what I mean.

I do a full backup twice a day with log backup every hour between 8 am and 8pm

Do you mean BACKUP LOG instead of BACKUP...

Hi,

finally we did it 🙂

Now my question is why I receive this error

Server: Msg 8623, Level 16, State 2, Line 5 error

Translation from German to English (..Cannot create Execution plan)....

Hi John,

well, now I'm a bit confused. I'm trying to run this query

INSERT INTO tblhbest1 (UnternehmenID, Handelsobjekt) SELECT UnternehmenID, Handelsobjekt FROM view1

and receive a Server: Msg 8623, Level...

I think we're moving closer to success.

Taken from BOL

...The select list of the subquery must match the column list of the INSERT statement. If no column list is specified,...

You can easily check this, if you create a new db. By default there is automatically grow checked and unrestricted. If you don't change default initial size, it is set...

Hi,

sorry, it took a while to understand what you want to do.

I assume you're redesigning? Or is this used for frequent import?

Well, of course you can declare a cursor,...

Hi,

there are plenty of ways to do this (T-SQL, ADO....).

Could you provide more informations, e.g. table structures?

Cheers,

Frank

Here we go

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=659&lngWId=5

I haven't tried this, but who knows...

Good luck!

Cheers,

Frank

Hi,

just a thought, though also messy.

Why don't you transpose columns and rows, then check for isnull?

I have seen a script on planet-sourcecode that promised to transpose a table. If you...

hmmmm...

tempdb size seems ok (mine is right now about 8MB with no problems at all). temp db and its log can grow by 10 percent.

can your transaction log also grow...

HI,

in Enterprise Manager right click on the database, choose properties, select the data files tab and see if the automatically grow file option is checked. You might then specify...

Hi,

SSPI stands for Security Support Provider Interface. When you connect to SQL Server using NT authentication this interface is used. From time to time I also get this error, but...

Hi Andy,

this assumes you're doing this within a transaction in vb, doesn't it?

Cheers,

Frank