Thanks for the advice...........

That worked on my server here where the view is dbo, tables are all dbo.

When catalog is left blank i do see DISA and DISB however as the select is...

Anyone got anything else on this i cannot fix this.

I have done same thing.

DATABASEA UserX View select x from DATABASEB.TABLEB filtered by x

DATABASEB UserX

All works the problem is when i gave the linked server information to another part...

I had the same thing happen to me you just cannot get into activity to see anything you get the lock timeout in the studio.

I still not found out why..........is...

Here's how I see it:

1. you have defined a user Linked_ASRC on DISB to have access to a table

Yes

2. you have configured the...

SQL 2005

i put together some test examples

http://www.stretchunlimited.com/LINKED.DOC

Scratching my head how to fix.

If the catalog is entered everything is fine........but the other parts of organisation may not put this catalog...

Hi go to here http://safari.peachpit.com/

It cost 20$ a month and you can read up to 10 books at a time......Any SQL book any thing you want...Its the best 20 bucks...

4 GIG right now...........i have seen it go to 118 gig nice little runaway script lol.

I do some invesitgation and run the various growth and see what they grew to...

So you have the mdf, ldf and 4 other ndf what sizes did you make your temp files and did you set up a max growth size ...

I will look...

Thanks re the ndf files...

For training - yes i would recommend new horizons i did that course for SQL 2005.

Forums are good too - people always willing to...

Did not know this...so im trying this out.

Fire up Perfmon, select the Thread object, % Processor Time counter and all instances of sqlservr. Switch to Chart/Histogram view.

If it is...

Totally agree with SSC Veteran...

Get rid of the merge replication i can see what your doing.

MAIN SQL ------User in Field 1 merge data goes to their laptop...

...

Thanks i knew it was something ...

Thats a good thread - so first monitor and then determine if you need more files.

If you add more files - Do you add first a new FILEGROUP

Or just...