If you have time please go thru this nice document:--

http://www.sqlservercentral.com/articles/Installation/clustering_a_sql_server_machine_/344/

Clustering SQL Server 2000 from 500 Feet.

Although urs is 2005 but concept of Active and passive configuration is...

I just meant that statistics are automatically created on columns used in a predicate. Adding statistics improves query performance because the SQL Server query optimizer can better determine how to...

Is Auto Create Statistics ON?

Also, even if Auto create statistics is ON there are chances of missing statistics on a column if that column was never referenced in where clause...

Try this:

UPDATE t

SET t.comp_mypassword = s.password

FROM Company t, Members s

WHERE t.comp_oldContactID = s.ContactID

AND t.comp_oldAddrID = s.AddrID

Manu

Cool one. Thanks Carl.

Manu Jaidka

Plz use the below mentioned code for scripting out user level permissions:

--Generates Database object permissions for SQL 2000.

SELECT user_name(p.grantor) AS GRANTOR ,

...

Go thru the document attached.

In case you have recurring deadlock issues then go thru the link mentioned below and you really dont knwo how to troubleshoot them:

http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx

Manu Jaidka

Please try with this:

Create trigger MyTrigDDL

on all server

for create_database

as

print 'create database issued.'

set nocount on

declare...

Chris,

Have you specified any file extension in extensions box? Try specifying *.* and see if it deletes the old files now.

Manu

Execution plans are stored in cache and if your sql server is running low on memory then they are flushed out at regular intervals. Each database maintains its own cache...

Try this function:-

-- select dbo.f_firstposition('abc,def,ccc,ged','e',1)

-- go

-- Result:4

create function dbo.f_firstposition

(@Str varchar(8000),@StrSep varchar(10),@AppPos int)

returns int

begin

declare @i int

declare @ii int

set @STR=rtrim(ltrim(@Str))--'abc,def,ccc,ged',',',3

set @i=1

select @ii=charindex(@StrSep,@Str)

if @i=@AppPos

return...

Steps:-

1. Script out tables and constraints,indexes,triggers etc. definition at the source server(using right click generate script wizard).

2. Execute only the table creation statement(only create table statements not constraints, triggers etc.)...

Go thru this link:

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx#EYD

Its pointing to "Transactional Replication Performance Tuning and Optimization" doc. Also, if load is high then its better to have separate distributor or you can...

Kathy,

I think its just due to heavy load on server when snapshot agent was executed. Just execute it once again and also look for CPU and memory counters while agent...