Site Sponsored By: SQLDSC - SQL Server Desired State Configuration
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.
HiI am very new sql server administration.I have downloaded Sql server 2008 and see I dont have the sql server agent folder in the management studio.What do i need to have to get the sql server agentPlease advise
My Database Server version is Microsoft SQL Server 2005 and SSMS version is 10.0.1600.22(SQL_Prerelease)will this version do not have the SQL server agent capability?Also what version of software do i need to buy If i need SQl Server management studio with Sql server agent,BIDS etc
9.00.4273.00 SP3 Standard Edition (64-bit)The Above is what i got after executing the query.
russell
Pyro-ma-ni-yak
5072 Posts
Posted - 2010-07-22 : 13:21:04
You downloaded the Express version of SSMS, which doesn't have SQL Agent support. You need the full version. The media containing the server software also has the client tools. You can download it here http://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx