What is temporal upward compatibility

Making that a future version can read the information off an older version?

X = null is always Unknown

Compare to NULL with X IS NULL

I'm not sure what {business_idx=$''STERILIZES''} does.

The query looks fine if there are indexes on businessid, ZIPID.

What does exec tdbExecuteReturnPageL @sql, 3, 20 ?

if the sql servers are based on windows 2003 servers, the errors come forth since windows 2003/xp security was added to microsoft transaction coordinator.

See:

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

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