How Many Full-text indexes can one have per Table?
Only One Full-Text is allowed per table or indexed view. (SQLServer) Reference: http://msdn.microsoft.com/en-us/library/ms187317.aspx
Category : Databases
Mysl, MSSQL, Oracle, SQLITE, POSTGRES
Order Time SQL Server
Let’s say you want to order these times below. of course a simple “order by” will not do it, what you need is the query given below 1:00 PM, 1:30 PM, 10:00 AM, 10:30 AM, … Read more
Give a user execute permission to all Stored Procedures of a Single Database (MSSQL)
System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object … This usually happens if the user does not have execute permission on the stored procedures that the application is calling. While there might be many … Read more
Reporting Services Headers and Footers
Adding Header and Footers on your reports. http://technet.microsoft.com/en-us/library/ms156326.aspx According to the article, “On the design surface, right-click the report”. The “design surface” is shown below. If you are working with 8.5 by 11 pages, make … Read more
Restore Transaction Logs Grayed out (Disabled) in SSMS
You need to restore the transaction logs and when you ready to do so, you pull up SSMS (SQL Server Management Studio) and see the following: So now what! FYI: You cannot restore Transaction logs … Read more