Viewing 15 posts - 38,581 through 38,595 (of 39,456 total)
December 18, 2001 at 4:47 pm
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...
December 18, 2001 at 4:09 pm
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...
December 18, 2001 at 3:07 pm
A return value is returned as in from a function. If you want it to print, then use SELECT or PRINT.
Steve Jones
December 18, 2001 at 3:04 pm
http://www.microsoft.com/traincert/mcp/mcdba/default.asp
Books will vary by exam. see our products section.
Steve Jones
December 18, 2001 at 11:21 am
December 18, 2001 at 11:19 am
December 18, 2001 at 11:18 am
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
December 18, 2001 at 10:32 am
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...
December 18, 2001 at 10:31 am
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...
December 18, 2001 at 10:21 am
Just tested with Pubs and it worked. Specify the new path on the second tab.
Steve Jones
December 18, 2001 at 10:20 am
December 18, 2001 at 10:04 am
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...
December 18, 2001 at 10:02 am
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...
December 18, 2001 at 9:59 am
December 18, 2001 at 9:57 am
Viewing 15 posts - 38,581 through 38,595 (of 39,456 total)