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

goto agent profile->

Create new profile with:

log reader -QueryTimeout =10000...

re-run the log reader this will work.

HTH.

Thanx.

http://www.eggheadcafe.com/forumarchives/win32programmerkernel/Jun2005/post23439790.asp

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

http://support.microsoft.com/default.aspx?scid=kb;en-us;836769

eg.

SELECT * FROM ::fn_trace_gettable(('c:\my_trace.trc', -1)

GO

my_trace.trc is the profiler trace file you have to save it on you system and access it.

Its wierd ... I am working on transaction replication, but i would say... is your replication working? do you see any red mark on your replication monitor?

http://support.microsoft.com/?kbid=886839

HTH.

Vinay

For which DB your shirnk file is not working?

check:

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/fd161950-fa35-49ce-b494-1f30055b35f5/

HTH.

Vinay

you are having sql server 2000 and sys. schema are in sql server 2005+... so that will not work here.

see fn_trace_gettable() in BOL for more info.

What do you want to...

Hi,

See It all depends, for how many database, how big is the database(s), how much is the activity

generally I would go as follows:

If its a big database

>> I would...

What fill factor are you using?

See the BOL...

Sample % of the database

Generate distribution statistics by sampling the percentage of data in the tables. The higher the percentage, the more accurate the statistics, but the longer...

is your auto update statistics on... then I think no need to update the statistics manually...

if you are already having reindex job which is running depending upon the fragmentation... you...

I tested and its working.....

make the .bat file as

isql /S /U sa /P /d /i

create another query.txt file where you call the sp... as

exec usp_Vinay

HTH.

Vinay

We use perl... to run from .bat file.

perl is free.

Pl. let me know if want more info.

HTH.

Thanx.

Vinay

Master database is the startup database.... so when you restore the master database means you are making the same system for another database...

hence you have to make the same setup...