•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 401,589 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,653 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 446 | Replies: 3
 |
•
•
Join Date: Nov 2007
Posts: 21
Reputation: 
Rep Power: 1
Solved Threads: 0
Newbie Poster
I want to make a procedure that runs at every day at certain time. I read that I have to do Scheduling, but to do it I should have sql server agent. I am using sql server express edition with sql management studio express endition. But there is no sql server agent, I don't know if its there and I should enable it, or I should use another version of sql server or another version of sql managment studio. And is there a way to do it without using the sql server agent.
thanks
thanks
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,220
Reputation:
Rep Power: 10
Solved Threads: 270
You have to have full version of SQL Server not just Express...
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
•
•
Join Date: Nov 2007
Posts: 21
Reputation:
Rep Power: 1
Solved Threads: 0
Newbie Poster
I tried to install a sql server developer edition. I don't know if it contains the sql server agent, but I didn't find it . I am using sql management studio express edition.
•
•
Join Date: Dec 2004
Location: London or Slovakia
Posts: 2,220
Reputation:
Rep Power: 10
Solved Threads: 270
Managment studio is for managing things that are provided with server, so it will show agent option only if you get appropriate version of the software.
To understand what I'm saying here is link of SQL server Comparison, check out Manageability table last row
To understand what I'm saying here is link of SQL server Comparison, check out Manageability table last row
Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
Publilius Syrus
(~100 BC)
If we helped you to solve your problem, answered your question please mark your post as SOLVED.
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
ad ad server ad serving advertising ajax architecture asp backup beta business centro crash daniweb database dell developer development doubleclick enterprise google hacker hyper-v internet linux longhorn mail management studio 2005 microsoft mmorpg msdn news novell office open qmail red hat rhel scsi security server server 2008 smtp software sql survey upgrade vista vmware windows workspace
- Cannot find server or DNS Error - please help! (Viruses, Spyware and other Nasties)
- SQL 2000 ODBC and SP4 problem (MS SQL)
- IE7 Redirecting to inactive sites - Major problem - HELP ! (Viruses, Spyware and other Nasties)
- explorer.exe problem - Keeps restarting (Viruses, Spyware and other Nasties)
- Need urgent help. Problem with SQL and win server. (Windows NT / 2000 / XP / 2003)
- Hijack this log. Random hyperlink problem (Viruses, Spyware and other Nasties)
- Help ! Cann't shut down window (Viruses, Spyware and other Nasties)
- windows explorer won't open. (Viruses, Spyware and other Nasties)
- Cannot find server or DNS Error Explorer & usps.com (Windows NT / 2000 / XP / 2003)
- startup problem (Viruses, Spyware and other Nasties)
Other Threads in the MS SQL Forum
- Previous Thread: Maximum stored procedure, function, trigger, or view nesting level exceeded(limit 32)
- Next Thread: Problem using JOIN with six tables
