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 @ii

else

...

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

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

- Did you use "NO RECOVERY" when restoring database on the MIRROR server?

Also, go thru this link:

http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx

Manu

Try this. Hope it works.

Create PROCEDURE dbo.s_test

AS

SET NOCOUNT ON

-- declare all variables

DECLARE @sdbname SYSNAME

DECLARE @Account SYSNAME

DECLARE @VHOName SYSNAME

DECLARE @sSQL VARCHAR(150)

DECLARE @sSQL1 VARCHAR(150)

DECLARE @iRowCount INT

DECLARE...