How do you know if using kerbos ? and any more details on the kertray.exe

what is it to check for?

Just following along on the thread.

When setting up the linked server.

provstr 'Integrated security=SSPI"

SQL SERVER1 (Use domain\tracey)

MYFIRSTDB

...

One last thing,

REPORTDB

has TABLE DELT.ACCT

I couldn't do

CREATE SYNONYM DELT.ACCT AS REPORTDB.DELT.ACCT;

because the object exists as a table DELT.ACCT

If i have DATAWAREHOUSE...

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

This is just to set up the logins which is what i have done set up the logins to be identical on each server, but thanks anyway.

Here the data is on same disk F...so i was wondering if doing partition would infact give any performance gain being on the same DISK.

ALTER DATABASE PartitionTestBIG

ADD FILE

(

NAME =...

Is there a benefit of doing a partition on a table to the different filegroups and this still be on the same disk i.e F

I want to visit this soon...

Do you have a snapshot of any database as this will do the version control in tempdb.

With ms access and crystal reports users do not call stored procedures they see the entire tables and do their own coding i.e select * from table.

I tried to make...

Do you have the lock memory in pages set on in windows.

http://msdn.microsoft.com/en-us/library/ms190730.aspx

Also change the min memory to 8196.

Thanks i am working on it and implementing ....cheers

I.e

REPORTDB i change the synonym to be pointing to MAINDB if i did an udpate statement

update table statement (this would infact update MAINDB).

So i just making sure that any REPLICATION...

Question if i have the

PUBLISHED DB SERVER1 Database: MAINDB replicated to ----> REPORTDB (synonym) i repoint these back to PUBLISHED DB MAINDB so that i can...

I had to just confess i restored the wrong DB....ouch that hurts.

Thanks for the details.

Just tried it out, thats pretty good - thanks very much for sharing.

--Code change is FOR instead of AS.