Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Sql Server Agent..

Author  Topic 

zeeshandar
Starting Member

3 Posts

Posted - 2011-03-05 : 11:17:08
I have a website using Sql Server 2008. The site is hosted at shared server.

I do not have access to Sql Server through Enterprise Manager and I have to use Query Analyzer to manage db tables etc.



So now using Query Analyzer, how can I:

1- Check if I have access to sql server agent or start sql server agent.

2- As I can access sql server through Query Analyzer only (and not by Enterprise Manager), so just by using QA is it possible to create a job that send email alters to db users?



Thanks!
Zeeshan

---------------------------
Pixel Managers
Connecting clients via text messaging

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-03-05 : 12:55:10
http://msdn.microsoft.com/en-us/library/ms182079.aspx
Go to Top of Page
   

- Advertisement -