Although project server databases are stored on the same SQL Server as our
corporate database, we need to add some business logic for interacting one
with the other. Since Project 2007 SDK states "we strongly advise developers
to use the PSI to access Project Server data in the ...

How to tell sql server the maximum size my temptable will grow so that it
does at most 1 memory allocation?

I have a CLR function thet returns IEnumberable (a table) and it has a
FillRow function. I am returning 10,000 integers from this function. Is
there any way that I can preallocate the resulting table or give SQL server
hint as to how many rows my function will return? It makes me ...

I have some clr dll:s which are getting ready for production environment.
These dll:s contains about 100 sp:s and user defined functions, they
will be deployed to about 200 databases on different servers.
Adding the assemblies is not a problem, it is adding the sp:s and

is it possible to mark my CLR function as UNSAFE in code or visual studio
anywhere so that wehn vs deploys, it creates unsafe assembly? (instead of me
having to manualy deploy in tsql!)

I've got a C# assembly which is calling an unmanaged dll written in CO. The
assembly has been loaded in SQL server 2005 without any problem. I've also
created a function, in my database, which is calling a method of the CO#
assembly, which is making a call to a function in the ...

How to debug sql 2005 on remote machine. I am administrator on both my dev
machine and remote sql server machine.
I get this error when i try to connect to remote machien with visual studio:
unable to connect to microsoft vistual studio remote debugging monitor named

Fastest way to move XML document into and back out of CLR function
In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass
an xml data type variable into a C# CLR function and retrieve it back out of
the C# CLR function when the C# CLR function is done modifying ...