I often receive a good question on the blog, however, I do not always receive a good answer for the questions. Recently someone asked on a blog about Finding next run time for Schedule Job using T-SQL. My friend came up with a nice script. I have modified it a bit to adjust needs. This blog post is about finding the next running time of scheduled job using T-SQL.Â
SQLAuthority News – SQL Server Related Downloads from Microsoft
Feature Pack for SQL Server 2005 December 2008 Download the December 2008 Feature Pack for Microsoft SQL Server 2005, a collection of standalone install packages that provide additional value for SQL Server 2005. Microsoft SQL Server Protocol Documentation The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary…
Read MoreSQL SERVER – Change Collation of Database Column – T-SQL Script
Just a day before I wrote about SQL SERVER – Find Collation of Database and Table Column Using T-SQL and I have received some good comments and one particular question was about how to change collation of database. It is quite simple do so. Let us see following example. USE…
Read MoreSQLAuthority News – Download – SQL Server 2005 Books Online (December 2008)
Download an updated version of Books Online for Microsoft SQL Server 2005. Books Online is the primary documentation for SQL Server 2005. The December 2008 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to “New and…
Read MoreSQLAuthority News – Download Microsoft SQL Server 2005 Service Pack 3
Service Pack 3 for Microsoft SQL Server 2005 is now available. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP3. You can use these packages to upgrade any of the following SQL Server 2005 editions: Enterprise Enterprise Evaluation…
Read MoreSQL SERVER – Interesting Interview Questions – Revisited
I really enjoyed users participation in my previous question. Read SQL SERVER – Interesting Interview Questions before continuing reading this article. This interview question was about user participation and about how good and how different you can come with your T-SQL script. What I really liked is that many users…
Read MoreSQL SERVER – Find Collation of Database and Table Column Using T-SQL
Today we will go over very quick tip about finding out collation of database and table column. Collations specify the rules for how strings of character data are sorted and compared, based on the norms of particular languages and locales Today’s script are self explanatory so I will not explain…
Read MoreSQLAuthority News – Wedding Day of Author – Photographs – Mr. and Mrs. SQLAuthority
On December 12, 2008 I had posted a note on blog when I completed 800th Article on this blog. The same day was also my wedding day. Read more about the same here SQLAuthority News – Wedding Day of Author. Thank you very much for your wishes and wonderful emails.…
Read More
SQL SERVER – Connect using Enterprise Manager to SQL Server 2005/2008
I received the following email from Mike Bikinis. about enterprise manager. “How can I connect to SQL Server 2005 or SQL Server 2008 using SQL Server 2000’s Enterprise Manager?”
SQL SERVER – Email from Blog Reader – Not a Potential Bug in SQL – Puzzle
Few days ago, I received wonderful email from blog reader and it was like good puzzle. I enjoyed solving this puzzle. I did not write the name of the blog reader because I am not sure if he wants his name here or not. Please read this article and run…
Read More