are you confusing DBCC TRACEON with a system trace? (select * from sys.traces)

every DBCC TRACEON command does a different thing...some turn on something to be visible in performance counters, others...

this clearly identifies the issue, and it's outside of SQL server:

The server response was: 5.7.1 Unable to relay for aangie@ibmcore.org). )

that is one of the standard SMTP error messages.

that means...

wouldn't this just be a min( date), and count(*) grouped by customerid ,year(min(date))?? so you can calculate counts per year or some other period?

nite re-download the project one more time;

i tested it found some bugs and missing code, this versions much better.

something like this is what you want;

the permissions is VIEW ANY DEFINITION, which is what you were asking for: let them see the text of any view/proc/function.

CREATE ROLE [ReallyReadOnly]

--give reader...

the recommended way is to take your script, which you already know works, and use SQL Agent to create a job from within SSMS, which runs on a regular basis.

while...

as Chirag alluded to, you can use the procedure sp_procoption to run a procedure when SQL server starts, but SQL Agent might not be running.

here's an article wher ethey discuss...

maybe i'm mis reading the request, but it seems to be "show SSMS reports in our application instead of SSRS web pages". I had thought it was different.

I'm assuming the...

Renis yes it is certainly possible;

check out this example; it is getting the names of all the tables and putting it into five columns.

in your case, you just need to...

smitty your syntax was close; i tested this with my profile, and it works fine:

ALTER TRIGGER [ddl_trig_database]

ON ALL SERVER

FOR CREATE_DATABASE

AS

declare @results varchar(max)

SELECT EVENTDATA().value('(/EVENT_INSTANCE/TSQLCommand/CommandText)[1]','nvarchar(max)')

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Default Notifications',

@recipients = 'lowell@mydomain.com',

@body =...

there's not a simple script that does it; everything depends on the specifics of the data in question...foreign keys, primary key definitions, and more. you'll need to analyze the data...

well, the existing load on the production server would certainly affect the speed, as it has to share/complete for resources with regular users;

the devleopment server probably has a near-no load...

the trick is to join the table against itself, so you can exclude one group:

something like this:

SELECT *

FROM SOMETABLE t1

WHERE t1.contact_type = 'Requestor'

AND t1.user_id NOT IN

(SELECT user_id ...

the are .NET references, and have nothing to do with having SQL installed or not.

you should be able to go to the project references and add them.

==edit whoops my bad...you...

well there's a couple of ways to do it, but they are just different flavors of the same idea....the command must be run on each server.

One way is to...