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...

also - set the file to read only - then see what complains!!

have you looked in the sql agent - jobs section - are there any jobs you don't recognise??

also this backup could have been added as a second step...

according to lots of articles on micorosoft.com xp sp2 disables ports 1433 and 1434 and 455(TCP and UDP and Named pipes) by default

you can re-enable these in the XP security...

debugging oracle syntax error's isn't something most SQL server DBAs could do.

you could try lazydba.com - they have sections for oracle & SQL problems

if you're running this on an oracle server then you need to post it on an oracle forum .

use a dts package with field mapping