we use this one at our shop:

primary key and foreign key column name must contain name of the table...ie tbCity has tbCityID as it's PK, and all foreign key columns...

david take a look at http://www.mylittleadmin.com/

if that's not what you are after, I can give you a copy of a simple aspx page I slapped together a long time...

I think your trigger model needs to look more like this.

because triggers handle multiple rows in SQL server, you should never declare a variable in a trigger, because it makes...

sure!

take a look at...

it's because you have have to specify the database name in front of information_schemas, otherwise it's the current context.

i personally avoid the information_schemas, and go for the SQL views instead;

this...

to get it to 10% of it's original size, that means deleting 90% of the data? i don't think that's what you are really asking.

besides the points above, (and compresison...

we'd have to see the actual table structure and sample data (CREATE TABLE ...INSERT INTO)

but you could do something as easy as joining with an "exotic" join...that is not with...

well, for the SQL log, exactly where the logs go is configurable...when you first install the server, one of the options is to decide on the folders.

it defaults to a...

well...

its certainly possible, you'd probably want to create a linked server to the other server, and then create the view with a full four part naming convention.

CREATE VIEW

AS

SELECT ColumnList

FROM MyLinkedServer.DatabaseName.dbo.TableName

Where...

ODBC (Open Database Connectivity)

http://en.wikipedia.org/wiki/ODBC

wouldn't that be a simple select?

SELECT...

it also gets a lot more difficult if you have any constraints on any of those 50 columns...unique constraints, indexes, defaults, etc could prevent the ALTER command from completing.... all...

great job on providing sample ddl and data!

does this do what you are after?

With CurrencySplit(currencypair,rate_value ,ccy1,ccy2)

AS

(

SELECT

currencypair,

rate_value,

LEFT(currencypair,3),

RIGHT (currencypair,3)

...

as i remember it, MSDAORA is 32 bit, no longer supported, adn only works correctly on oracle 9 and below;

10,11 and above changed the way they handle BLOB/CLOBS, and you...