You can either change the owner of the object to you user. Create a role and add that user to it and change the owner of the object to role....

For the complete story look up "I/O Architecture" in BOL and the associated pages.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

You could do this with a piece of SQL

i.e.

UPDATE t2

SET t2.col1 = t1.col1

FROM table2 t2

JOIN table1 t1 on t2.pk = t1.pk

WHERE t1.col1 <> t2.col1

You will need to use ISNULL...

What sort of task are you using. Try looking on http://www.sqldts.com

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

It always seems to be accounts. You have to be logged on as user account that as permissions to create the debugger on the server, the sql server needs to...

identity_insert allows you to specify the identity value yourself rather than have it generated for you, i.e if your excel spreadsheet has values for the column

Simon Sabin

Co-author of SQL Server...

Further to that you shouldpass your variables in using sp_executesql

i.e

declare @sql nvarchar(100)

set @sql = 'UPDATE tablename SET ' + @inputvar + '= @somevalue

WHERE condition'

exec sp_executesql @sql, N'@somevalue int', @somevalue

This ensures...

I agree.

Essentially if you want to know which is better you need to define what you need the db to do and do lots posting. You also have to consider...

You can also write this as

select claim_number

from history h

left join member m on m.member_id = h.member_id

where plan_id='MTA' and

AND m.member_id is null

if member_id is the pk of member.

Generally sub...

You cannot just issue an alter table statement. You can change the filegroup in the enterprise manager, right click on the table and select design table.

This can do the change...

You can set this in the connection string use the APP keyword i.e

"DRIVER=MSDQSQL;SERVER=(local);UID=sa;PWD=;APP=My application"

Have a look at SQLDriverConnect in BOL

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

sqldts.com has a page that details the options

http://www.sqldts.com/default.aspx?6,105,204,0,1

You could just backup and restore msdb, this should copy all jobs, maintenance plans and dts packages. This might be a problem if...

Usin SET STATISTICS IO ON or selecting this option in the options of Query analyser. Shows what how many reads are made for each table, from cache and disk

Simon Sabin

Co-author...

IO is in terms of pages which in SQL 2000 are 8k in size.

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

If you are using SQL 7 and triggers be careful, as you the identity gets over written

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088