CTP has been made available earlier this week for SQL Server 2008 SP3 on Download Center. Read this MSDN blog post to get highlights of what has been updated. Download Links: SQL Server 2008 SP3 CTP: http://go.microsoft.com/fwlink/?LinkId=226850 SQL Server 2008 SP3 Express CTP: http://go.microsoft.com...
Posted to
Vishal Gajjar's Blog
by
Vishal Gajjar
on
08-25-2011
Filed under:
Filed under: SQLServer, SQL, Database, Sql And Me, SQLServer 2008, SqlAndMe, Vishal Gajjar, Vishal, Sql&Me, SQL Server, Service Pack, ctp service pack, sql 2008 sp3 ctp, sp3
sp_help returns information about database objects and types. @object_name argument is optional for sp_help . When executed without any argument it returns summary information for objects of all types in the database. These includes all user tables, system tables, stored procedures, functions, extended...
Posted to
Vishal Gajjar's Blog
by
Vishal Gajjar
on
08-24-2011
Filed under:
Filed under: SQL FAQ, SQLServer, SQL, Tips & Tricks, Database, Sql And Me, System Functions, SQLServer 2008 R2, list all system functions procedures, scripts, SqlAndMe, Vishal Gajjar, Query, sp_help, Vishal, Sql&Me, list all objects, SQL 2008 R2, SQL Server
You can browse available SQL Instances on network by choosing " <Browse for More..> " from Server Name drop-down list in " Connect to Server " dialog box in Management Studio: As you can see from the screen shot, all of my instances are visible on the network. If I want to hide...
Posted to
Vishal Gajjar's Blog
by
Vishal Gajjar
on
08-23-2011
Filed under:
Filed under: SQL FAQ, SQLServer, SQL, Tips & Tricks, Database, Sql And Me, Undocumented, Management Studio, SQLServer 2008 R2, scripts, SqlAndMe, Vishal Gajjar, Query, Vishal, Sql&Me, SQL 2008 R2, SQL Server, Extended procedures, sql browser hide, undocumented procedures, change registry value to hide instance, HideInstance, xp_instance_regwrite, hide instance, hide sql instance, xp_instance_regread