I would like to refer this Interesting thread that talks about advantages you can take with Profile when you have a need of refactoring the database objects between old & new versions, useful tips on the post too.

In case you have many snapshots generated within your Replication setup and having troubles in finding what kind of scheduled job is running during the time of snapshot publication. By default you coudl take help of system catalog MSsnapshot_agents and further query against sys.sysjobs or sys.sysjobsteps...

A newbie set of question that how to know the whether the current server is distributor or publisher? Any pre-defined script to know any other publishers that are using as Distributor? Well, there are such pre-defined scripts and stored procedures are availble within the SQL Server documentation such...

As you may be aware you can take help of Registry settings in order to copy the SQL Server list that are managed from the Central Managed server. I have seen this VBScript posted by Mohammed U posted the following script, you can save it as .VBS that works only for window logins. '* Author: Mark...

Here is the incentive for the SQL Server users (this new year), you may be aware then using SP_HELPINDEX or SP_HELP could give some part of information on the indexes and database objects. But to know more about depedant columns you need to query INFORMATION_SCHEMA views or sys.index_columns. Kalen Delaney...

Part 1 uses information_Schema.routines view and this is based on sp_helptext declare @sps table ( texts varchar ( 8000 )) insert into @sps select 'sp_helptext ''' + name + '''' from sysobjects where xtype in ( 'p' , 'fn' ) order by xtype , name create...

One of the Developer complained that he is unable to create one file per object using Generating SQL Scripts within Management Studio. It is one of the good feature within SQL Server 2000 using Enterprise Manager where you can differentiate the objects per file, and it is still available within SQL Server...

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a Script Component transformation:”Insufficient...