Sunday, April 22, 2007

What's the version of SQL Server?

I have seen this question (see post's subject) so many times in newsgroup asking people, so I decided to post some usefull info about SQL Server by using SERVERPROPERTY command.

SELECT @@VERSION AS [Server Information]

SELECT SERVERPROPERTY('ServerName') AS [ServerName]
SELECT SERVERPROPERTY('MachineName') AS [MachineName]
SELECT SERVERPROPERTY('InstanceName') AS [InstanceName]

SELECT SERVERPROPERTY('productversion') AS [ProductVersion]
SELECT SERVERPROPERTY('ProductLevel') AS [ProductLevel]
SELECT SERVERPROPERTY('Edition') AS [Edition]

SELECT SERVERPROPERTY('Collation') AS [Collation]
SELECT SERVERPROPERTY('IsClustered') AS [IsClustered]
SELECT SERVERPROPERTY('IsFullTextInstalled') AS [IsFullTextInstalled]
SELECT SERVERPROPERTY('IsIntegratedSecurityOnly') AS
[IsIntegratedSecurityOnly]
SELECT SERVERPROPERTY('LicenseType') AS [LicenseType]
SELECT SERVERPROPERTY('NumLicenses') AS [NumLicenses]

11 comments:

Anonymous said...

I am grateful to you for this great content.aöf thanks radyo dinle cool hikaye very nice sskonlycinsellik very nice ehliyet turhoq home free kadın last go korku jomax med olsaoy hikaye lesto go mp3 indir free only film izle

Anonymous said...

"Why...? Don't you need someone to pose as your girlfriend this year?" Then he answered, "No, there is no need for that anymore......"
Before he can continue, he was interrupted, discount nike shoes"Oh yes! Must have found a girlfriend! nike shox r4 You haven't been searching for one for the past years, right?" The man looked up, as if he has struck gold, his face beamed and looked directly at the drunken girl. tn dollarHe replied, "Yes......you are right! I haven't been looking for anyone for the past years."
With that, the man darted across the floor and out the door, cheap nike shoesleaving the lady in much bewilderment. He finally realized that he has already found his dream girl, and she was.....the Vancouver girl all along! The drunken lady has said something that awoken him.
All along he has found his girl.nike tennis shoes That was why he did not bother to look further when he realized she was not coming back. It was not any specific girl he was seeking! cheap nike shoxIt was perfection that he wanted, and yes.....perfection!!
Relationship is something both parties should work on. Realizing that he had let away someone so important in his life, he decided to call her immediately. His whole mind was flooded with fear.free shipping shoes He was afraid that she might have found someone new or no longer had the same feelings anymore..... For once, he felt the fear of losing someone.
As it was Christmas eve, the line was quite hard to get through, especially an overseas call. He tried again and again, never giving up. Finally, he got through......precisely at 1200 midnight. He confessed his love for her and the girl was moved to tears. nike shoes It seemed that she never got over him! Even after so long, she was still waiting for him, never giving up.
He was so excited to meet her and to begin his new chapter of their lives. He decided to fly to Vancouver to join her. It was the happiest time of their lives! nike discount shoes But their happy time was short-lived. Two days before he was supposed to fly to Vancouver,cheap puma shoes he received a call from her father. She had a head-on car collision with a drunken driver. nike shox shoes She passed away after 6 hours in a coma.
The guy was devastated, as it was a complete loss. Why did fate played such cruel games with him? He cursed the heaven for taking her away from him, denying even one last look at her! How cruel he cursed! How he damned the Gods...!!nike free shoes How he hated himself....for taking so long to realize his mistake!! That was in 1996.
The moral of this story is :
Treasure what you have...
Time is too slow for those who wait;
Too swift for those who fear;
Too long for those who grief;
Too short for those who rejoice;
But for those who love...
Time is Eternity.
For all you out there with someone special in your heart, cherish that person, cherish every moment that you spend together that special someone, for in life, anything can happen anytime. buy shoes onlineYou may painfully regret, only to realise that it is too late.

Anonymous said...

Hi, I like your blog, it's, you know, wonderful. I learn a lot from it.
Recently, I am always wanting to buy high quality, low price prince tennis rackets, and I find many places, where sells perfect tennis racket. In order to play the game and search the place where can buy the head tennis racket, and finally, I find thistennis shop. You can buy what you want in this store online.
Would you want to be more attractive? If your answer is "Yes", you can wear best-seller columbia jacket, you really need a pair of white ralph lauren jacket. They can make you become the attactive person.
Would you like wearing cheap polo shirt? Do you want to be a fashion chaser? Follow me and you can chase the most popular white polo shirts. it can help you increase your attraction, you will be the focus wherever you go only if you wear polo clothes.
polo shirt women
polo shirts men's
cheap polo jacket
high quality columbia jacket
claasic north face jacket
perfect spyder jacket
ralph Lauren shirts
polo A&F shirts
polo shirt
north face jackets
polo short sleeves shirt
ralph lauren polo long sleeves shirts
prince accessories
cheap head tennis racquets
wilson tennis racquets
superior babolat tennis racquets
head tennis racquet
babolat racquet
wilson tennis racquets

Cathy Mena said...

I don't know much about the SQL. But just now I join a course in which I'll learn different languages.wholesale designer sunglasses

Nike shox said...

Relationship is something both parties should work on. Nike shox

aiya said...
This comment has been removed by a blog administrator.
Knox Karter said...

There Is Obviously a lot to know about this. I suppose you made Some Great points in the Feature also.
Retail Management Logo

Knox Karter said...

Its amazing, looking at the time and effort you put into your blog and detailed information you provide. I'll bookmark your blog and visit it weekly for your new posts.

Ready-Made Logo

Unknown said...

Thanks for the information. I really enjoyed, I would like get more
information about this,because is very beautiful, thanks for sharing. Lux Style Awards

Unknown said...

nice post and amazing information for us please keep up that’s blog is amazing. Amazon Promo Codes
American Eagle Promo Code
AutoZone Coupons
Barnes & Noble Coupon Code
Barneys Warehouse Coupons
bebe Coupon Codes
Bed Bath and Beyond Coupon
Best Buy Coupons
Bluefly Coupon Codes
Groupon Promo Codes
Haggar Coupons
JcPenney Coupons
Kohls Coupons
Light In The Box Coupons
Macy's Coupon
Next Day Flyers Coupon Codes
Overstock Promo Codes
Sears Coupons
SmartBargains Coupons
Target Promo Codes
Walmart Coupon Codes
Woot Coupon Codes

angel said...

Fake Cheap Hermes Bags,
Replica Celine Bags For Sale,Replica Fashion Sunglasses,
Fake Belts Online