We have a problem with our SQL2000 to SQL2005 migration where we use
xp_readmail to check mailboxes for new messages containing incoming
data.  This is no longer supported in 2005.  Are there any other
methods for checking mail in 2005?

  Getting the last day of the month, for the given date, by TSQL is bit
tricky. Following user defined function provides you a handy general purpose
function to get the last day of the month.
It gets the last day of the month as follows:

I have created a clr stored procedure, everything is fine.
I can see the stored procedure among the other stored procedures in the
database.
I can execute it in management studio and the results are fine.

Do we have any special way to implement clr in a cluster environment to make
sure there won't be any impact after a failover. please suggest how to move
ahead with clr implemention on a cluster.

I have to use SqlBulkCopy because input sometimes exceeds 100K rows.
However, it fails over duplicate rows - if key is unique on target table.
But my input might contain dups as I can't control the source.
Initially I was filtering dups out using INSERT statement. However for such

I am new on CLR's
I tried to send binary parameter to my dll from sql server 2005 and it
always brings me an error
how can i solve it?

Is there a relatively painless way to manipulate graphic images from within
SQLCLR?

Is it possible to perform actions such as updates or even a SELECT on a
different SQL server via a CLR procedure using ADO.  if I create an assembly
with the following code on MYSERVER2 and create and execute a proc the
security context seems to be missing as the error "Login ...

All,
Please forgive me if my question doesn't initally provide enough detail as
I'm from a production DBA background and am just venturing into the realms of
CLR.

I have created a CLR stored procedure which accesses external files
like CSV or XLS using OleDB. Everything works great except when I put
all of my T-SQL inside BEGIN TRAN ... COMMIT TRAN: Opening the OleDB
connection promotes the transaction to MSDTC! However, I only need a

I have SQL Server EXPRESS 2005 and I have written a C# stored procedure.
The stored procedure tries to read a file on the local computer but the read
causes the following exception to be thrown:
Request for the permission of type