Hi,

You're right Kenneth, as regarding SQL Server, and maybe i was too nonspecific, but in Oracle and DB2 for example the ACTUAL TIME of (insert/update) for the record is stored...

Hi,

If I'm not mistaken, one reason (in addition to those mentioned above) for keeping timestamp values could be to know (on database level, not application level) the time of the last transaction...

Hi,

It looks like some gentlemen when they write replys they base it only on the last post in the forum.

I'd say that for someone to post a reply he...

Db does not have any long running transactions, these would have been immediatly detected and rolledback by the application, anyhow checked and found none

The funny thing now is...

Steve,

There is no possibility of appending, each file has a distinct name (db_sat, db_sun, ...)

they're circulated weekly, but prev one is deleted before new one is created...

Thnak you sir,

but today :

my DB is 10 GB

DB backup is 12.7 GB

based on what u say explain how backup was 7 GB for...

Hi,

That is EXACTLY what I've been doing, daily full backup, log backup every 2h.

The issue is that DB backup is unreasonably growing.

Again, DB allocated size =...

The backup file contains ONLY a user database, no other databases are backed to the same file

This database contains only 2 files, one data, and one log

Sorry for the late reply

It's a new file every day, no appending

Trans log allocated size = 3 GB

DB actual size = 2.3 GB

So if all...

Hi,

1. Actual DB size = 2.3 GB (space allocated = 10 GB)

2. The migration from Sybase to SQL Serv was OK without any problems or "glitches" from all aspects...

mstream is an ado stream,

rsdocument is ??

how declared ??

how linked to a table, coumn ??

next,

how to read an image data type (blob):

1. Into a file

2. Into memory

1. I'm not sure it's a server, I think "in my Windows 2000 Prof. machine" was mentioned.

2. Deleting the physical folder is not enough, registry entries created for this aborted...

Yes sir, I think Jonathan's reply was clear, unambiguous, and to the point, namely:-

"You are not missing something. SQL Serv doesn't allow more than one column to be referenced...

quote:

---

not as a table level check

---

I'm migrating a DB from Sybase, in Sybase Adaptive Server,...

quote:

---

I've found that this process can be problematic. Usually there is some rights issue. If you double click the line wiht the...