Anyone know of a way to query the name of the service account SQL is
currently running under?
I know it's not a smart thing to be doing, and I know I could do it
programmatically via windows routes, but I have need within a large test

How do I make sure no unclosed connection (wich are left over after an
application fly) are left in the server with no use?

I have a table contains a field that is the type of datetime, and I
am getting some unexpected results when I query for the records.
For example when I do
select tdField from mTable when tdField >= '12/3/2008 14:00:00';

I just found this query in a legacy datase.
When, if ever, does "TOP 100 PERCENT" ever make sense? Why do it?
SELECT TOP 100 PERCENT LastName FROM
(

Is this:SELECT *
FROM   employee
      INNER JOIN department
         ON employee.DepartmentID = department.DepartmentID

[SQL2000]
CREATE TABLE [dbo].[tbl_FGSIZE]
(
[ID] [int] IDENTITY(1,1) NOT NULL,

This is a Stored Procedure I've inherited
I have two lines that I've added in each of the SELECT sections below. They
end in "-- I need this additional data"
What I don't know how to do is add a join to an additional table.

help, I'm trying to access a stored procedure The stored procedure works fine
when run from the server) the code is below -
CREATE PROCEDURE updatepricing
@siteid INT,

How can I sort the following data from Horizontal to Vertical using MS SQL ?
Table : Sample
From Horizontal
Type    Value

The trigger below is supposed to Test a sproc when a tblTestItem record
is deleted. Either the trigger does not fire, or the @TestID variable is
not set to the deleted record's value in TestItemTestID. I am not able
to get the print statement to work inside the trigger so I can't ...

I have a few tables represent hotel, hotel room, guest and room booking
respectively.
Among two tables are as below:
Room table

I have a table contains a datetime field, which stores only time
information, now
1. I have noticed that the time value saved in the table all have a
date stamp at the beginning of them, for example

I'm stuck two tables which were poorly designed from the beginning - a
Message table and an Employee table. The Message table has an
EmployeeID and the message text. The Employee table has the
EmployeeID, the employee name, and an employee code. The problem is

My db has a char(10) with a date stored like yyyy-mm-dd
I need to add a number of days
ad output as char(10) stored as mm/dd/yyyy.
The 2nd part works fine with dateadd(d,ChangeOfDay,DepartureDate),

Has anyone dealt with corruption of the Quorom drive on a SQl 2005
cluster?  Is this common?  If so how can I assure my manager a plan if
this does happen so we dont lose data.  TIA