Blog Archives

Difference Between SQL Server Compact Edition and SQL Server Express edition

Do you know the difference between SQL Server Compact edition and SQL Server Express edition? Which one would you prefer SQL Server Compact Edition or SQL Server Express Edition? Here it is if you don’t have an idea about that…

Posted in Microsoft Technology Tagged with:

Nested Stored Procedure Calls with SQL Server Transactions

I found good article about how to manage SQL Server transaction in nested stored procedure call . here is the link

Posted in Microsoft Technology Tagged with:

The backup set holds a backup of a database other than the existing database

I was trying to restore database using T-SQL and I ended up with error message “Msg 3154, Level 16, State 4, Line 1 The backup set holds a backup of a database other than the existing ‘GlobalObjects’ database.”. Sometimes I

Posted in Microsoft Technology Tagged with:

Web Services in SQL Server 2005

I was looking into how we can create a web service in sql server rather than traditional way (using IIS in .net). I found the good article. Here is the link. http://davidhayden.com/blog/dave/archive/2006/03/30/2896.aspx Another interesting topic is how stored procedure can

Posted in Microsoft Technology Tagged with: ,

SQL Server Management Studio – Hangs forever while connecting local/remote server

I am having the problem connecting the local as well as remote server using SQL Server management studio 2005. I just enter the server name, Login , password and hit the connect button, It just hangs forever and I am

Posted in Microsoft Technology Tagged with:

Difference between IDENT_CURRENT, @@IDENTITY,SCOPE_IDENTITY

It’s good to know the difference between IDENT_CURRENT, @@IDENTITY,SCOPE_IDENTITY. Here is little bit more information about these terms. IDENT_CURRENT is similar to the SQL Server 2000 identity functions SCOPE_IDENTITY and @@IDENTITY. All three functions return last-generated identity values. However, the

Posted in Microsoft Technology Tagged with:

Working with XML Data in SQL Server 2005

XML is one of the data types in SQL Server 2005.It is considered as one of the significant changes introduced in SQL Server 2005.In the previous versions, storing and retrieving XML data were possible but it was not as easy

Posted in Microsoft Technology Tagged with:

Access .Net functions in SQL Server 2005 Using CLR

According to Microsoft, SQL Server 2005 significantly enhances the database programming model by hosting the Microsoft .NET Framework 2.0 Common Language Runtime (CLR). This enables developers to write procedures, triggers, and functions in any of the CLR languages, particularly Microsoft

Posted in Microsoft Technology Tagged with:

SQL Server Database Publishing Toolkit for Web Hosting

The SQL Server Hosting Toolkit is a free download that makes it super easy to create a .SQL script file capable of re-creating your database (including the schema, sprocs, and actual data content). When it is installed you can simply

Posted in Microsoft Technology Tagged with:

SQL Server 2000 Limits

Keep the following things in mind while working with SQL Server 2000. Features column name length -> 128 index name length -> 128 table name length -> 128 max indexes per table -> 250 index length -> 900 max index column length -> 900 columns per

Posted in Microsoft Technology Tagged with:

Ads

OutbackDirect.co.uk is a trading site of World of Power.co.uk Limited. Outback Direct is the official Outback Consumer Warranty, Parts and Accessory Partners for the UK. We currently hold in stock 1000’s of parts and accessories for current and older Outback barbecues. We endeavour to ensure rapid and secure product delivery the length and breadth of mainland United Kingdom, this factor coupled with our excellent customer service has led to the market position we currently enjoy.
outback barbecue
omega 300 gas barbecue
Omega 250 Gas Hooded BBQ
Blog
Blog
------------------------------------------------------------ Silver Sky Imports is a unique online marketplace that offers unique handicrafts from Tibet and Nepal. Launched in 2003, Silver Sky Imports is currently the largest supplier of handmade items from the Himalayas. We specialize in the largest variety of Tibetan Singing Bowls and Crystal Singing Bowls online and include individual sound samples, pictures and descriptions for each bowl. Some of our other products include Tibetan Prayer Flags, Tingshas, Bell and Dorje, Incense, Felted Wool Handbags, Wood Masks, Prayer Wheels, Gongs, Bronze Statues, and Tibetan Meditation Rugs. monks
Blog
------------------------------------------------------------ Airpush, a mobile ad network that is only two years old, has quickly grown to one with over 5,000 advertisers. One thing they've heard from that sea of advertisers over the past 12 months, and especially over the past six, is that real-time bidding (RTB) capabilities are now a must. To answer those needs, the company today unveiled AirDSP, a platform meant to easily connect advertisers to RTB exchanges. Read more: Mobile RTB
Blog
Blog
------------------------------------------------------------ Danish site about electronic cigarettes E Cigarette, Electronic Cigarette and E Cigarettes e cigaret
------------------------------------------------------------ DrugRisks.com drugrisk​ recall ​informat​ion​ drugrisk​ yaz​
------------------------------------------------------------