I have written few update queries and I need to log the action when they hit
the desired column.
Please help!!!

Please excuse me if this appears to be a dumb post. I have a strange issue
I have two table t1 &T2 ,
The Struct of T1 is
id int,

I have developed a .NET assembly that calls a third party web-service and rolled it all up into one DLL.  I then created
an SQLCLR stored procedure (using Visual Studio 2005) that called this DLL and deployed it locally.
Everything works fine on my local development machine.  I ...

I have a query that uses a lot of recursive CTE's and right now the
performance is kinda painful.
Here is the code
<code>

Why doesn't this work?
create table tevents (leader int, startdt datetime, amount money)
insert into tevents values (1, '2008-12-1 19:00:00', $10)
insert into tevents values (2, '2008-12-1 19:00:00', $10)

I am experiencing some access issues with SQL Server 2008 filestream data.
Here is the setup:
Webserver is on one box and SQL Server on another. These are both members of
the same workgroup.

Would it be wrong of me to say that one of the main reasons why I read this
group is to read any replies by Celko?  For some reason, his replies always
brighten my day.  Its even better if one of the other regulars gives him a
gentle prod to get him going.

I get this error from the following code as last modified is a date., I can
cast it as varchar but then it sorts as text not date. any ideas
Conversion failed when converting datetime from character string
CASE @Direction

I have a table which the UI will run a query on but the UI may or may not
send a full text search in... so it will send either NULL or a text string
to do a FTX search on a single column in a table.... now if I send just a
blank string in it throws an error (Null or empty ...

We are purchasing a Dell 2950 for the backend of a write intensive vendor
application running SQL Server 2005.  2 fixed disks will be Raid 1 and
remaining 6 disks will be Raid 5.  OS will be on RAID 1.  Data Files will be
on Raid 5.  Should the log files go on the Raid 1 or Raid ...

I know the following SQL is not valid, but it is obvious what I would
like to do.  Is this possible?   Thanks in advance.
declare @var varchar(255)
set @var = 'day'

I go to Security -> Logins in "Microsoft SQL Server Management Studio
Express" and see a login that uses SQL Server authentication.  It's
password is replaced with a bunch of asterisk.  I'd like to be able to
see what this password is but am unsure of how to do so.

I just have a question regarding changing the database collation
after a database has been used for while. What is the best way to
go about it and changing the master and then the user database?
We can change the user db with the alter database... collate

This is the error message:
Msg 50000, Level 16, State 1, Line 10
Error executing sp_oamethod COM Component 0x8004275c, ODSOLE Extended Procedure, Error in srv_paraminfo.
I don't know how to interpret the message or the return code.

If running SQL 2000, is there T-SQL query I can make to determine if I am
running on an x64 or x86 OS? Thanks.