Installed Office service pack and it 'messed' up the Enterprise Manager. Af
ter reinstalling the client tools and the sp3a service pack all worked but s
cheduled jobs. It turns out that the SQL Server Agent is not running. It d
oesn't automatically start
up but can be started from DOS whereby my jobs in turn can execute with no p
roblem.
Would like to know what the proper registry setting for SQLServerAgent under
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\SQLServerAgent should
be for SQL Server 8.0.859 with service pack 3a as suspect that the problem m
ay be there.
Otherwise open to suggestions so that do not have to backup, uninstall, and
reinstall 10 database.....
Thanxs,
dmatta59The first thing to do here is go into the Control Panel -> Admin Tools ->
Services applet & see if the SQLAgent$[instance] service is configured t
o
auto-start. Your post doesn't indicated that you've done that, so make sure
the service's "Startup Type" property is set to "Automatic". If it still
doesn't start automatically, check the Windows Event Log to see what's
wrong.
Regards,
Greg Linwood
SQL Server MVP
"dmatta59" <anonymous@.discussions.microsoft.com> wrote in message
news:6F7A83AF-FE7A-46EF-8F44-50C94788109C@.microsoft.com...
> Installed Office service pack and it 'messed' up the Enterprise Manager.
After reinstalling the client tools and the sp3a service pack all worked but
scheduled jobs. It turns out that the SQL Server Agent is not running. It
doesn't automatically start up but can be started from DOS whereby my jobs
in turn can execute with no problem.
> Would like to know what the proper registry setting for SQLServerAgent
under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\SQLServerAgent
should be for SQL Server 8.0.859 with service pack 3a as suspect that the
problem may be there.
> Otherwise open to suggestions so that do not have to backup, uninstall,
and reinstall 10 database.....
> Thanxs,
> dmatta59|||The SqlServerAgent is set to automatic. There used to be an error 8344 Supe
rSocket Error but after the registers were cleaned and errors removed the e
rror no longer appears. When viewing the registry for SQLServerAgent there
was some mention in one of
the previous posts about a "dependancies" which is not present so would app
reciate what the registry would look like for MSSQLSERVER and SQLSERVERAGENT
.
Again it works fine if started from a dos command line but most inconvienent
not to have it start automatically or start from within the EM.
Any suggestions?
dmatta59|||Have resolved the problem. Used scm.exe to install the SQLServerAgent servi
ce using the instructions on the following article:
http://groups.google.com/groups?q=i...tngxa06&rnum=21
**Please note that the in this case the sqlagent -c -v was working from the
dos prompt and the jobs could run properly. The only problem was that the S
QLServerAgent was not automatically starting or couldn't be started within E
M.
Thank you,
dmatta59
Showing posts with label pack. Show all posts
Showing posts with label pack. Show all posts
Monday, March 19, 2012
Saturday, February 25, 2012
Missing INFORMATION_SCHEMA.ROUTINES
Hi all,
For some reason this view is missing from my MSSQL:
INFORMATION_SCHEMA.ROUTINES
Does anyone have any idea why?... Is it a service pack maybe?
Please let me know. Thank you!
I do not think that this view was added as a service pack addition. Pleasew
verify that you are logging in with applicable permissions. This view is
created by default.
"Madestro" wrote:
> Hi all,
> For some reason this view is missing from my MSSQL:
> INFORMATION_SCHEMA.ROUTINES
> Does anyone have any idea why?... Is it a service pack maybe?
> Please let me know. Thank you!
>
|||it's not available in SQLServer 7. Is that the reason?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"DBADave" wrote:
[vbcol=seagreen]
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
|||Thank you for replying Dave, I appreciate your help.
I am logging in as "sa", but I still don't see the ROUTINES view.
I have taken a snapshot of the available views through Enterprise Manager.
If you would like to see it, please let me know an address I can send the
snapshot to.
Any other ideas?
Thanks again!
"DBADave" wrote:
[vbcol=seagreen]
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
|||Madestro,
When you use the object browser to look for these views, you
will only find them in the database [master], but you can access
them from any database as
select * from INFORMATION_SCHEMA.ROUTINES
Please let us know if you receive an error when you issue this query.
Steve Kass
Drew University
Madestro wrote:
[vbcol=seagreen]
>Thank you for replying Dave, I appreciate your help.
>I am logging in as "sa", but I still don't see the ROUTINES view.
>I have taken a snapshot of the available views through Enterprise Manager.
>If you would like to see it, please let me know an address I can send the
>snapshot to.
>Any other ideas?
>Thanks again!
>"DBADave" wrote:
>
|||Where are you looking? The view only exists in the master database physically, but it acts just as
it exists in any database. What happens if you execute below:
USE pubs
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Madestro" <me_no_like_spam_juanDOTromero@.bowneDOTcom> wrote in message
news:A8F2AA45-D5C9-45A0-85A4-B75B50E4D9E6@.microsoft.com...[vbcol=seagreen]
> Thank you for replying Dave, I appreciate your help.
> I am logging in as "sa", but I still don't see the ROUTINES view.
> I have taken a snapshot of the available views through Enterprise Manager.
> If you would like to see it, please let me know an address I can send the
> snapshot to.
> Any other ideas?
> Thanks again!
> "DBADave" wrote:
|||Thank you all for your replies.
You are going to laugh at this but.... it turns out this machine is running
MSSQL 7.0...
I just didn't realize it since for some reason it has the 2000 Enterprise
Manager and Query Analizer tools!!!... ?
Thanks again!
"mark baekdal" wrote:
[vbcol=seagreen]
> it's not available in SQLServer 7. Is that the reason?
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "DBADave" wrote:
For some reason this view is missing from my MSSQL:
INFORMATION_SCHEMA.ROUTINES
Does anyone have any idea why?... Is it a service pack maybe?
Please let me know. Thank you!
I do not think that this view was added as a service pack addition. Pleasew
verify that you are logging in with applicable permissions. This view is
created by default.
"Madestro" wrote:
> Hi all,
> For some reason this view is missing from my MSSQL:
> INFORMATION_SCHEMA.ROUTINES
> Does anyone have any idea why?... Is it a service pack maybe?
> Please let me know. Thank you!
>
|||it's not available in SQLServer 7. Is that the reason?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"DBADave" wrote:
[vbcol=seagreen]
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
|||Thank you for replying Dave, I appreciate your help.
I am logging in as "sa", but I still don't see the ROUTINES view.
I have taken a snapshot of the available views through Enterprise Manager.
If you would like to see it, please let me know an address I can send the
snapshot to.
Any other ideas?
Thanks again!
"DBADave" wrote:
[vbcol=seagreen]
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
|||Madestro,
When you use the object browser to look for these views, you
will only find them in the database [master], but you can access
them from any database as
select * from INFORMATION_SCHEMA.ROUTINES
Please let us know if you receive an error when you issue this query.
Steve Kass
Drew University
Madestro wrote:
[vbcol=seagreen]
>Thank you for replying Dave, I appreciate your help.
>I am logging in as "sa", but I still don't see the ROUTINES view.
>I have taken a snapshot of the available views through Enterprise Manager.
>If you would like to see it, please let me know an address I can send the
>snapshot to.
>Any other ideas?
>Thanks again!
>"DBADave" wrote:
>
|||Where are you looking? The view only exists in the master database physically, but it acts just as
it exists in any database. What happens if you execute below:
USE pubs
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Madestro" <me_no_like_spam_juanDOTromero@.bowneDOTcom> wrote in message
news:A8F2AA45-D5C9-45A0-85A4-B75B50E4D9E6@.microsoft.com...[vbcol=seagreen]
> Thank you for replying Dave, I appreciate your help.
> I am logging in as "sa", but I still don't see the ROUTINES view.
> I have taken a snapshot of the available views through Enterprise Manager.
> If you would like to see it, please let me know an address I can send the
> snapshot to.
> Any other ideas?
> Thanks again!
> "DBADave" wrote:
|||Thank you all for your replies.
You are going to laugh at this but.... it turns out this machine is running
MSSQL 7.0...
I just didn't realize it since for some reason it has the 2000 Enterprise
Manager and Query Analizer tools!!!... ?
Thanks again!
"mark baekdal" wrote:
[vbcol=seagreen]
> it's not available in SQLServer 7. Is that the reason?
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "DBADave" wrote:
Missing INFORMATION_SCHEMA.ROUTINES
Hi all,
For some reason this view is missing from my MSSQL:
INFORMATION_SCHEMA.ROUTINES
Does anyone have any idea why?... Is it a service pack maybe?
Please let me know. Thank you!I do not think that this view was added as a service pack addition. Pleasew
verify that you are logging in with applicable permissions. This view is
created by default.
"Madestro" wrote:
> Hi all,
> For some reason this view is missing from my MSSQL:
> INFORMATION_SCHEMA.ROUTINES
> Does anyone have any idea why?... Is it a service pack maybe?
> Please let me know. Thank you!
>|||it's not available in SQLServer 7. Is that the reason?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"DBADave" wrote:
[vbcol=seagreen]
> I do not think that this view was added as a service pack addition. Pleas
ew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
>|||Thank you for replying Dave, I appreciate your help.
I am logging in as "sa", but I still don't see the ROUTINES view.
I have taken a snapshot of the available views through Enterprise Manager.
If you would like to see it, please let me know an address I can send the
snapshot to.
Any other ideas?
Thanks again!
"DBADave" wrote:
[vbcol=seagreen]
> I do not think that this view was added as a service pack addition. Pleas
ew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
>|||Madestro,
When you use the object browser to look for these views, you
will only find them in the database [master], but you can access
them from any database as
select * from INFORMATION_SCHEMA.ROUTINES
Please let us know if you receive an error when you issue this query.
Steve Kass
Drew University
Madestro wrote:
[vbcol=seagreen]
>Thank you for replying Dave, I appreciate your help.
>I am logging in as "sa", but I still don't see the ROUTINES view.
>I have taken a snapshot of the available views through Enterprise Manager.
>If you would like to see it, please let me know an address I can send the
>snapshot to.
>Any other ideas?
>Thanks again!
>"DBADave" wrote:
>
>|||Where are you looking? The view only exists in the master database physicall
y, but it acts just as
it exists in any database. What happens if you execute below:
USE pubs
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Madestro" < me_no_like_spam_juanDOTromero@.bowneDOTco
m> wrote in message
news:A8F2AA45-D5C9-45A0-85A4-B75B50E4D9E6@.microsoft.com...[vbcol=seagreen]
> Thank you for replying Dave, I appreciate your help.
> I am logging in as "sa", but I still don't see the ROUTINES view.
> I have taken a snapshot of the available views through Enterprise Manager.
> If you would like to see it, please let me know an address I can send the
> snapshot to.
> Any other ideas?
> Thanks again!
> "DBADave" wrote:
>|||Thank you all for your replies.
You are going to laugh at this but.... it turns out this machine is running
MSSQL 7.0...
I just didn't realize it since for some reason it has the 2000 Enterprise
Manager and Query Analizer tools!!!... ?
Thanks again!
"mark baekdal" wrote:
[vbcol=seagreen]
> it's not available in SQLServer 7. Is that the reason?
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "DBADave" wrote:
>
For some reason this view is missing from my MSSQL:
INFORMATION_SCHEMA.ROUTINES
Does anyone have any idea why?... Is it a service pack maybe?
Please let me know. Thank you!I do not think that this view was added as a service pack addition. Pleasew
verify that you are logging in with applicable permissions. This view is
created by default.
"Madestro" wrote:
> Hi all,
> For some reason this view is missing from my MSSQL:
> INFORMATION_SCHEMA.ROUTINES
> Does anyone have any idea why?... Is it a service pack maybe?
> Please let me know. Thank you!
>|||it's not available in SQLServer 7. Is that the reason?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"DBADave" wrote:
[vbcol=seagreen]
> I do not think that this view was added as a service pack addition. Pleas
ew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
>|||Thank you for replying Dave, I appreciate your help.
I am logging in as "sa", but I still don't see the ROUTINES view.
I have taken a snapshot of the available views through Enterprise Manager.
If you would like to see it, please let me know an address I can send the
snapshot to.
Any other ideas?
Thanks again!
"DBADave" wrote:
[vbcol=seagreen]
> I do not think that this view was added as a service pack addition. Pleas
ew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
>|||Madestro,
When you use the object browser to look for these views, you
will only find them in the database [master], but you can access
them from any database as
select * from INFORMATION_SCHEMA.ROUTINES
Please let us know if you receive an error when you issue this query.
Steve Kass
Drew University
Madestro wrote:
[vbcol=seagreen]
>Thank you for replying Dave, I appreciate your help.
>I am logging in as "sa", but I still don't see the ROUTINES view.
>I have taken a snapshot of the available views through Enterprise Manager.
>If you would like to see it, please let me know an address I can send the
>snapshot to.
>Any other ideas?
>Thanks again!
>"DBADave" wrote:
>
>|||Where are you looking? The view only exists in the master database physicall
y, but it acts just as
it exists in any database. What happens if you execute below:
USE pubs
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Madestro" < me_no_like_spam_juanDOTromero@.bowneDOTco
m> wrote in message
news:A8F2AA45-D5C9-45A0-85A4-B75B50E4D9E6@.microsoft.com...[vbcol=seagreen]
> Thank you for replying Dave, I appreciate your help.
> I am logging in as "sa", but I still don't see the ROUTINES view.
> I have taken a snapshot of the available views through Enterprise Manager.
> If you would like to see it, please let me know an address I can send the
> snapshot to.
> Any other ideas?
> Thanks again!
> "DBADave" wrote:
>|||Thank you all for your replies.
You are going to laugh at this but.... it turns out this machine is running
MSSQL 7.0...
I just didn't realize it since for some reason it has the 2000 Enterprise
Manager and Query Analizer tools!!!... ?
Thanks again!
"mark baekdal" wrote:
[vbcol=seagreen]
> it's not available in SQLServer 7. Is that the reason?
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "DBADave" wrote:
>
Missing INFORMATION_SCHEMA.ROUTINES
Hi all,
For some reason this view is missing from my MSSQL:
INFORMATION_SCHEMA.ROUTINES
Does anyone have any idea why?... Is it a service pack maybe?
Please let me know. Thank you!I do not think that this view was added as a service pack addition. Pleasew
verify that you are logging in with applicable permissions. This view is
created by default.
"Madestro" wrote:
> Hi all,
> For some reason this view is missing from my MSSQL:
> INFORMATION_SCHEMA.ROUTINES
> Does anyone have any idea why?... Is it a service pack maybe?
> Please let me know. Thank you!
>|||it's not available in SQLServer 7. Is that the reason?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"DBADave" wrote:
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
> > Hi all,
> >
> > For some reason this view is missing from my MSSQL:
> >
> > INFORMATION_SCHEMA.ROUTINES
> >
> > Does anyone have any idea why?... Is it a service pack maybe?
> >
> > Please let me know. Thank you!
> >|||Thank you for replying Dave, I appreciate your help.
I am logging in as "sa", but I still don't see the ROUTINES view.
I have taken a snapshot of the available views through Enterprise Manager.
If you would like to see it, please let me know an address I can send the
snapshot to.
Any other ideas?
Thanks again!
"DBADave" wrote:
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
> > Hi all,
> >
> > For some reason this view is missing from my MSSQL:
> >
> > INFORMATION_SCHEMA.ROUTINES
> >
> > Does anyone have any idea why?... Is it a service pack maybe?
> >
> > Please let me know. Thank you!
> >|||Madestro,
When you use the object browser to look for these views, you
will only find them in the database [master], but you can access
them from any database as
select * from INFORMATION_SCHEMA.ROUTINES
Please let us know if you receive an error when you issue this query.
Steve Kass
Drew University
Madestro wrote:
>Thank you for replying Dave, I appreciate your help.
>I am logging in as "sa", but I still don't see the ROUTINES view.
>I have taken a snapshot of the available views through Enterprise Manager.
>If you would like to see it, please let me know an address I can send the
>snapshot to.
>Any other ideas?
>Thanks again!
>"DBADave" wrote:
>
>>I do not think that this view was added as a service pack addition. Pleasew
>>verify that you are logging in with applicable permissions. This view is
>>created by default.
>>"Madestro" wrote:
>>
>>Hi all,
>>For some reason this view is missing from my MSSQL:
>>INFORMATION_SCHEMA.ROUTINES
>>Does anyone have any idea why?... Is it a service pack maybe?
>>Please let me know. Thank you!
>>|||Where are you looking? The view only exists in the master database physically, but it acts just as
it exists in any database. What happens if you execute below:
USE pubs
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Madestro" <me_no_like_spam_juanDOTromero@.bowneDOTcom> wrote in message
news:A8F2AA45-D5C9-45A0-85A4-B75B50E4D9E6@.microsoft.com...
> Thank you for replying Dave, I appreciate your help.
> I am logging in as "sa", but I still don't see the ROUTINES view.
> I have taken a snapshot of the available views through Enterprise Manager.
> If you would like to see it, please let me know an address I can send the
> snapshot to.
> Any other ideas?
> Thanks again!
> "DBADave" wrote:
>> I do not think that this view was added as a service pack addition. Pleasew
>> verify that you are logging in with applicable permissions. This view is
>> created by default.
>> "Madestro" wrote:
>> > Hi all,
>> >
>> > For some reason this view is missing from my MSSQL:
>> >
>> > INFORMATION_SCHEMA.ROUTINES
>> >
>> > Does anyone have any idea why?... Is it a service pack maybe?
>> >
>> > Please let me know. Thank you!
>> >|||Thank you all for your replies.
You are going to laugh at this but.... it turns out this machine is running
MSSQL 7.0...
I just didn't realize it since for some reason it has the 2000 Enterprise
Manager and Query Analizer tools!!!... ?
Thanks again!
"mark baekdal" wrote:
> it's not available in SQLServer 7. Is that the reason?
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "DBADave" wrote:
> > I do not think that this view was added as a service pack addition. Pleasew
> > verify that you are logging in with applicable permissions. This view is
> > created by default.
> >
> > "Madestro" wrote:
> >
> > > Hi all,
> > >
> > > For some reason this view is missing from my MSSQL:
> > >
> > > INFORMATION_SCHEMA.ROUTINES
> > >
> > > Does anyone have any idea why?... Is it a service pack maybe?
> > >
> > > Please let me know. Thank you!
> > >
For some reason this view is missing from my MSSQL:
INFORMATION_SCHEMA.ROUTINES
Does anyone have any idea why?... Is it a service pack maybe?
Please let me know. Thank you!I do not think that this view was added as a service pack addition. Pleasew
verify that you are logging in with applicable permissions. This view is
created by default.
"Madestro" wrote:
> Hi all,
> For some reason this view is missing from my MSSQL:
> INFORMATION_SCHEMA.ROUTINES
> Does anyone have any idea why?... Is it a service pack maybe?
> Please let me know. Thank you!
>|||it's not available in SQLServer 7. Is that the reason?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"DBADave" wrote:
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
> > Hi all,
> >
> > For some reason this view is missing from my MSSQL:
> >
> > INFORMATION_SCHEMA.ROUTINES
> >
> > Does anyone have any idea why?... Is it a service pack maybe?
> >
> > Please let me know. Thank you!
> >|||Thank you for replying Dave, I appreciate your help.
I am logging in as "sa", but I still don't see the ROUTINES view.
I have taken a snapshot of the available views through Enterprise Manager.
If you would like to see it, please let me know an address I can send the
snapshot to.
Any other ideas?
Thanks again!
"DBADave" wrote:
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
> > Hi all,
> >
> > For some reason this view is missing from my MSSQL:
> >
> > INFORMATION_SCHEMA.ROUTINES
> >
> > Does anyone have any idea why?... Is it a service pack maybe?
> >
> > Please let me know. Thank you!
> >|||Madestro,
When you use the object browser to look for these views, you
will only find them in the database [master], but you can access
them from any database as
select * from INFORMATION_SCHEMA.ROUTINES
Please let us know if you receive an error when you issue this query.
Steve Kass
Drew University
Madestro wrote:
>Thank you for replying Dave, I appreciate your help.
>I am logging in as "sa", but I still don't see the ROUTINES view.
>I have taken a snapshot of the available views through Enterprise Manager.
>If you would like to see it, please let me know an address I can send the
>snapshot to.
>Any other ideas?
>Thanks again!
>"DBADave" wrote:
>
>>I do not think that this view was added as a service pack addition. Pleasew
>>verify that you are logging in with applicable permissions. This view is
>>created by default.
>>"Madestro" wrote:
>>
>>Hi all,
>>For some reason this view is missing from my MSSQL:
>>INFORMATION_SCHEMA.ROUTINES
>>Does anyone have any idea why?... Is it a service pack maybe?
>>Please let me know. Thank you!
>>|||Where are you looking? The view only exists in the master database physically, but it acts just as
it exists in any database. What happens if you execute below:
USE pubs
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Madestro" <me_no_like_spam_juanDOTromero@.bowneDOTcom> wrote in message
news:A8F2AA45-D5C9-45A0-85A4-B75B50E4D9E6@.microsoft.com...
> Thank you for replying Dave, I appreciate your help.
> I am logging in as "sa", but I still don't see the ROUTINES view.
> I have taken a snapshot of the available views through Enterprise Manager.
> If you would like to see it, please let me know an address I can send the
> snapshot to.
> Any other ideas?
> Thanks again!
> "DBADave" wrote:
>> I do not think that this view was added as a service pack addition. Pleasew
>> verify that you are logging in with applicable permissions. This view is
>> created by default.
>> "Madestro" wrote:
>> > Hi all,
>> >
>> > For some reason this view is missing from my MSSQL:
>> >
>> > INFORMATION_SCHEMA.ROUTINES
>> >
>> > Does anyone have any idea why?... Is it a service pack maybe?
>> >
>> > Please let me know. Thank you!
>> >|||Thank you all for your replies.
You are going to laugh at this but.... it turns out this machine is running
MSSQL 7.0...
I just didn't realize it since for some reason it has the 2000 Enterprise
Manager and Query Analizer tools!!!... ?
Thanks again!
"mark baekdal" wrote:
> it's not available in SQLServer 7. Is that the reason?
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "DBADave" wrote:
> > I do not think that this view was added as a service pack addition. Pleasew
> > verify that you are logging in with applicable permissions. This view is
> > created by default.
> >
> > "Madestro" wrote:
> >
> > > Hi all,
> > >
> > > For some reason this view is missing from my MSSQL:
> > >
> > > INFORMATION_SCHEMA.ROUTINES
> > >
> > > Does anyone have any idea why?... Is it a service pack maybe?
> > >
> > > Please let me know. Thank you!
> > >
Monday, February 20, 2012
missing DTS connections
I am running SQL server 2000 service pack 3 on a windows XP professional
service pack 2 machine. There are four developers using the same
configuration.
All of us have missing connections in the DTS designer. All that is
available are the following:
Microsoft OLEDB provider for sql server
Text File(source)
Text File (Destination)
Microsoft datalink
We have no connections to Excel, Access Oracle etc.
When I checked the Microsoft Datalink properties dialogue there are also
missing OLEDB providers so the issue appears to be with the OLEDB drivers.
I tried re installing MDAC however XP generated an error stating that MDAC
is up to date.
I suspect that the issue is due to a windows update that was automatically
applied as I built a new machine and installed only XP ,Sql server ,office
2003 and Visual studio enterprise architect 2003. After the initial
installation all the connections were available however after applying
automatic updates the machine lost all the connections.
This fault is causing us no end of problems and we desperately need a
solution.
Thank you in advance
LLoyd Faber
You can check your MDAC installation using component
checker. You can download the tool from:
http://msdn.microsoft.com/data/downl...s/default.aspx
You can find more information on the tool in the following
article:
Component Checker: Diagnose problems and reconfigure MDAC
installations
http://support.microsoft.com/?id=307255
-Sue
On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
<talon@.nospam.co.uk> wrote:
>I am running SQL server 2000 service pack 3 on a windows XP professional
>service pack 2 machine. There are four developers using the same
>configuration.
>All of us have missing connections in the DTS designer. All that is
>available are the following:
>Microsoft OLEDB provider for sql server
>Text File(source)
>Text File (Destination)
>Microsoft datalink
>We have no connections to Excel, Access Oracle etc.
>When I checked the Microsoft Datalink properties dialogue there are also
>missing OLEDB providers so the issue appears to be with the OLEDB drivers.
>I tried re installing MDAC however XP generated an error stating that MDAC
>is up to date.
>I suspect that the issue is due to a windows update that was automatically
>applied as I built a new machine and installed only XP ,Sql server ,office
>2003 and Visual studio enterprise architect 2003. After the initial
>installation all the connections were available however after applying
>automatic updates the machine lost all the connections.
>This fault is causing us no end of problems and we desperately need a
>solution.
>Thank you in advance
>LLoyd Faber
|||Sue
I ran the component checker and it reports that MDAC is OK!
"Sue Hoegemeier" wrote:
> You can check your MDAC installation using component
> checker. You can download the tool from:
> http://msdn.microsoft.com/data/downl...s/default.aspx
> You can find more information on the tool in the following
> article:
> Component Checker: Diagnose problems and reconfigure MDAC
> installations
> http://support.microsoft.com/?id=307255
> -Sue
> On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
> <talon@.nospam.co.uk> wrote:
>
>
service pack 2 machine. There are four developers using the same
configuration.
All of us have missing connections in the DTS designer. All that is
available are the following:
Microsoft OLEDB provider for sql server
Text File(source)
Text File (Destination)
Microsoft datalink
We have no connections to Excel, Access Oracle etc.
When I checked the Microsoft Datalink properties dialogue there are also
missing OLEDB providers so the issue appears to be with the OLEDB drivers.
I tried re installing MDAC however XP generated an error stating that MDAC
is up to date.
I suspect that the issue is due to a windows update that was automatically
applied as I built a new machine and installed only XP ,Sql server ,office
2003 and Visual studio enterprise architect 2003. After the initial
installation all the connections were available however after applying
automatic updates the machine lost all the connections.
This fault is causing us no end of problems and we desperately need a
solution.
Thank you in advance
LLoyd Faber
You can check your MDAC installation using component
checker. You can download the tool from:
http://msdn.microsoft.com/data/downl...s/default.aspx
You can find more information on the tool in the following
article:
Component Checker: Diagnose problems and reconfigure MDAC
installations
http://support.microsoft.com/?id=307255
-Sue
On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
<talon@.nospam.co.uk> wrote:
>I am running SQL server 2000 service pack 3 on a windows XP professional
>service pack 2 machine. There are four developers using the same
>configuration.
>All of us have missing connections in the DTS designer. All that is
>available are the following:
>Microsoft OLEDB provider for sql server
>Text File(source)
>Text File (Destination)
>Microsoft datalink
>We have no connections to Excel, Access Oracle etc.
>When I checked the Microsoft Datalink properties dialogue there are also
>missing OLEDB providers so the issue appears to be with the OLEDB drivers.
>I tried re installing MDAC however XP generated an error stating that MDAC
>is up to date.
>I suspect that the issue is due to a windows update that was automatically
>applied as I built a new machine and installed only XP ,Sql server ,office
>2003 and Visual studio enterprise architect 2003. After the initial
>installation all the connections were available however after applying
>automatic updates the machine lost all the connections.
>This fault is causing us no end of problems and we desperately need a
>solution.
>Thank you in advance
>LLoyd Faber
|||Sue
I ran the component checker and it reports that MDAC is OK!
"Sue Hoegemeier" wrote:
> You can check your MDAC installation using component
> checker. You can download the tool from:
> http://msdn.microsoft.com/data/downl...s/default.aspx
> You can find more information on the tool in the following
> article:
> Component Checker: Diagnose problems and reconfigure MDAC
> installations
> http://support.microsoft.com/?id=307255
> -Sue
> On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
> <talon@.nospam.co.uk> wrote:
>
>
missing DTS connections
I am running SQL server 2000 service pack 3 on a Windows XP professional
service pack 2 machine. There are four developers using the same
configuration.
All of us have missing connections in the DTS designer. All that is
available are the following:
Microsoft OLEDB provider for sql server
Text File(source)
Text File (Destination)
Microsoft datalink
We have no connections to Excel, Access Oracle etc.
When I checked the Microsoft Datalink properties dialogue there are also
missing OLEDB providers so the issue appears to be with the OLEDB drivers.
I tried re installing MDAC however XP generated an error stating that MDAC
is up to date.
I suspect that the issue is due to a windows update that was automatically
applied as I built a new machine and installed only XP ,Sql server ,office
2003 and Visual studio enterprise architect 2003. After the initial
installation all the connections were available however after applying
automatic updates the machine lost all the connections.
This fault is causing us no end of problems and we desperately need a
solution.
Thank you in advance
LLoyd FaberYou can check your MDAC installation using component
checker. You can download the tool from:
http://msdn.microsoft.com/data/down...ls/default.aspx
You can find more information on the tool in the following
article:
Component Checker: Diagnose problems and reconfigure MDAC
installations
http://support.microsoft.com/?id=307255
-Sue
On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
<talon@.nospam.co.uk> wrote:
>I am running SQL server 2000 service pack 3 on a Windows XP professional
>service pack 2 machine. There are four developers using the same
>configuration.
>All of us have missing connections in the DTS designer. All that is
>available are the following:
>Microsoft OLEDB provider for sql server
>Text File(source)
>Text File (Destination)
>Microsoft datalink
>We have no connections to Excel, Access Oracle etc.
>When I checked the Microsoft Datalink properties dialogue there are also
>missing OLEDB providers so the issue appears to be with the OLEDB drivers.
>I tried re installing MDAC however XP generated an error stating that MDAC
>is up to date.
>I suspect that the issue is due to a windows update that was automatically
>applied as I built a new machine and installed only XP ,Sql server ,office
>2003 and Visual studio enterprise architect 2003. After the initial
>installation all the connections were available however after applying
>automatic updates the machine lost all the connections.
>This fault is causing us no end of problems and we desperately need a
>solution.
>Thank you in advance
>LLoyd Faber|||Sue
I ran the component checker and it reports that MDAC is OK!
"Sue Hoegemeier" wrote:
> You can check your MDAC installation using component
> checker. You can download the tool from:
> http://msdn.microsoft.com/data/down...ls/default.aspx
> You can find more information on the tool in the following
> article:
> Component Checker: Diagnose problems and reconfigure MDAC
> installations
> http://support.microsoft.com/?id=307255
> -Sue
> On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
> <talon@.nospam.co.uk> wrote:
>
>
service pack 2 machine. There are four developers using the same
configuration.
All of us have missing connections in the DTS designer. All that is
available are the following:
Microsoft OLEDB provider for sql server
Text File(source)
Text File (Destination)
Microsoft datalink
We have no connections to Excel, Access Oracle etc.
When I checked the Microsoft Datalink properties dialogue there are also
missing OLEDB providers so the issue appears to be with the OLEDB drivers.
I tried re installing MDAC however XP generated an error stating that MDAC
is up to date.
I suspect that the issue is due to a windows update that was automatically
applied as I built a new machine and installed only XP ,Sql server ,office
2003 and Visual studio enterprise architect 2003. After the initial
installation all the connections were available however after applying
automatic updates the machine lost all the connections.
This fault is causing us no end of problems and we desperately need a
solution.
Thank you in advance
LLoyd FaberYou can check your MDAC installation using component
checker. You can download the tool from:
http://msdn.microsoft.com/data/down...ls/default.aspx
You can find more information on the tool in the following
article:
Component Checker: Diagnose problems and reconfigure MDAC
installations
http://support.microsoft.com/?id=307255
-Sue
On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
<talon@.nospam.co.uk> wrote:
>I am running SQL server 2000 service pack 3 on a Windows XP professional
>service pack 2 machine. There are four developers using the same
>configuration.
>All of us have missing connections in the DTS designer. All that is
>available are the following:
>Microsoft OLEDB provider for sql server
>Text File(source)
>Text File (Destination)
>Microsoft datalink
>We have no connections to Excel, Access Oracle etc.
>When I checked the Microsoft Datalink properties dialogue there are also
>missing OLEDB providers so the issue appears to be with the OLEDB drivers.
>I tried re installing MDAC however XP generated an error stating that MDAC
>is up to date.
>I suspect that the issue is due to a windows update that was automatically
>applied as I built a new machine and installed only XP ,Sql server ,office
>2003 and Visual studio enterprise architect 2003. After the initial
>installation all the connections were available however after applying
>automatic updates the machine lost all the connections.
>This fault is causing us no end of problems and we desperately need a
>solution.
>Thank you in advance
>LLoyd Faber|||Sue
I ran the component checker and it reports that MDAC is OK!
"Sue Hoegemeier" wrote:
> You can check your MDAC installation using component
> checker. You can download the tool from:
> http://msdn.microsoft.com/data/down...ls/default.aspx
> You can find more information on the tool in the following
> article:
> Component Checker: Diagnose problems and reconfigure MDAC
> installations
> http://support.microsoft.com/?id=307255
> -Sue
> On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
> <talon@.nospam.co.uk> wrote:
>
>
Subscribe to:
Posts (Atom)