SqlServer-QA.net

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, not an easy to find out what is ...

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 ...

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 T. Boyer, Premier Application Development ...

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 aka 'SQL Queen' has blogged a ...

  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 table scripts(sps varchar(8000))   declare @texts ...

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 2005 using Management Studio. To ...

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard EditionNotification 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 memory to continue the execution of the ...

Most of the times you have observed to identify the blocking and how to resolve them. How about you need a script to generate a blocking scenario within your queries, this is to identify the blocker script is working or not. Also will help to test whether the alerting tool is working or not. (I have used Northwin database to stage the ...

The following query will get you the information to find out the groups that contain user login token on that server principal:    SELECT name, usage, type FROM sys.login_token   ORDER BY usage, type, name go To find any Windows principal in the token that has an entry in SQL Server server_principals view ...

Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise X64 EditionNotification Contents: New and All Modifications You may be unable to execute SQL Server 2005 Integration Services packages that contain script tasks or script componentshttp://support.microsoft.com/kb/931846/en-US