In 7.0 and 2000 you can right click the database in Enterprise Manager, select properties and there is a datafile tab and trans log tab. I hope this is the...

Hi, I'm not sure if this would correct the problem but you might just need to increase you tran log, what size is it at now?

yes, thanks it's nice to know i can get back some of that space. Thanks Again

E...

No I did not try that but would it not produce the same (non-logged updates) error no matter how I attempt to backup the tranlog?

E...

Do you know if I would be able to Cast or Convert to a different data type to store the image to a variable and then back to an image...

That is ok, when I ran SP3 it did not upgrade the MDAC version.

Thanks

Yes, as far as I know what ever machine (Server or Work Station) you want to use SQL Mail on, will need the database server installed and the profile you...

Need more info. Did you set up a mail profile on the machine you want to use SQL Mail on?

Yes, I guess that would make sense. There is also an error log file that you can view using note pad. it will be located in your MSSQL...

Did you check the SQL logs located under 'management' in Enterprise Manager? You may be able to idenify what happened by looking at what SQL Server logged before and...

Thanks the component checker works well. Do you happen to know if SP3 for SQL 7.0 upgradeds the MDAC version when installed?

Thanks

Hi, I know that it is one of my other servers that is causing the locking because of the hostname and loginame. I have also found out the following...

Unfortunately once the select is done the 2 rows have to be updated.

So, just to make sure I understand this. The transaction that has the table lock with intent...

quote:

---

quote:

---

An intent lock indicates that SQL Server wants to acquire a shared or exclusive...

quote:

---

Are you sure your process is failing over to the correct master db?

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

---