same of above

Quite simple. You can use the query analyzer for this.

use dbToCreateStoredProcedureIn /*making sure of the right database*/

CREATE PROCEDURE dbo.qryInvoice

/*all items should be owned by dbo*/

AS

SET NOCOUNT ON /*generally not needed...

not sure if sql server has a default for rowcount

What does

SET ROWCOUNT 0 /*all rows*/

select *

from  ....

gives

you can query your connection settings with

DBCC USEROPTIONS

1) remember that a trigger is set-based

runs 1 time per command

2)how would you implement a trigger that stops the same

employee from having the two salaries on the same

day...so...

What do you mean with connect as default user?

Are you supplying an account name or is this using windows authentication?

The more compilations have an impact on the cpu usage. Cpu usage increased due blocking seems plausible: maintaining & checking locks, managing queues...

Mostly when my server is restarted it gets...

Odd issue, but thanks for posting

1)There is no difference between a view and a simple select for performance.

Beware of making views based upon views ->effect performance (possible to much data joined)

2)Views usually haven't and don't need...

1) take a backup of the current version

2)Try compacting & repairing in Access + recompile the code

3)See if everything got back to normal

4)Try decompiling your vba modules (start Access with...

This asks for a normalisation of the database. http://www.tutorialized.com/tutorial/Normalisation/7433

This is because you rely on implicit conversion between varchar and datetime

by default convert/cast use the mon dd yyyy hh:miAM format

when casting datetime to varchar

1) the EXEC sp_executeSql @SqlString

can be dropped, no need for dynamic sql here

2)There can be a few inner joins

3) The owner of the tables should be specified for better performance

SELECT...

What method/program you use to connect to your MSDE server?

1)Always gives the fields a name instead of using SELECT *

INSERT INTO dbo.ORDERS

(Id_record, Id_title, Customer, Order_ID)

SELECT Id_record, Id_title, Customer, @random

FROM dbo.Cart CART

WHERE Cart.Customer = @user

The query analyzer can script...

You indeed have to update the client tools of who connects to sql server sp4.