Database Archive

  • SQL Server 2005

    SQL Server 2005 Database Autogrowth option is a bug

    Posted on December 7, 2010 | 1 Comment
    When maintaining a SQL Server database, you have the option to select if you want to restrict the growth of a database or transaction log or give SQL Server the liberty to grow automatically without setting a restriction. You select unrestricted file growth when you...

    Full Story

  • SQL Server 2005

    Here’s a SQL Server Tip

    Posted on July 29, 2010 | 2 Comments
    How many times have you asked this question when you run a query. How do I copy the query result with the column names into Microsoft Excel? In the SQL Server Management Studio, in the Tools menu, select Tools > Options > SQL Server >...

    Full Story

  • SQL xp_findnextmsg and xp_readmail

    SQL xp_findnextmsg and xp_readmail

    Posted on November 15, 2009 | 2 Comments
    If you use SQL mail, you can read the messages in the SQL inbox stack and do stuff with them. Recently I had to use SQL scripting to find messages in the SQL inbox, read the message, determine if it is a text or html...

    Full Story

  • SQL Server Integration Services is the new Data Transformation tool for SQL Server

    SQL Server Integration Services is the new Data Transformation tool for SQL Server

    Posted on December 27, 2008 | No Comments
    I wrote this post months ago but didn’t get around to publish it. I know that SQL Server 2008 is now an available product but many of us are still using SQL Server 2005 and have created a lot Data Transformation Services (DTS) in the...

    Full Story

  • Database Mail vs SQL Mail in SQL Server 2005

    Database Mail vs SQL Mail in SQL Server 2005

    Posted on October 29, 2008 | 1 Comment
    SQL Mail was what one would use to send emails from SQL Server in the SQL Server 2000 version. But in SQL Server 2005, SQL Mail is considered legacy. Microsoft introduced a better email component called Database Mail for SQL Server 2005. In SQL Mail,...

    Full Story

Page 2 of 212
Add to Technorati Favorites   Gadgets Blog Directory     Technology blogs   Top Blogs   Technology blogs   Technology Blogs - Blog Top Sites   blog search directory   Josh`s Sanctum   Blogroll Me!   2RSS.com :: RSS directory   Page Ranking Tool   Directory   Blog Directory for Kingston upon Thames, Surrey   Blog Directory for Kingston upon Thames, Surrey     free web site traffic and promotion  

Add Your Blog Blog Site
Promote Your Blog
Free Blog Directory
Blogs Blog Tools Allie Marie Social Networking for Bloggers, Free Blog Submissions, Blog Traffic