Hi,

are you sure you have the appropriate rights to install on the network?

I remember having these problems. To install mdac you must be least local admin I think.

Cheers,

Frank

Hi,

I don't think the VB app "knows" anything about the trigger.

This is SQL Server internal. So the connection will likely not wait till the trigger is finished. If you...

Hi,

are you doing this within a transaction? If so, could it be that you need to reset the Err.Object to 0 before updating the table?

Cheers,

Frank

hi,

a good starting point is DBCC CHECKDB <db_name> Also take a look at DBCC in BOL.

Good luck

Cheers,

Frank

Hi,

why not use a combination of DATEPART(quarter, <your_field>), and sum

like

SELECT DATEPART(quarter, period) AS Quartal, Sum(composite) as Summe

FROM ....

GROUP BY DATEPART(quarter, period)

ORDER BY ...

This assumes that period is a...

If you back up your log-files, maybe you can have a look at the size of the files.

I back up log files each hour. If nothing happens to the db...

an identity field seems to be always a good choice (at least as primary key).

do you want to select the last 10% records added to the table. maybe...

Hi,

there are many pros and cons about storing binary data in a db vs. using the filesystem and I have seen on other forums quite philosophical discussions about this. I...

Take a look at 'xp_cmdshell' in BOL This should be what you need

Cheers,

Frank

It is getting REALLY interesting, when you're playing with DDE and realtime quotes and calculations and databases }:-) You can get very easily a server down to its knees. That's...

Hi,

I'm working as an asset manager for an insurance company. We're doing a lot of performance calculations and from my experience this is a classical case for a spreadsheet application....

We have about 50 GB on a RAID 5. No problem so far

Cheers,

Frank

I think, it only makes sense when you place the secondary files on different harddrives to improve performance by reducing reads/writes

Cheers,

Frank

Sorry, if I expressed myself unclear. The following is an excerpt from BOL

...Two special tables are used in trigger statements: the deleted table and the inserted table. Microsoft® SQL Server™...

I'm also using triggers for insert and update (delete is not permitted) to audit changes to certain tables. But I'm using the inserted and deleted Tables. Are there any advantages...