|
|
-
|
|
2003, 2008, 2008 R2
SQL Server 2000, 2005, 2008, 2008 R2, 2012
*/
sp_configure 'show advanced options',1
RECONFIGURE WITH OVERRIDE
GO
sp_configure 'xp_cmdshell',1
RECONFIGURE WITH OVERRIDE
GO
DECLARE @TimeZone NVARCHAR(100)
,@ProductVersion SYSNA...
|
|
-
|
|
Introduction Recently, I was asked to develop a SSRS based report for the Event Management module in MS Dynamics CRM 2011. The idea was to show a Calendar for the selected month and each cell of the calendar should display the scheduled events of that day...
|
|
-
|
|
Were you ever asked to generate string Permutations using TSql? I was recently asked to do so, and the logic which I could manage to come up at that point is shared in the below script.
DECLARE @Value AS VARCHAR(20) = 'ABCC' --Mention the text which is t...
|
|
-
|
|
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are times when we need to find out records matching a criteria from all the tables of a SQL Database and today I will explain you a simple way to ...
|
|
-
|
|
Few months back I have wrote post about moving MASTER and MSDB database to new location in stand alone machine. In recent past we had a situation where customer asked us to move MASTER database to new location, below are the steps I have taken: ...
|
|
-
|
|
Today, I am going to share few very useful scripts which will report us on Database Backup from different view points. To get the List/History/Log of all the Successful Backups SELECT b.machine_name, b.server_name, b.database_name...
|
|
-
|
|
Problem Statement SQL Server has got in-built functions to convert the given string into LOWER() or UPPER() format but it does not provides any direct way to convert it to PROPER format. A string/text is said to be in a PROPER format if all the words in t...
|
|
-
|
|
It's my bad that I did not made a post since long lately. I would not make an excuse like I was busy, rather, I would say I am little lazy DBA, but I now onward I will try to post blog more frequently.
Well, if you remember, earlier I have posted som...
|
|
-
|
|
Introduction Today, I would like to explain one way in which we can store the HIERARCHICAL data in SQL tables. A general table structure which people come up to store this kind of data is - Where, EmployeeID id the UniqueID alloted to every new employee ...
|
|
-
|
|
On many forums I have found a very basic yet important query - “How can I know when was my Stored Procedure last executed?” And today through this blog I will try to answer this question.
Actually speaking, without explicit logging or tracing, it is not p...
|
|