Browse by Tags

SQL Server Replication - resolving too many snapshots issues?

Published 15 April 8 6:15 AM | SSQA.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...

Filed under: sql server, replication, snapshot, sqlagent, script, publisher, tsql, schedule

Replication FAQ - how to know Distributor and Publisher with scripts

Published 19 February 8 4:45 PM | SSQA.net

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

Filed under: sql server, replication, snapshot, script, merge, publisher, transactional, distributor, schedule

Copy the SQL Server instances list from Enterprise Manager using vbscript

Published 7 February 8 2:34 AM | SSQA.net

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

Filed under: sql server, microsoft, script, instances, enterprise manager, copy, vbscript

SQL Server SP_HELPINDEX - updated version that includes column names

Published 3 January 8 1:46 PM | SSQA.net

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

Filed under: sql server, indexes, databases, sql queen, script, columns, kalen delaney, sp_help, included, sp_helpindex

Script out Procedures and Functions - Part 2

Published 13 December 7 7:57 AM | SSQA.net

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

Filed under: sql server, script

Using Management Studio unable to select "create one file per object"?

Published 17 October 7 4:6 AM | SSQA.net

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

Filed under: sql server, ssms, script, 2000, service pack2, 2005, management studio, enterprise manager, generate

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 program”

Published 20 August 7 2:41 PM | SSQA.net

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

Filed under: sql server, memory, ssis, kba, script

TSQL to generate blocking scenario for testing

Published 27 July 7 2:44 AM | SSQA.net

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

Filed under: sql server, blocking, query, script, tsql, tables, create

Script to find out all the groups contain in the login token for every server principal

Published 17 July 7 10:44 AM | SSQA.net

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

Filed under: sql server, security, users, login, script, token, principal

You may be unable to execute SQL Server 2005 Integration Services packages that contain script tasks or script components

Published 12 July 7 5:35 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications You may be unable to execute SQL Server 2005 Integration Services packages that contain script tasks or script components...

Filed under: sql server, package, ssis, kba, script

SQL 2005 TSQL Script to list tables, indexes, file groups along with file names

Published 25 June 7 7:39 AM | SSQA.net

Here is the script I have used to list the information regarding database objects such as tables, indexes and file groups along with their file names : ( extracted from Technet ) select 'table_name'=object_name(i.id) ,i.indid ,'index_name'...

Filed under: sql server, database, script, table, filegroup

KBA: You receive an error message after you install SQL Server 2005 Service Pack 2 when you try to edit a Script component that is inside an SSIS package and the SSIS package was created in an earlier version of SQL Server 2005

Published 13 June 7 12:49 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & Standard Edition Notification Contents: New and Major Modifications You receive an error message after you install SQL Server 2005 Service Pack 2 when you try to edit a...

Filed under: sql server, package, ssis, kba, version, script

Best way to generate DDL and data insert scripts

Published 11 June 7 8:53 AM | SSQA.net

There is no easy or best way, but few options are available such as DMO or SMO or even using Enterprise Manager for SQL 2000 or SS Management Studio for SQL 2005. Look for DBPublish wizard tool in this case that will help quite a bit and a lso you can...

Filed under: sql server, ssms, enterprise, smo, script, manager, dmo