I'm not sure what you mean by querying. You can apply a where clause and join to the function. Like this:

SELECT

*

FROM

...

Why are you inserting into a temp table?

Oh...

Right you are the DBA and if you are running any version of SQL Server 2005 there is a Default Trace that is installed and started, unless someone manually turned...

What is in start-time, last_event_time, and event_count? I would venture to say that the file is not created until an event is created.

Are you looking in the D: drive...

What do you get when you run this query:

SELECT

*

FROM

sys.traces

WHERE

is_default = 0

The status column should be 1 if it...

I think it is unlikely that the shutdown was caused by SQL Server and then SQL Server restarted without issues. Did you check the SQL Server error logs?

You may want to contact Shelby about this to see if they have any experience with this issue. You can also check this article

You can look into using the ReportViewer control.

In your sample data you are trying to get 'Angola' to be like 'Angola Black Antelopes' which will not work as LIKE requires the Right Side to be a subset...

Greg Charles (4/14/2009)

---

Yes. Something to keep in mind about db_ddladmin is that, while it allows members to create objects, the objects are owned by whomever created them not by DBO....

If you are really on SQL Server 2005 (based on the forum) you could query the Default Trace for the Object:Deleted event limiting the results to tempdb. One thing...

Great article Tim. I don't currently have to work with anything like this, but it is a good overview of using the Script Component in addition to the tutorial...

Barry is clearly not attempting to be condescending in the article. He lists reasons he has seen and experienced for why people use cursors. He also clearly states...

Thanks, but Noel's solution is the same with respect to the joins. Noel just added distinct and accesses the Client as well, but is essentially the same.

You can use...