Then you must create them. To start writing (i.e. hacking) code and designing databases...

??

A requirements document and a functional specification would be my first step.

It appears the other assembly reference the other assembly version 2.0 We don't don;t know if it is specifically needing that version (probably referring to .NET 2.0) or it...

read this: http://support.microsoft.com/kb/302340

did you sign the assembly? Does the assembly really need to be unsafe? You will probably have to set the database as trustworthy if so.

What I do is script out the logins and agent jobs (which can also change BTW) daily and they get shipped to the standby servers along with the backups and...

I don't see where that is an issue in and of itself. One of the reasons connection pooling was invented was to fix the resource intensive philosophy of making and...

Can you post your CLR code? from the error messages it sort of looks like it is trying to connect to a database server. That would not work unless the...

Set is lower overhead and faster for simple variable assignments and computations. The select statement is of course capable of an extensive array of set based operations.

For all the...

You can configure the linked server to use several different security methodologies depending upon what you need.

what errors are you getting?

what is in the dbo.[A] table? does it have any rows in it?

Try eliminating the "from dbo.[A]...." and see what happens. but I am thinking what you need is...

Full text indexes may be a better approach than trying to do leading wild card searches on a very large table.

It can't be done.

Two that I use alot around here:

convert a string based IP address into a 64 bit integer.

encryption & decryption & key management functions.