http://www.sql-server-performance.com/gv_stress_test_lessons_3.asp

http://www.microsoft.com/downloads/details.aspx?FamilyId=5691AB53-893A-4AAF-B4A6-9A8BB9669A8B&displaylang=en

There are some third party tools if you want to spend money...

http://www.keynote.com/

It is woking fine on 2000 and 2005 sql server.

Make sure login exists...try the following...

declare @login sysname

select @login = 'AIB\aipd'

select @login

if exists (select * from syslogins where name = @login)

EXEC...

You can use CONTENT button in 2005 to get the same info.

You can create a function and update the table using function...

you can use the function from the following url..

http://sqljunkies.com/Forums/ShowPost.aspx?PostID=11222

You can download trial version and use it.

Microsoft SQL Server 2005 Enterprise Evaluation Edition

http://www.microsoft.com/downloads/details.aspx?familyid=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en

PRB: Log Reader Agent Does Not Function and You Receive an Error Message During Transaction Replication

http://support.microsoft.com/kb/811030

You can also log the error message for troubleshooting...

How to enable replication agents for...

Script out the complete replication setup to a text file

http://www.replicationanswers.com/Script5.asp

Script out the replication setup to a series of files - one per replicated...

You can script the replication through Enterprise Manager and also can be done using SQL DMO.

Script the replication when you are running on different server you need to replace the...

To script procedures, triggers and views you can use OBJECT_DEFINITION function in sql 2005 and it is very simpled...

Check BOL for more details...

SELECT OBJECT_DEFINITION (OBJECT_ID(N'sys.sp_columns')) AS [Object Definition];

OBJECT_DEFINITION applies to...

http://msdn2.microsoft.com/en-us/library/ms177443.aspx

FIX: The replication on the server does not work any longer when you manually fail over databases...

Yes, as along as the server has valid SQL SERVER 2005 licence, if you want to install on a seperate server than sql server then you need to buy seperate...

Here you go free tool..

http://www.sql-server-performance.com/news_releases/xsql_software_20060705.asp

http://www.x-sql.com/

If you want you can pass fileid or filename and size.

declare @sql Varchar(1000), @db sysname

select @db = 'pubs'

select @sql = 'use '+@db+' DBCC SHRINKFILE (1, 1000)'

EXEC( @sql)

  SELECT   b.database_name,

           b.backup_start_date,

           b.backup_finish_date,

           b.user_name,

           f.logical_name,

           f.physical_name,

           mf.physical_device_name,

           f.file_type,

           f.file_size,

           b.backup_size

  FROM     msdb.dbo.backupfile f,

           msdb.dbo.backupset b,

           msdb.dbo.backupmediafamily mf

  WHERE    f.backup_set_id = b.backup_set_id

           AND b.media_set_id = mf.media_set_id

AND b.database_name = 'pubs'

  ORDER...