I have a view as follows (please don't yell at me for using "ORDER" in the
view as this is not the issue at the moment and I need to get this working
without updating a whole lot of workstations):
SELECT DISTINCT TOP 100 PERCENT City, CountyName

I want to run a report of all the opportunities belonging to an
account and all of it's child accounts in the hierarchy (i.e. parent
account has x sub-accounts; each sub-account has y sub-sub-accounts
etc).  The first step is to compile a list of all these accounts in

I notice something in the AdventureWorks database that I don't use,
and haven't used before. That is, they have the normal promary key,
for example, ProductID, and then they also have a rowguid column.
Certain tables have the rowguid column, some don't. I think it might

When I issue the following T-SQL 2008:
ALTER TABLE ALIS.mc.LOCApp DROP CONSTRAINT LOCApp_Created_df
I get the following errors:
Msg 1781, Level 16, State 1, Line 1

IF a 2008 table field "Updated" is defined as DATE and the following T-SQL
is executed:
SET Updated = GETDATE()
are there any situations where Updated would be anything other than the

I need to code an UDF that will return the next or preceding employee_id
from a table containing the list of all employees, using some "search
parameters"
Parameters :

Not sure if anyone noticed this yet or not but SQL Server 2005 SP3 is out
for download!

how do I write a script to drop an index only if it exists?
Thank You
Joachim

My "inherited" application uses ADODB.Connection to process transactions
against a backend SQL Server. Within a BeginTrans / CommitTrans, error
-2147217871, "Timeout expired", occurs on one of the Execute methods. The
sample code (simplified) looks some like the following. Please ...

How can I return a list of tables and their column names in one T-SQL
statement from a single database (SQL 2005)?  Thanks.
David

In Vista, applications are supposedly no longer allowed to write anything in
Program Files. Yet the newest version of SQL Server by default keeps
databases in there. Why is SQL Server so special?

Hi, i need a way to use a sp in a update statement like this example:
   UPDATE dbo.TestTable
   SET Field1 = spDoSomething(Field2 , Field2)
Field1 + 2 are from the same table (TestTable)

Anyone know of any obvious issues around this?
I have a Windows 2008 server running SQL2008 64bit. The browser service is
running and TCP is enabled for both the 64 and 32 bit Native Client
configuration. The server is configured to allow remote connections and the

I need a tool to create insert sql for all data in a table ...
So, this tool would generate one insert statement for each row in the table.
Does such a beast exist ?

What's the best way to avoid filling the transaction log while deleting
thousands of rows?
Thanks,
Felipe