AWE is used for memory above 4GB. Yes it does gests used mostly for data cache but that *helps*. It will never be as much as in a 64 bit...

Other drawbacks of the ADT:

* When you need to "change" the type the effort is more than with native

* When dealing with temporary tables you have to have them in...

Please do not cross post. See my answer on your other post.

Make sure you install SP2 of SQL Server 2005 in order for it to run on VISTA

Check the Results tab in the Configuration Options in QA make sure that max char per column is set to 8000

to see the progress in T-SQL you add STATUS=10 for example and your client will recieve a message every 10% completion. If what you want to know is how...

Indexes in temp tables *DO* benefit performance *IF* the amount of data in them is large, otherwise safe your effor.

you don't need to reboot to do that. Yo can use the rude way to set it up in single user.

ALTER DATABASE dbName

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE

GO

ALTER DATABASE dbName

MOFIFIY FILE (...

you need to change you If statemets to

IF EXISTS (...) AND NOT EXISTS (...)

BEGIN

raiserror('Can not do this',16,1)

rollback transaction fixduplicate

return

END

That is a "provider" issue. You need to contact them!

And this is how you find the Tables with Identity columns (asuming you have the rights )

SELECT TABLE_SCHEMA, TABLE_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE COLUMNPROPERTY(OBJECT_ID(TABLE_NAME),COLUMN_NAME,'ISIDENTITY') = 1

Wow 37 pages, what the heck is this ?

Have a look at SELECT TOP * 10 PERCENT ... ORDER BY and SELECT * TOP 10 PERCENT .... ORDER BY DESC

I believe the "order" of the statements should be rearranged as :

IF EXISTS (SELECT * FROM dbo.SysObjects WHERE Name = 'DemoCnst' AND XType = 'U' AND USER_NAME(uid) = 'dbo')

DROP TABLE...

Try creating an Oracle Linked server.