IN SQL Server 2005, typically, objects are not owned by users anymore they are owned by schemas, although a user CAN still own an object, you have to do some...

Vic,

Thanks for answering my questions. Unfortunately there is no way that I am aware of to tell Profiler or SQLTrace to run DBCC INPUTBUFFER or any other query based...

Can you clarify what version of SQL Server you are using? You have posted in a SQL Server 2000 forum, but have used the sys.schemas system view which does...

What are the details you want to get about the SPID? Do you want to filter by SPID or do you want details for each SPID?

What events are you...

Are you using the @body_format parameter and setting it to 'HTML' like this:

EXEC msdb.dbo.sp_send_dbmail @recipients = 'your_name@your_company.com', @subject = 'test',

@body_format = 'HTML', @body = '<b>Test</b> This works'

edit:...

This will work without a CASE and will change any year to 2009 if the MAX(expiry_date) is not 2003 or 2006.

USE tempdb;

GO

DECLARE @test-2 TABLE(induction_no CHAR(5), access_code INT, expiry_date SMALLDATETIME)

INSERT INTO...

I have, but then again I've been here since day 1 and I've been amazed when I go off-line for a couple...

I guess I would wonder why it can't be both? I was one of the people who knew little when I first joined SSC, and while I don't think...

GSquared (3/5/2009)

---

Something like that has some workability, Jack. But for a ratings system to work, I'd like to know who posted the rating.

For example, there have been plenty of...

GSquared (3/5/2009)

---

That's exactly why I don't like the "ratings systems" used by certain sites. The people you help mostly just read it, try it, like it, and never come...

That's how I'd do it with Express edition. Someone else may have a better solution.

Ahhh, Express edition does not support Database Mail, http://msdn.microsoft.com/en-us/library/ms165636(SQL.90).aspx.

In this case you would need an outside process to generate the email. I would probably create an email_queue (id, Call_Num,...

The code you posted is missing a space between sp_configure and @configvalue.

You can see if database mail is enabled by running this:

sys.sp_configure @configname = 'Database Mail XPs'

This will return something like this:

name ...

Basically to use SourceSafe with your DB you need to script out any DB objects you want to put in SourceSafe, add them to a SourceSafe project, and then discipline...