Microsoft Access is quite easy to make query/reports with if you have/can setup linked tables (using readonly accounts).

You could match the size as closely to your datausage, so all the data still fits. (1500 MB)

you should have an END for every BEGIN

Use the ALTER DATABASE command (see the BOL)

& MODIFY FILE

Then you can set the "original size" of a file & rerun DBCC SHRINKDATABASE

Is there any policy set to prohibit account to be active in the weekends(no logon,firewall settings..)

found an article about the error:

http://www.examnotes.net/archive79-2002-8-55082.html

We're planning to go with option 1.

Application roles have to be set every connection.

Sure your security mapping is set right?

if you login , what does

SELECT 'The current user is: '+ convert(char(30), CURRENT_USER)return?

1)Beware that triggers are set-based

2)Only modified the second insert to include a check on contact1

CREATE TRIGGER Supp_contact_delete ON Contsupp

FOR DELETE

AS

SET NOCOUNT ON /*avoiding roundtrip, trigger doesn't return records*/

INSERT INTO...

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