Grant Fritchey (1/14/2009)

---

Hey Gail,

I see you suggested turning the safeties off to my bestest friend. Holy cow! Triggers calling unsafe CLR code. That ought to be entertaining. Some consultant somewhere...

Seems to be the week for folks like that. I don't think you were bad...

It sounds like you should look into Service Broker for what you want. Making something happen outside the database from a trigger is usually a baaaad idea. Now...

I believe you will need to use the default trace to query that data. Something like this:

Select

T.path,

TE.*,

F.*

From

sys.traces T Cross Apply

::fn_trace_gettable(T.path, T.max_files) as F Left Join

sys.trace_events TE On

F.EventClass = TE.trace_event_id

Where

F.loginname...

Irish Flyer (1/14/2009)

---

You almost certainly have a security issue. To link servers in SQL Server 2005, you must use a SQL Server ID, not a Windows Authenticated ID. ...

forneed (1/14/2009)

---

Of course there is one .sdf file for SQLCE database. I mean that there is a SqlCEEngine class in System.Data.SqlServerCe.dll library. And SqlCeEngine.Shrink function can be used for shrink...

bsrlong,

The point I was trying to make with my post replying to yours is that a forum is only as good as it contributors, and when you post a criticism...

Steve,

Sorry I was not clear, especially with my typos.

What I was wondering is what the link to the pdf is in the report?

GSquared (1/13/2009)

---

Michael Earl (1/13/2009)

---

I particularly like his comment:

[font="Comic Sans MS"]Multi datasets is one of the powerful tools in Reporting Services. The answer is in knowing the product, not...

Check out the post by bsrlong in this thread.

I replied and attempted to politely tweak him.

bsrlong (1/13/2009)

---

This is why I do not spend much time on fourms. Gee, and I signed up for this. People with answers such as this,

do not us...

Do you mean SQL Express? To my knowledge Compact edition only has a a single file .sdf.

What service pack level is SQL Server 2005 on? It may be you need to apply a service pack to upgrade the tools.

What version of SQL Server are you using? You really need to post in an appropriate forum.

For SQL Server 2008 permissions vary by DBCC command, some require sysadmin, some...

I apologize,...