I need a CLR custom type to address a few requirements we have.
The class is something like this (extremely simplified to the point)
using System;
using System.Data;

Third time for this post.  I cannot get SQL server 2005 Developer Edition to
load reporting services on my computer.  I have tried KB934164, KB938245,
installing IIS 6.0 and the 6.0 config manager, ALL of the proposed options
for IIS config manager, turning any combination or ...

I'm running a CLR assembly that was designed to resize images within SQL
Server.  The assembly is "safe" but uses System.Drawing which is "unsafe".
When provided with the PK of the datarow, the CLR assembly will retrieve the
image from the database, resize it, and update the ...

I’m one of those developer, turned DB developer / forced DBA types, and I am
intrigued with the idea of managed code (CLR) being stored in the database
via assemblies.  Our company creates financial software for distribution to
outside clients.  We have many cases where a lot of ...

We developed a CLR function that do some work with database, as the logic is
already developed in C# so we are not going to re-write the same code using
stored procedure. But due to some business requirement, we are calling this
function in a stored procedure from SQL Server ...

We have some VS 2008 .Net code which is performing database related queries
which has been marked for use as a CLR Stored Procedure and running in SQL
2005 which runs fine for one user.  But we are having problems when calling
the same stored procedure via multiple clients at the ...

What is Happening?
This message is to inform you that Microsoft will soon begin discontinuing
newsgroups and transitioning users to Microsoft forums.
Why?

A database, that attaches to a SQL Server at work (local on a stand alone
PC) refuses to be attached to an SQL Server at home (local on a stan alone
PC).
Both are SQL Server 2008 with Service Pack 1.

Access 2002
SQL Server 2000
I cannot run an action query without an error which includes:
dbSeeChanges added to the OpenRecordSet command.

as I can find the tables have a view? that is, if I have "select * from
vFacturas" how I can find the fields and tables for each field?
thanks

    I am troubleshooting connectivity from client computer to SQL Server 2008
named instance. We have opened 1433 and 1434 ports to allow connectivity. I
am able to connect using <SQLServerName>\<InstanceName>,<PortNumber> syntax.
But I would like to connect without specifying port ...

Everyone loves the idea of a workout without an actual workout. In
that way muscle activity will increase, but that is because you are
doing an actual workout. And now, you can shape up your body just
wearing a pair of MBT shoes to walk or stand.These MBT shoes, no

Can time values be aggregated?  I'm putting together a summary report
that will need to show the sum time that something happened.
(Employee breaks, for instance.)  If break times for 3 employees were
"01:00:00", "00:15:00", and "00:12:30" in length, how do I aggregate

I have update statement which updates column name (auditor_details) in a
churn of 5000 records at a time of auditor table which contain 3.2 millions
records. I have schedule this through sqljob. I'm looking over sql example to
check for update records and gives a output and quit ...

Could somebody show me how to update a trigger. I havent created any
trigger but it exists in one of the databases we bought for shopping
cart. I have to make some modifications to that.

I need to find a way to run a SQL query to find all lat/long points in a
table which are within a polygon which is defined by several lat/long
points.
For example, I have this table which includes ALL ~700,000,000 possible

I'm using SQL Server 2005.  I have
               DECLARE @keyword varchar(4096);
               SET @keyword = LOWER('abc');
               SELECT DISTINCT

    I am working through the tutorials.  I have created user Mary.
The next bit is about how she can not access anything yet.
    Oh, really?
    I want to see what happens if she does.

I thought this should be simple but it does not seem to work. I was
trying to use FOR XML to generate XML data and XSD and
SQLXMLBULKLOADLib to import the data.  In actual implementation the
data will be generated on one SQL server instance and then imported -

Hi SQL Monsters
I am getting the following error when I run my query. The query is supposed
to be pulling the waitresource  data ("FILE: 5:0") from the XML formatted
column name TextData. Do you know what I could be doing wrong? Thanks in

I have never done this before and do not know where to start. Do you know how
to parse out this TextData column into a readable string showing only the
element and value for "waitresource" and "duration" column?
This is the xml that was generated per row from a sql profiler test.

I need to use XQuery to move a node between two XML data type fields...
I know I can delete a node like this:
SET MyXMLField1.modify
    ('delete

This will give me a single line with a list of MyText attributes,
recursively, under the node.
select
FileTreePrivatexml.query('data(//Node[@SomeAttribute="MyKey"]//@MyText)')

Using SQL Server 2008
XML Data Type For A Column
How can I recursively count all the nodes within a node...
I have a node that is simply  //MyNode[@Item="1"]