sp_schedulersignal is gone from Master DB

sp_schedulersignal is gone from Master DB

Post by Jack Epstei » Thu, 12 Mar 1998 04:00:00



and admin book on line advised using instmstr.sql to restore

problem is, can't find instmstr.sql on SQL Server 6.5 CD or HDD

please advise.....

Jack

 
 
 

sp_schedulersignal is gone from Master DB

Post by Tibor Karasz » Fri, 13 Mar 1998 04:00:00


Jack,

It's actually in instmsdb.sql (but it gets created in master).

--

MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB


>and admin book on line advised using instmstr.sql to restore

>problem is, can't find instmstr.sql on SQL Server 6.5 CD or HDD

>please advise.....

>Jack


 
 
 

1. SPC goes to Master DB

Why would a call to a Remote SPC cause SQL Server to
change back to the Master DB? This call returns fine
and it does what I want, but iSQL switches back to
the Master DB all on its own?


INSERT INTO #tmpTable

If I take out the call to the Remote SPC, then iSQL
doesn't switch out of DB where the SPC is called from...

any hints? is this just a feature?
thanks.
simeon.

2. Urgent - debugging deadlocks

3. Restore Master DB to db other than Master?

4. Help with MDX terms!

5. Restore of Master -- What am I missing?

6. US-NJ: Princeton-Oracle Clinical

7. i am writing my masters thesis on java database programming

8. Installation of MS SQL client components on network drive!

9. ** HELP WITH vb 4.0 I am going crazy**

10. Oracle8 for SCO : Does it use shared libs - am going to put on Linux

11. ado-commands -where am I going wrong ?

12. I am a newbie: autocompletes in DB B based on data in DB A

13. I am Lord and Master of Usenet