I need to use a vendor's sdk to make a call to update the database.  I want
to create a VS 2005 project and add a trigger to do the update.  When I
right click on References, the list is limited (normally I would see the
vendors sdk as a a choice).  When writing sqlclr code, is ...

Hi guys ,  can any one help me?, thanks in advanced for your help.
I use the following to do some operations and to create the body of an email
message, but I'm getting this error:
Server: Msg 8115, Level 16, State 2, Line 446

As I understand it, to call a user-defined method in tsql, let's say
PublicStaticMethod, I do something like:
public class PublicClass { public static string PublicStaticMethod() {
return "got here"; }}

I have a column named "ID" and its type is "uniqueidentifier" in SQL Server
2005 Express.
this column is the primary key and its default value is "newid()" in SQL
Server.

I'm running SQL Server 2000, I'm working on server A but want to run a SP on
server B which it's not linked to server A from a Stored Procedure I will
create on server A,  is there a way to do this?
I've credentials and access rights on both servers but for some weird

Here's a question I can't seem to find an answer to (maybe I haven't looked
hard enough?)  Anyway, can a SQLCLR UDA return a table-style result?  I have
in mind the statistical Mode, which can return multiple results; i.e., the
Mode for the set of numbers { 1, 2, 3, 3, 4 } would ...

Hi guys, another stupid question :(
I´m running SQL Server 2000, Ok, I'm trying to insert from a select
statement in to a table, both fiels are varchar the source and the
destination, the problem is tha my data gets truncated when ever  the text

Fix your system clock, Leon!

i'm running Sql Server 2000, i think this is a stupid question but please
have patience i'm a new to this stuff   :(
I've the folloing query that returns 2 fields (below), how can I assign the
2 values returned by the query to 2 variables for example @GrossAmount and

I have created an SP and defined an End Point to expose my SP as a Web
Method named "EmployeeList".
I can successfully use it in VB.NET but cannot understand what the
"Credentials" means in my code!

I've created the following function:
[SqlFunction( DataAccess = DataAccessKind.None, IsDeterministic = true,
IsPrecise = true, SystemDataAccess = SystemDataAccessKind.None )]
public static SqlString FormatCurrency( SqlMoney dAmount, string

Hi
I wrote a code in Vb.net to insert data to SQL 2005. This transation is
through MS DTC to connect the SQL 2005. In the Server Profiler, I can see the
user is login and the store procedure is execute. However the data isn't

Hi, sorry if this seems stupid, but I'm getting the error below, I'm using
SQL Server 2000.
Msg 141, Level 15, State 1, Line 6
A SELECT statement that assigns a value to a variable must not be combined

I've compiled the "classic" POINT datatype in Visual Studio and am running
it through a debugging session.
I'm looking at Isaac Kunen's blog about IS NULL vs. IsNull and
deserialization.

I made a point type by C# for deploying in SQL2005.
It builds successfully every time.
When I deploy, it gives the following error:
"Error: Type "SqlServerProject1.TypePoint" is marked for native