I agree also. Common code reuse is one of the few things that I support using SQLCLR for.

Yes, raid 5 is counter-indicated. Best practice is raid 10.

Its not as hopeless as it might sound Jack. For (3) you can restore from backups, for (2) you can reinstall SQL Server and for (1) you can nag...

Glad I could help!

Here is a start:

Create View vwUserInterestEvents as

Select US.UserID

, US.UserName

, IT.InterestID

, IT.InterestName

, 'EVENT' as [Type]

, EV.EventID

, EV.EventName

, EV.EventDescription

-- ... etc...

From Events EV

Join EventsInterest EI On EV.EventID = EI.EventID

...

kotlas7 (9/30/2008)

---

Its a weekly job runs on saturday midnight 1:00am. So nobody is accessing that database at that time and how can I know who are accessed at that time(any...

Well then, let's ask the question: what are the features of your serial number generator that...

chris (9/25/2008)

---

Is there a way of doing that from withing managed code (CLR) using VB.NET. I have built a function to do all the calculations and am now looking at...

In fact, ask him for a copy of the test...

"TRUSTWORTHY" is a Security issue, it means that TRUSTWORTHY databases should be trusted by other databases and not to worry about the possibility that some user could hack that DB,...

To the best of my knowledge an "c0000005 EXCEPTION_ACCESS_VIOLATION" is only caused by (1)a SQL Server bug, a binary corruption in the SQLServer executables or a corruption of one of...

Yes, thats it.

This forum's security filters will usually eat any XML imbeded in a post, so just attach it to a reply as an XML file.

Someone was attached to your database. You will either need to wait for them to get off, or kick them off.

I looked at the example that you have posted there. It occurs to me that if @Group_ID is unique in the table that your function returns, then you can...