use the DMV's to determine the slowest query currently in the cache. examine the queries to see if they can benefit to from being rewritten to be more SARG-able, or...

mail functions are based on the service broker functionality, which is not included in the express versions of 2005/2008; you'll want to buy a developer version for under $50 dollars...

could it be a relaying/mail forwarding problem? are you supplying a username and password for the AUTH command for your mail server?

is the first destination email going to an...

i believe you want to change the default database for that login to master or some other database, now that the original default database for that login is removed.

the name field doesn't have the name like you think: it usually has a ton of underscores plus a unique numbr

try this instead:

select name, object_name(object_id) As ObjName,*

from tempdb.sys.objects

where...

this is just a guess, but AES encryption would match that format, since it can be stored in a varchar instead of varbinary field...but how does that help at all?...

ok... DML triggers for INSERT/UPDATE DELETE have to be on each individual table, i believe; DDL events can be captured on a per-database or per server. so I believe the...

Lowell (4/15/2011)

---

it depends on what you mean by viewable;

see this forum post on examples of how to

RE: How to retrieve Image file from a SQL Table

Sean Lange provided a...

it depends on what you mean by viewable;

see this forum post on examples of how to

RE: How to retrieve Image file from a SQL Table

Sean Lange provided a fine...

i have a DML trace running all the time, which is recreated by a startup proc whenever the server restarts.

i then also create a view which points to the trace,...

<-- i saw what you did there lol

via TSQL, no; you end up having to create and call something external

Whether an application which connects via POP3 and downloads messages and their attachments, it's going to happen external...

I'd have to assume that just like Windows, if the font that was selected does not exist, it defaults to some other font; I'd expect taht that might be the...

if an application explicitly codes the "Workstation Id = " section to a connection string, then you can blank or or spoof the values you might expect:

here's a connection...

you can use the EXECUTE AT feature of a linked server to create a table, then use an insert with 4 part nameingo convention to put local data in the...