Here is one way:

http://www.sqlservercentral.com/columnists/spustovit/easyauditingasharedaccount.asp

You should also check out Steve's series:

http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart1.asp

http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart2.asp

http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart3.asp

http://www.sqlservercentral.com/columnists/sjones/auditingyoursqlserverpart4selectiveauditing.asp

Andy

Woops I really missed that one, sorry about the Excel bashing.

Here are some discussions that may help.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=205450

Andy

There is something definately wrong with fn_get_sql as documented in BOL. It looks like the sql_handle is only available to the @@SPID connection, RE:

SELECT spid, sql_handle FROM sysprocesses WHERE spid...

I would change the 2. Import to excel and clean-up to:

2. Import to temp table and clean-up

Why you might say, Excel is really easy to use and has great interactive features.

When you...

Here is some short hand for what you have provided, PK = Primary Key Constraint and FK = Foriegn Key constraint:

-- PK groupId

Groups

 -- PK userId,BranchId

 -- FK to Groups groupId possible

 User...

SQL Server 2000 replaces code pages and sort orders with collations. The Client uses the Windows Regional setings, which can be translated using the ODBC or OLE DB connection settings.

Search...

Try changing your select line to:

SELECT @vSubject = @vSubject + ' ' + CAST(ISNULL(A.EntryTime,'') AS VARCHAR(20)) +  ' ' + ISNULL(A.Source,'') +  ' ' + ISNULL(A.LogEntry,'') + ISNULL(B.LogEntry,'') + CHAR(13)

Please...

If the Job is using a stored procedure, you could use the RETURN (0) for success and RETURN (1) for failure in the stored procedure.

Don't forget the (), T-SQL is...

Open the master..sp_executesql stored procedure in EM, and look at the code to see why. EXEC is the same.

Use QA and try and run your select with a variable where...

Robert,

You can insert with a view, if it is for a single table and you grant Insert permission, or if it is a multi-table view you can use instead of...

Chandrasekhar,

I beg to differ, the trouble with mailto "features" is that they are dependant on the default email program you have defined on your workstation. I use Outlook 2003 and...

You cannot use a variable for the where clause, you must concatenate the variable with the dynamic T-SQL. Example:

set @sql = N'insert into #temp

  select distinct gdb.GD_Banner_ID,...

You can create a scalar user-defined function that you can call without the two part naming, see:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1522

The trick here is the location (master DB) and owner (system_function_schema). The main...