I build a dynamic command that combines two queries, an INSERT and an
UPDATE. The procedure is hanging after the first time the INSERT runs,
and I can't figure out why.
Trying:

Folks,
I have DTS jobs that I moved to a SQL 2005 server which run fine when I
execute them manually as 'legacy' jobs. However, when I try to schedule them
(run them via SSIS), they generate this error:

I am doing a column chart in SSRS 2008.  Is there a function or a way to
mouse over the bar and see the data value of the column.  I see there is a
way to show the value in the bar but I want to be able to mouse over it
(value appears then disappears) like in excel.  Is this ...

Greets,
A company I work for has granted ODBC access to some of their clients (a
risky proposition, I totally agree.)  I have been tasked with analyzing the
load these clients incur, and in the course of that, I noticed some calls to

This is a design question.  Here's hoping Joe Celko haunts this newsgroup ;)
The relevant DDL will be at the bottom of the post.
We have two entities -- sporting events and "product" which could be a cup,
shirt or a fee.  Obviously, events have a number of attributes not needed

Given that this query is easy to understand:
  Select case 'Rep'
       when null
           then 'SBr'

Our application records transactional events (maybe 300K to 500K rows per
day) on a separate file group called HISTORY.  I was wondering if there are
performance considerations when creating indices on this history table.
That is, do I get a performance improvement if the index ...

I'm invoking "SqlConnection.BeginTransaction()" just before I do a series of
inserts into multiple tables. I just ran a test and discovered that until
the transaction is committed, it apparently blocks other users coming
through the same code. Each user will be inserting ...

We have to establish a connection SQL Server on 16-bit MS DOS 6.22 o.s
Tested Methods: ISQL.exe, Osql.exe;
Conclusion: Both exes can not be run on the 16-bit DOS operating system.
SQL Server versions used: MS SQL 2008, MS SQL 2005, MS SQL 2000

I received this from a person in a news group. I have replied to the news
group to get some information about what this actually means but haven't
received any kind of respons so I hope I might get some from this group
because it's about Sql server.

Let's assume there is a Sql Server database with contains a stored
procedure. Sql Server Agent has a job, which runs this stored procedure. The
shedule for this job is defined as:
Shedule: recurring, occurs daily, once at SomeHour;

I have a query setup as a trigger below in sql 7:
declare arow cursor for select sonitem, spart, soq, sdisc, sunitprice,
sprice  from salesitems  where  sona = @xson and soq>0    
        open arow

When i m using Refresh Local Cache in Local Server its Working
properly. But when i Connect to Remote Server then its not Working Can
you tell me is their is any Solution or Issue with this,
Or I have to Use RED GATE TOOLS for Refreshing Cache

Can you pass expressions to a proc?

I need to construct a query base on the requirements below and get stuck.  
Any help would greatly appreciated.
IF OBJECT_ID('Tempdb.dbo.#Temp', 'u') IS NOT NULL
 DROP TABLE #Temp