As this edition is the most complete one, it is why i advice on the MSDN forums to install it instead the "simple" edition which does not include SSMSE. Moreover,if SSMSE must be installed ( it is necessary except maybe with applications using user-ins...

I have developped on Windows since 20 years and i know this tip since this far time. But i had to ask it to my elder boy 2 months ago as i was not sure that i must use it with ALT or CTRL + ALT ( i am using it around twice in a year ). I remarked that y...

In a more modern way, it is possible to use a script inside PowerShell, with 2 problems : - the requirement to know SMO ( SQL Server Management Objects ) - the obligation to check whether the classes have not been moved from a namespace to another on...

Hello Eric, I used SQL Server 2005 Express, but i wanted to upgrade it to 2008, i got many problems.I have reinstalled my XP Pro and i have a SQL Servr Developer 2008 and Express 2008 with Reporting Services. As i am going often on the SQL Server Fo...

Why it would be annoying ? The 3 ntext,text,image datatypes have depreciated since the release of SQL Server 2005 and no longer supported with Denali ( SQL Server 2012 ).Yes, there is a simple workround : to replace these 3 datatypes by those which arri...

A small problem : when i click on Read More... , i am receiving 404 - File or directory not found...

I prefer to use REPLICATE as SPACE is unuseable for NCHAR and NVARCHAR data types ( i think that unicode will take a bigger importance with the arrival of complex languages like chinese or from India, arabic ( or arab i don't know the good word in engli...

Ramireddy, i am sorry not to have noticed that the author of the tip provided the source just at the end of his tip. I hope you ( and the tip author ) will excuse me as i am studying Just learned only a few weeks, so i have not discovered all the featu...

Hello, Please, could you provide the link towards this article ? Anyway, i have the habit to include in my catch a call to a method to display informations about the exception ( more exactly , i have written several methods for the main exceptions i h...

Hello huslayer and Nakul, only one default instance on a computer . The name of the SQL Server service is not built in the same way for a default instance (MSSQLServer) and a named instance ( MSSQL$shortinstancename), idem for the Reporting/SSIS/An...