The process is easy when you have all ingredients in place (handy) without any issues on the current environment. The Database Publishing Services are a set of ASP.NET web services you can easily deploy to make it simple for your customers to deploy SQL
Read More...
Using SSMS tool you can get information on tables, indexes and filegroup information for a database, how about using a TSQL statement: select 'table_name'=object_name(i.id) ,i.indid ,'index_name'=i.name ,i.groupid ,'filegroup'=f.name ,'file_name'=d.physical_name
Read More...
When you have tested the application for SQL Server 2005 comtability and upgrade process then your UPGRADE task will be easy to manage. But if you have used the Diagrams within SQL Server during the previous version, then there is a problem and here is
Read More...
With the recent release of Microsoft Office 2007 edition there has been many changes to the Business Intelligence arena that Microsoft business is offering with a flexible and various options to have a feature of 'Data Mining' in Excel spreadsheets, to
Read More...