Stored procedure: Compilation, pre-compilation and recompilation

by Administrator 18. February 2010 02:03

This topic describes about compilation of stored procedure [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: stored procedure, compile, pre-compile, recompile

◦Microsoft Community Tech Days in Ahmedabad on 30th January, 2010

by Administrator 12. January 2010 17:57

Hi All, Most wanted community tech days has been planned by Microsoft in different cities of India and it will happen on 30th January, 2010 in Ahmedabad. So do not miss this great opportunity. if you are not able to be attend in person than you can attend it online as well. Then ... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: microsoft, techdays, community, ahmedabad

SQLCelebrity.com | Microsoft SQL Server

Powers of SERVERPROPERTY function in sql server !!!!!

by Administrator 2. July 2009 17:43

We can get instance name, version, collation, security related settings, license related informaton and many more [More]

Currently rated 5.0 by 2 people

Currently 5/5 Stars.
1
2
3
4
5

Tags: serverproperty, server, property, server property

SQLCelebrity.com | Microsoft SQL Server

Tech-Ed on Road on June 20, 2009 in Ahmedabad

by Administrator 9. June 2009 11:14

It is completed. It was nice to see all of you!!

Currently rated 5.0 by 2 people

Currently 5/5 Stars.
1
2
3
4
5

Tags: tech-ed, ahmedabad, sql pass

SQLCelebrity.com | Microsoft SQL Server

Tips of the day !!! - How to find tables with columns name for which default value is assigned and which columns have identity insert ON?

by Administrator 9. June 2009 11:03

Query to find the identity columns and detault values of all the columns for all the tables of the databae [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags: default, identity(), constraints, sys.tables, sys.columns, sys.default_constraints, sys.objects

SQLCelebrity.com | Microsoft SQL Server

Tips of the day !!! - How to find tables with columns name for which default value is assigned and which columns have identity insert ON?

by Administrator 9. June 2009 11:03

Microsoft Import and Export wizard feature is best but it has some limitations .... 1. It cannot create IDENTITY columns as same as source. 2. It cannot create DEFAULT CONSTRAINTS for columns as same as source. 3. etc. In this case user will required to check all the tabl... [More]

Be the first to rate this post

Currently 0/5 Stars.
1
2
3
4
5

Tags:

Database Mail in simple and sample way ...

by Administrator 19. March 2009 10:03

This topic describes about advantages, usage about Databae Mail. Also we have mentioned the basic difference between Database Mail and SQL Mail. [More]

Currently rated 5.0 by 2 people