James i'm guessing that you'd need to post the code for the procedure sp_sendmailsimmediately

clearly it's using CDO instead of the newer msdb.dbo.sp_send_dbmail, and a required parameter is missing.

take a look at this thread about logon triggers...

you could make a trigger like the example that refuses a connection if they are using the specific SUSER_NAME() of the account...

we have a handful of tables that require what you are asking;

what we did was add an additional column to the table, where the default value is the location/server/identifier for...

jvanderberg (7/15/2010)

---

You could install another database instance (possibly even express edition), and copy the databases using the same names. I can't imagine your website code likes different database names...

here's some code that will change every non-dbo schema-ed table to be in the dbo schema again. you'd need to tweak it to cover procs/views/functions, if that is an issue...

i think you'll have to script out all the functions,views and procedures to a file, then do a find and replace...

P1. -->[P2].

[P1] -->[P2]

then replace each CREATE PROCEDURE/CREATE FUNCTION/CREATE VIEW with...

Auto update stats only gets triggered when 20% of the rows in a table are modified...on small tables, that's fine, but on a big table, say a million rows,...

personally I usually put the results of a proc into a temp table, like this:

CREATE TABLE #WHORESULTS (

[WHORESULTSID] ...

i have yet to find a situation where a trigger featuring a cursor cannot be replaced with a set based operation. Usually a trigger might have a cursor because the...

you cannot get it to prompt for a value. it's not designed that way...it is designed to run unattended.

what you can do is make the job check a value in...

well, because Express does not HAVE analysis services or SSIS, getting an error message about being unable to analyze them for upgrade is a non issue.

I don't see anything preventing...

the devil is in the details...

what is the real name of the proc?

for example, you know that anything that starts with "sp_" is assumed to be in the master database...maybe...

sp_depends is 100% accurate for tables functions and views. you cannot create any of those things with a dependency to another object unless the object exists.

because of the way...

also i'm under the impression that verswion is more tied to the SQL the db is restored on...i took my SandBox from 2005, restored it on my sql 2008, and...

also consider this: change the presentation so it is not user centric...make it functionality centric.

a tree view with branches and sub branches of your modules and sub modules would probably...