I've been tasked with setting up a jobs for a SQL Server.
The little information provided & the fact there is no SSMS leaves me with questions:
1) How do I determine if it is SQL Server 2008 or the Express version running as a Service?
2) Since there is no SSMS on the local machine, can local scripts be developed for jobs or do I need to set up jobs from another computer that has SSMS installed?
3) What are the names of executables for SQL Server 2008 and SS Express?