Service Pack 4 fails to install if you LOG P.I. installed.

the replout.sql script fails.

in order to solve the problem stop the Log PI services.

in the meantime can i suggest a very easy alternative

i use a program called blat.exe which is an smtp mail client.

if you want to send an email (and...

do you have some examples?

have previously seen KB articles about this, relating to the exchange server being unavailable for the address book lookup.

i'd definatley recommend making sure your emails specify the full address...

what version of outlook do you have installed on the SQL server?

if i understand correctly your form may be doing something along the lines of

dim db as database

set db=currentdb()

dim qdef as new querydef

set qd=db.querydefs("myquery")

qdef.sql="create table dbo.mytable.......blah blah....."

you can then simply...

Please also note that the role is customer facing and would require regular visits to sites across the UK (1-2 days per week)

how about creating second filegroup and moving text and indexes to the new filegroup -

performance would be up(as one set of disks scan indexes, the other scans the...

we've also come across this problem at a site we visited recently

we tracked this back to the following

http://support.microsoft.com/default.aspx?scid=kb;en-us;328197

the exhange server became unavailable (for a directory lookup) as sql agent...

I've had the same problem, but not from a java app.

in my case this was down to the ODBC configuration overiding the default language setting for your user login.

check your...

here is the post from BOL

WITH CHECK | WITH NOCHECK

Specifies whether the data in the table is or is not validated against a newly added or re-enabled FOREIGN KEY or...

not sure about in sql 6.5 but in 7 and 200 you can use the ISQLW.exe to pass sql statements to SQL server from a dos window. you can also...

how about using an alert.

you could use the alert to add rows to a table when the raiserror generated by a failed insert or update is executed.

what about referential integrity - primary key foreign key relationships.

if you build these relationships on unique indexes (not keys) then products like MSACCESS would not be able to update...

you could try the following in your master,msdb database and vendmax databases

select sysobjects.name,syscoments.* from syscomments,sysobjects where syscomments.text like '%BACKUP DATABASE%' and sysobjects.id=syscomments.id

this will list all f the stored procedures that...