I use #1, but like this:

declare @err int

select @err = 0

-- do something

insert.....

if @@error <> 0

select @err = -1

-- do something else

update.....

if @@error <> 0

...

You can also CAST columns to match each other.

Steve Jones

steve@dkranch.net

Can't restrict sa, similar to the inability of restricting the domain admin. what is missing, however, is the auditing ability (or the take ownership tracking) in SQL. I've seen this...

You are welcome and thanks a bunch for the followup. Hopefully this will help someone else.

Steve Jones

steve@dkranch.net

3M rows!!! Yikes!!!!, could probably rewrite and get much better performance.

My suspicion (and that's all it is) is that the fibers are making a difference. Also, check...

A good career move for you.

Please come back and ask more questions, we love to help!!!!!!

(also visit some of our sponsors

Steve Jones

steve@dkranch.net

You should be able to just place the data files on the SAN and set the proper pathing (if the SAN can be addressed as a \\server\share.

As far as something...

I don't think they do, but you'd have to try it.

Steve Jones

steve@dkranch.net

Can you post some code?

Steve Jones

steve@dkranch.net

That's a good point.

check all db settings before backup and after. See if something changed.

Steve Jones

steve@dkranch.net

have you tested this at all? Or is it a "hunch"?

Steve Jones

steve@dkranch.net

Scooter, a really interesting question and one I will have to do some followup on.

I checked Inside SQL Server 2000, no mention.

Checking BOL and Technet also turned up nothing, same...

temp tables are created using the same create table syntax, but prefixing the name with #

CREATE TABLE #MyTemp ( ref int, design int, ...)

insert #MyTemp

(ref,design,codigo,familia,stock,pv1,ivaincl,tabiva,pcusto,usr3,usr4,usr1,usr2,ststamp)

select ref,DESIGN,codigo,familia,stock,pv1,ivaincl,tabiva,pcusto,usr3,usr4,usr1,usr2,(select ref as ststamp) from...

A return value is returned as in from a function. If you want it to print, then use SELECT or PRINT.

Steve Jones

steve@dkranch.net

http://www.microsoft.com/traincert/mcp/mcdba/default.asp

Books will vary by exam. see our products section.

Steve Jones

steve@dkranch.net