wow that's sounds extra wierd. can you give an example?

if you query these two views, there's no data?

select * from sys.dm_exec_connections

select * from sys.dm_exec_requests

or is it specific views?

pretty wide wave of the hands.. "how to i check my server's health"

You'll probably want to define what you want to check, first, as Jeff said. We can help with...

are you running as sysadmin?

some of those views may be filtered for security reasons to just what YOU've done, unless your a sysadmin.

steveb's right on.

pretty sure your issue is the mails erver doesn't like the way you are connecting.

In order to prevent spam, most mail servers are set up to only allow...

if you are installing anything EXCEPt Express editions, then yes, SSMS is included in the install.

if you grab an EXPRESS edition, you'll want to make sure it's a version "with...

trying ot think outside of the box, i think you could create a job that runs sp_who2 and logs the data to a table...that would have less data, of course,...

for tracking DATABASE access, a logon triggers not really going to help you; I'd really suggest using a DML trace instead.

For that logon trigger,

for example, pick the top...

here's two different ways i can think of;

you have to lookm at the column size of the data for anything that could potentially be greater than ~8000 chars.

by looking at...

if @vSurveyMessage has the literal value of thiis:

@vSurveyMessage = 'Recently we invited you to participate in a survey to help ' + [@vfirstname]'

then you'll need to do a REPLACE...

the object_name() function has a second parameter to pass the database id; i think it got added ina Sp of 2005, and 2008 and above:

select

db_name(database_id) As DBName,

...

Nemachtiani (6/22/2011)

---

Hi all

Does anyone know what would cause data loss on tables after commit with no errors raised neither executed DELETEs?

Is this a symptom of database corruption?

I have...

i think if the procedure is doing dynamic SQL, the owner chaining rears it's head as well right? and the user needs access to the underlying objects being manipulated via...

i think because you are concatenating @ViewDefinition with @SQLCmd, they should both be NVARCHAR(max) definitions:

DECLARE

@FieldName VARCHAR(50)

...

there's only two ways i can think of:

1. use synonyms, and dynamically change the synonym defintion.

the problem with that is the synonym must point to an OBJECt, like a table...it...

- Win. (7/25/2011)

---

Hello Lowell..

Thanks for your help on auditing and for your query..

I tested that in my DEV environment, but its giving only MASTER database info alone.

I tried creating...