use snapshot isolation level. *This require more tempdb.... manage tempdb carefully.

1. Try to make the distributor job at least for 15mins.

2. *Snapshot isolation will take care of blocking.

3. in...

I could say:

1. change the schedule for distributor so as to run could be after 1hr(if possible)

2. as you said its a reporting database try to use (NOLOCK) hint *this...

server_name,port_number

or

ip,port_number

Dont know why last post could not see this.

try this.

,

or

,

FYI.

http://www.haidongji.com/2006/02/15/connect-to-sql-server-2005-using-query-analyzer-osql-and-isql/

HTH.

Vinay

you can send a mail from sql server 2000 with two ways (as of i know).

Sql Mail:-

Setup the outlook on sql server and configure and send a mail.

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

SMTP :

if...

Looks like that column you made changes is filtered... check

publiser->Property-> filter.

hth.

You have to run index maintainance plane on subsciber as well....

also for reporting performance porpose you can add/ chage the index on subsciber index on

HTH.

You can use ODBC - DSN....

This si what i found when google.

http://www.webcheatsheet.com/ASP/database_connection_to_MSSQL.php

HTH.

Thanx Terry for reply.

System is doing good so far, but I feel if we could change the compatibility. It will generate good compile and execition plan and will work better....

BOL:

Use DBCC FREEPROCCACHE to clear the procedure cache. Freeing the procedure cache would cause, for example, an ad-hoc SQL statement to be recompiled rather than reused from the cache.

Looks like...

http://sqlblog.com/blogs/michael_zilberstein/archive/2009/02/05/11734.aspx

hth.

Vinay

as we could see you are creating a trace with filters:

#exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Profiler'

#set @bigintfilter = 1000

#exec sp_trace_setfilter @TraceID, 13, 0, 4, @bigintfilter

#set @intfilter = 100

#exec...

you want to remove the replication right?

if yes:

sp_removedbreplication "DB Name"

and restart you services...

HTH

Vinay

What OS are you using??

BOL:

Note The Windows NT Performance Monitor is available only when using Microsoft Windows NT® 4.0 as the operating system.

I elaborate my question:

1. What would be impact of changing sql server 65 compatibility to 80?

2. All tables are having ansi NULL off, that will not change automatically, Do I...