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

the script you pasted, assuming a missing closing-parenthesis, makes [IsRegistered] the table's primary key; was that the desired results? was there something missing like a comma and the rest of...

not directly from MS, no table level backups.

I believe some of the RedGate stuff does it, and i know you can script out the table and the data right from...

excellent point, David. sometimes you need...

Danny i think this is just a basic syntax issue;

if you are building a string that ahs a single quote in it, two single quotes in a row signify the...

replication does not require a constant connection; merge replication, for example, would stack up untill it got PULLED; log shipping would be up to the other end to grab...

--edited and removed when i found out it was homework.

For homework, me pasting a solution helps noone; you never learn...

even with the maximum compression settings a backup file that compresses to 200meg might go to 189meg with higher compression; there is no miracle compression that will shrink a gig...

what would the function do with the values if it got them? you might be looking at a problem head on, when a sideways look might present a better solution.

what...