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

yeah - a bit limited though - your permissions are only for rows you created - what if you want to mod rows that belong to a user group...

there's nothing native to sql2000 for this.

esentially it's going to be down to something you implement in each view or table.

UPDATE contacts INNER JOIN contacts ON users.contactidalias = contacts.contactid SET contacts.webuserid=users.id

i've foud the easiest way to do this is create a user-row lookup table - where you match usernames and criteria.

then create a view in sql server and only present...

you could set up your oracle server as a linked server in SQL

you can then create a view in your SQL server that does the join for you.

ou...

try idera's SQL siagnostic and SQL schedule

or you can purchase the SQL suite (all of their tools)

it's a little pricey, but download the trial of SQL diag and you'll see...

I think this would have to be a natural progression from the existing IDLE status jobs - basically set an ON point and an OFF point for your resources (monitor...

oh yes, i just realised - @out is out of scope in the new sql execution -

i've just toyed with

set @out=(exec sp_executesql @strsql) but i'm struggling here

i...

the default database? what do you mean by this?

each user has his own default database, but this is purely for those lazy coders that don't specify the database name in...