ok the error you can get is:

i poked around using my Google-Fu, and that seems to be the limit;...

i remember a post from Jeff Moden mentioning that a view could only have ~200 references; it was less than 255 but more than 200; so if you have 400...

EXCEPT requires the same number of columns from both tables.

remember it's comparing row to row based ont he columns you select, so you need to either remove Column 2 from...

yet another day where i learned something I didn't know.

Thansk for this post, Brian. Good to know!

yeah it's so easy once you've discovered ti you want to kick yourself... I found out the hard waywhen i bought a new laptop and installed both SQL 2005 and...

the function you pasted is for Oracle, and contains a lot of stuff that is Oracle-only syntax.

it cannot be directly compiled into SQL Server, you'll have to re-write it.

with both .net and SQL server's built in tools, eventually someone can reverse engineer decrypt everything.

SQL server has to be able to compile any encrypt stored procs/functions ; the WITH...

Opus it's been a while since i added an oracle linked server; here is the syntax i've used, i put in your server and username to what i think is...

Ray i had the same thing happen; locked out of a new install.

the fix is to add yourself as an administrator; you should be able to find the SQL 2005...

ok completely different situation than i thought.

Sybase is a database engine, the same way SQL Server is; you'd want to create a linked server in SQL Server to connect to...

I'm surprised noone mentioned the Default Trace yet, that contains all the recent DDL Changes;

there's a built in report from the default trace in SSMS: shows table drops and created,...

Randy i would love to help; these questions are low hanging fruit for me, and helps anyone who reads the thread, but

without the definitions of the tables, anything like an...

you have to use a varbinary(max) to replace an IMAGE datatype;

I just tested it, and by simply changing the datatype with this command, i did not get any errors...

OK Najibullah; i noticed the Salary is datatyped as number(12), so i...

easiest way is to simply right click on the model database and choose properties; the model by default is small; under 2 meg for the file, and 1 meg for...