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

i'd use

set nocount on

Declare @strSQL as varchar(100)

Declare @Out as Integer

set @strSQL='Set @out=(select Count(*) from ' + @Table+')'

exec sp_executesql @strsql

select @out

it's just the next revision number (like 3.1)

you can find sql server service pack 3a on http://www.micorosft.com/sql

service pack 3 and service pack 3a both report the version of

8.00.760

although 3a includes the SQL slammer protection. Both of...

have a look at

http://www.microsoft.com/sql/reporting/productinfo/RS_AuthoringDemo.asp

you will see how it's done

but yes, a new project type is available - SQL report

are you planning to write all of the reports yourself? that's...