Viewing 15 posts - 751 through 765 (of 789 total)
Even though you've done a subst, SQL doesn't know about your R: drive. You need to:
EXEC master..xp_cmdshell 'subst R: F:\BACKUP'
EXEC master..xp_cmdshell 'mkdir R:\FULL'
June 11, 2003 at 2:52 am
My reading of the second lot of statistics is that you're sending nothing to the server and therefore getting nothing back. Everything's zero, including network stats. Am I...
June 11, 2003 at 12:02 am
Grant,
I installed version 1.1.0.8 under SQL 7 SP4 (SQL log shows "Using 'xpsmtp70.dll' version '2002.08.12'") and was unable to replicate the problem for any combination of normal and unicode data...
June 10, 2003 at 11:53 pm
Apart from the 1 line BOL and MSDN dedicate to it, I can find very little. I can only assume that if it's high and the server is processing...
June 10, 2003 at 11:12 pm
Does the job contain any e-mail notification? If so, maybe try it without such notification and see if it runs to completion.
June 10, 2003 at 10:29 pm
If your original (FTP) job is still executing, can it be stopped with a simple "stop job" through EM?
June 10, 2003 at 5:26 pm
Carl,
When you do a test run (non-scheduled) of the package, do you do so logged on to the SQL box itself, or using client utilities from your workstation?
June 10, 2003 at 7:30 am
Jon,
6 hours is an extraordinarily long time for a 45gb database. Normally I'd say your tape drive needs looking at, except for the fact that it's about half the...
June 10, 2003 at 7:24 am
I'm confused, or more likely misreading the problem. Won't "IF Update(column_name)" be either true for all rows affected in a set-based update, or false for all rows?
June 10, 2003 at 7:07 am
...further to that, the database had to be called "victimdb" but no longer works on SQL2k anyway. You can stop mssqlserver and then play around with a hex editor...
June 10, 2003 at 6:36 am
In SQL 6.5 (and sybase) I recall a "DBCC CORRUPT" command, for training purposes. But I also think the database had to be called "corrupt". I'll investigate further...
...
June 10, 2003 at 6:14 am
Frank,
If it's a maintenance plan job, look at the report specified on the plan's reporting tab. If you haven't requested a report then do so.
Or, run a transaction log...
June 10, 2003 at 6:10 am
master..xp_cmdshell will let you run host commands from QA/ISQL/OSQL. Be careful not to run things that will pop up a dialog box or prompt for input because it'll just...
June 10, 2003 at 2:01 am
Sorry but you've caught me out... when I said "We switched to an Oracle-supplied driver" I meant that someone else in the team did the work while I shared the...
June 9, 2003 at 8:13 pm
Can only suspect it's by design. Operations on MONEY fields return a MONEY field. Operations on DECIMAL return DECIMAL. The difference is that DECIMAL operations will adjust...
June 9, 2003 at 8:05 pm
Viewing 15 posts - 751 through 765 (of 789 total)