yeah configuring the server like that is something you like once a year at the most, and only when you needed a functionality you didn't need at startup;

glad i could...

instead of having a rollback command as the body of the trigger, you can send an email instead....so you can get notification that it ALREADY happened and not rollback the...

in small letters, right next to the words "Configure Surface Area for localhost" there is a link that says "change computer"

click it and put in the name and connection info...

the error is self describing...go to Start>>Programs>>Microsoft SQL server and find the Surface Area Configuration....scroll down to database mail and enable it.

you want to prevent one specific table or all tables from being dropped?

i assume you mean some people have the rights/roles to drop the tables, you are not going to...

the secret is to use cid:attachedimage.gif for the source file.

here's a setup and working example:

I'm attaching the results of a query, and i copied the SQl server logo to my...

Note that this has syntax issues with what stewart posted if you are not using SQL 2008; 2005 hates you for a few things (no += operator, can't...

can any Organization have more than one CompanyNumber a CharityNumber?

if the answer is no/never , i'd put those columns in the Organization table; if the answer is maybe/not sure, i'd...

boy these read just like homework questions.

what do you think the answers are?

you can create a...

well it really depends on your application.

if your application is a client-server kind of app, then changing the connection string would be once-at-startup, and then an on-demand situation, where...

omg that extended proc with no...

Andrew i have this saved in my snippets; it's creating a linked server to Active directory, and querying for some stuff;

when i tried it on my own network, i didn't...

this is outside my area of experience, but my Google-Fu skills are strong! I searched "ssas star or snowflake" and found some stuff.

i found this article about why snowflake is...

i believe the DDL statement DROP index would be captured in the default trace;

you can use the GUI filtered version and find out whodunnit if not too much time has...

just because a table has no rows does not mean that table has not been referenced by a view/stored proc / function or external application; it is perfectly normal to...