Is there any way to make "open table" display 1's and 0's for bit
fields instead of true and false?
Thanks !

I would like an incrementing column in result set of a select query.
Numbers begin with 1 and increment by 1 for each row in result set.  Does
same as counter column in table.  How do you do this?
Thanks,

I can eliminate the message below with "Set ANSI_WARNINGS OFF", but I'd like
to know why it happens....
Warning: Null value is eliminated by an aggregate or other SET operation.
ALTER VIEW [dbo].[V_CURRENT_PART_BALANCE]

In SQL Server 2005, we have a situation where a proc is making a query
that refers to a synonym, which points to a linked server.  The target
server is SQL 2000.  Both servers are 8-way processors.
The query looks like this:

hey all,
given: i'm working in blocks of 26-week periods
parameter:
Year: 2008

I have two tables
( tblService )
PK ServiceID
     ServiceName

I have a table function which walks through a comma-delimited list and
returns a varchar column of the items in the list.
Select ListItem FROM dbo.fListFromString('a,b')
which returns the parsed-out items in the list:

I need to submit data from a table (in the DB) which acts like a temp table
(rows get added and removed after submission) to a permanent table on my
server DB (sql server 2000) via a stored procedure.   This is a daily routine
that will occur multiple times per day.   The problem ...

Just thought I'd drop a post onto the group, wishing everyone season's
greetings, and a wonderful new year to come.
Thank you for all the help you've all provided in the past year,
Yours,

The database is from SqlServer Express 2005.  I've created an instance
of SQLServer Express 2008 on another machine.  I did a shrink on the
db before copying it.
I get a message like

What is the best way in order to send an SQL query via e-mail?
What can I do in sql server side? or programatically? (VB or C#)
Thanks in advanced.
dj

How can I know when was the last time a stored procedure was updated?
Is it possible to find all the update dates of a stored procedure?
We use sql server 2000.
Thanks.

I have declare:
@xVar XML
In @xVar is  xml :
<tag>

SQL Server 2005 sp2 build 3228(CU6)
I experienced yesterday for the first time a problem that reccured today;
our web servers and application servers received oledb errors while
connecting to sql server.

We are using a particular SP named USP_USER_InsertUser which inserts
values into a table named "Users" in our project in c#.  For the table
"Users", there is an INSERT/UPDATE Trigger which will verify if the
table already contains a value which will cause a duplication and if