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

Thanks for the reference!!!!!

Steve Jones

steve@dkranch.net

Just install it and reboot. the listener will pick it up on a reboot.

Steve Jones

steve@dkranch.net

Start with backups and restores.

Then it depends on what you are doing. What is your environment, what are you trying to support?

Steve Jones

steve@dkranch.net

Good points and thanks for the update.

BTW, wouldn't Oracle's RAW file be the same as the file used by SQL Server? all tables in SQL Server are contained within a...

Sorry, didn't read the timeout error. My guess is that there is a lock being held for some reason. Does the backup complete with no errors?

run sp_lock before and after...

Just tested with Pubs and it worked. Specify the new path on the second tab.

Steve Jones

steve@dkranch.net

Thanks for the followup and good work.

Steve Jones

steve@dkranch.net

Never seen anything like this. Are you r users members of some role? Have you checked the error logs for SQL and BakcupExec?

does this happen with a normal SQL backup...

Can you be more specific? There are lots of things that you need to do if you are adminning a server. BTW, this should be posted in the Admin forum.

I'd...

I'd recommend UDFs in SQL 2000 and a temp table in earlier versions.

Steve Jones

steve@dkranch.net

Send him this link. Tell him you "found it" during research.

Steve Jones

steve@dkranch.net

Thanks for the feedback. It appears that your Access database uses a different collation (kind of like language) than SQL.

Create a temp table and insert the data, then move it...