YouTubeGeyser Will Let You:
Drive people to your video niche to any of your existing websites!
Just choose the plan you need and you have a couple of Traffic
Don't miss your chance...

Free4sms is a free service.
Send SMS for Free worldwide to any mobile phone gsm, iphone, smart phone.
use it with moderation.
http://free4sms.info/

Hi. Thank you for your expertise.
I am trying to find out how ot pass data in SQL Server 2008 table type into C# CLR stored procedure from SQL stored procedure.
I've found lots of references how to pass it out of CLR procedure to SQL procedure but none the other way.
My plan is: ...

Using SQL Server 2005 and .NET 3.5.
I have a SQL stored procedure [collection and validation of parameters]
which references some CLR table valued functions [some complex mathematics].
The table valued functions, in turn, call a SQL stored procedure doing

We have the OurStoredProcedures.dll with stored procedures in C#. We
programatically deploy these stored procedures to the local SQL Server, using
SQL command with the "CREATE PROCEDURE ..."statement. Also we are creating an
assembly on the server.

Where can I find a tutorial/samples of "multiple-input user defined
aggregates"?

I have dysfunction in SQL Server 2008 Express
I'm sorry to bother you, but I have no one else to ask.
I installed on my computer C# 2008 Express and SQL Server 2008 Express.
And I cannot change values in database tables.

  I must to connect in sql server using authentication windows, but the
database is in other network with other domain, when I connect using
authentication sql , work fine,  but I must to use authentication windows
thank youn in advance

I have a weird occurrence. We are using SQL2005 & Access 2000 (also happens
with Access 2007). We connect the Access DB to SQL with an ODBC with a logon
that should have read only connection to SQL.
Everything works as expected except one field.

Hopefully I am posting in the right newsgroup...
I am trying to troubleshoot an issue with a user who needs to access a SQL 2000 database from Ubuntu.  He is passing the following command which is generating the error below (I've blocked out the IP Address):
tsql -H XXX.XXX.XXX.XXX ...

First, a confession.  I posted this question earlier today in
microsoft.public.vsnet.general (which I now think was the wrong Discussion
Group).
Now, if you're willing to read further... I'm setting up a new VB.Net and

In SQL 2005 is it possible on the server to limit the number of
connections per database?

I am trying to perform the following calculation
100^(-.01*25)
Here is the code I have right now
declare @decay_rate decimal;

I want to migrate data from a source database to a destination database...
There's only one table to transfer.
One of the column in the source table contains 5 prices separated by a
space....

I'm trying to export a table contents with date limitation using bcp
command. The date is going to be variable. My command is like this, I'm sure
I'm missing something, it gives me saying "syntax error converting datetime
from char string..."

I have a need to have an ID --which is a sequential number-- that starts
over at 0 each day; however, I obviously also need to have a unique way
of identifying each individual record.  You can think of it as being
similar to the registers at some fast food restaurants where each ...

I am unable to drop a rule.  Does anyone know the magic trick to dropping a
rule?

I am using the following statement to select top 10 visited product. But i
want to show the total hit number for other all products which are not in
first 10.
SELECT TOP 10 COUNT(*)AS TOTAL_HIT , STOCK_CODE  FROM B2B_WEB_LOG

Hi, i have to "bulk" insert in my table some binary values (files) reading
from xml text..
i use this way:
create table test(MyKey varchar(32), FileData varbinary(MAX));

I have a XML as below. As you may see, the ErrorMessage node has several
"Error" nodes with attributes and data. Now, I want to get those attribute
names as "columns" and the values in "rows".. (Action, Key, MultiRefId,
Batch... are the columns).

I need to get the name of the parent node and used "../@mp:localname" in the
openxml statement. I got an error when trying to execute the query:
XML parsing error: Reference to undeclared namespace prefix: 'mp'
However, the query execute just fine if I use @mp:localname. It seems ...

I would like to insert an XML fragment into multiple records as efficiently
as possible. This SubQuery at the end returns a list of UserId's I would
like to run the DML insert statement against.
This is what I have so far. I don't get an error but nothing happens.

Hi,
Is there a way to join nodes using for loop. for example i have
<name>
<alt>test1</alt>

In SQL Server 2005 SP2, when I use a query like this:
SELECT f1, f2, f3
from myTable
for xml auto, elements