Although no change to the DB size, did the size of the backup change?

I've never encountered it.

Have you checked the date_modified column of sysjobs?

Probably too late now, but you may be able to look at a restored version of msdb.

Under SQL2000 the quick way to accomplish Jim's steps 1 and 2 is:

use master
alter database MyDatabase set offline with rollback immediate

Then do your restore

I've used TEXT IN ROW many times, and running this code below will prove that just the single sp_tableoption command has the desired effect:

create table employee (id int...

Nils,

The example I gave was for a trusted connection to my local SQL Server.  You need to specify the -S server name (and possibly -U -P) to access a remote server...

Another way a rogue procedure could be resetting the sa password is by SQL Agent - there could be a job scheduled to start when SQL Agent starts.

Just something to...

It appears that you can't.

You can execute extended stored procedure inside a function and, even though sp_executesql is an extended stored procedure (despite its name), it still generates the message...

declare @x int

set @x = 54321

if @x % 2 = 1  -- odd

   print 'Odd'

else -- even

   print 'Even'

if @x % 3 = 0  -- divisible by 3

   print 'Divisible...

One quick way to submit concatenated scripts to osql is:

type script1.sql script2.sql | osql -E -n

where: script1.sql contains:

declare @x int
set @x = 12345

and script2.sql contains:

select @x

result is:

 -----------
       12345

Avi,

From within my LAN I also cannot get access to my own LAN resources using the WAN address.  From inside I have to use the private address (eg. 192.168.0.2,40000).

Currently, to...

Avy,

Whatever you've done since your last post has apparently fixed the problem.  Your IP is listening for SQL on port 40000 and HTTP on 40001.  I confirmed that they are...

Avy,

It appears to me that there is no problem with ports being open.  The fact that you can connect to 1433 on your SQL box from your LAN shows that...

Joel,

Angela's suggestion is worth a go.  It should work if your 6.5 data and log files were separate, and if there's been no increasing of either file (this is done...

You may be SELECTing the variable in Query Analyzer but have the maximum characters per column result set to 500 chars?  In QA check Tools/Options/Results.

If you're using sp_executesql then I...

It's the syscomments table.  A bit confusing I know because "comments" in oracle are documentary, but in sql the TEXT column of syscomments provides the text of the stored procedure,...