Have a look at http://www.ethereal.com/ but to really make it work will depend on what do you want to accomplish an how your network is setup

HTH

Also,

To minimize the impact you can use and ALIAS on the linked server to increase portability also you could embed the access through a view! so that only references to...

OR

Select Distinct Col1, Col2

FROM

(

 Select col1, col2 from tblName

 UNION ALL

 Select col2, col1 from tblName

  ) Q

HTH

Use the FORMATFILE to specify what you want from it

HTH

There is no such level of tuning on SQL server indexes. The most you can specify is PAD index to apply that(Fill Factor) to all index pages instead of to...

As long as adding is related the recompilaton will happen nexttime your procs is executed automatically. If you use select *.. on your views you will have to execute sp_refreshview...

... Integrity and honesty, do only lawyers and auditors have it?

really ?

And Adding to mkeast : instead of aggregating you should use existence check!

Like:

if exists (select * from table

 where year = @year

 and period = @period

 and category = @category

 and...

Check the quoted identifier setting on your connections they should be different if you get those results. IMO you should use Menuename = '' instead of Menuename = "" and...

I don't understant very well what you are trying to accomplish but I think you may want something like this:

update p

set

totalapps = Case when @updatecareerapps = 1 then b.apps else Null...

... and adding to jxflagg as of SQL 2000 you can disable a constraint but can't disable an index.

In my opinion is an option that only at application level you...

Check Parenthesis. I may have a written those incorrectly 

(dbo.udf_RatingExists(Rating) = 1 

AND ... )

HTH

What is wrong with

ALTER TABLE #Result Add  InvoiceNo int Null -- If Necessary only

Update R Set InvoceNo = Next.No

From

 #Result R

 Join

 (Select R1.[Project Number] PN ,( Select Count(Distinct...

For This Kind of things you may want to use a FUNCTION!

Like

CREATE FUNCTION dbo.udf_RatingExists(@Rating varchar (20))

returns int

as

begin

 if exits(select * from FROM StringMapping WHERE Type = 'CREDIT_RATING' and Name...

From BOL:

1 = autoclose; set with sp_dboption.

4 = select into/bulkcopy; set with sp_dboption.

8 = trunc. log on chkpt; set with sp_dboption.

16 = torn page detection, set with sp_dboption.

32 = loading.

64...