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

SQL server has the ability to create a backup file of the database; that is ideal for disaster recovery and creating copies for developers to not fiddle with the live...

lot of one line questions from you; without details, google and research may be your best bet;

look at teh execution plan and determine if any indexes would help; make sure...

take a look in books on line for the try-catch statement;

if an error is raised, you can put in some logic to do something different that failed in the TRY

Digs thanks; as always, you post everything someone might need to test the scenario. I really appreciate it.

this was interesting as heck; i got similar results when trying to use...

yeah from a SQL perspective, an update that affects zero rows is not an "error", but from your perspective it's a logical error, as you expected at least one row...

craig 84462 (5/1/2010)

---

I have imported a microsoft database into sql server but now I want to 'export' it out into a folder in windows explorer in order to email it?...

if it's a class exercise, I'm sure if you read the instructions for the exercise, or maybe read the chapter in your study materials for the course, it will cover...