I received many emails regarding SQLAuthority News – 500th Post – An Interesting Journey with SQL Server. One of the email asked interesting question regarding my most visited article on this blog. It was interesting to know that reader wants to know which article I visit the most.
Following is the link to the article which I personal visit most of the time while working as Principal Database Administrator.
SQL SERVER – 2005 – Search Stored Procedure Code – Search Stored Procedure Text
Reference : Pinal Dave (https://blog.sqlauthority.com)
Excellent site for SQL freaks
can any one please tell me if there are anything like sequel jobs that we can create in sql server 2000/2005. I heard about it that they are also something like stored procedures but i am not able to understand how to create them in sql server management studio , please send me a link abt it if u find any.
thanks in advance.
Read about Jobs in SQL Server help file
It has examples too