It sounds to me like there's a problem with the C# code that's being used. In a bit/bool data type, -1 = 1 = True, 0 = False.

I have...

On updating the underlying tables via a view, the answer is "it depends". Some views, yes, some views, no.

The rules on this are detailed in Books Online.

My server is running on US_English, but this worked:

set language british

create table #DateTest (

Date datetime)

insert into #datetest

select '30/06/1980'

select *

from #datetest

Without the set language command, the rest of the code generates...

I have to say that the question and answer seem good to me. I would never have thought of even trying to do this (find out if SQL Server...

My first SQL database had 20 or 30 tables, 1 stored procedure, and 50 or 60 views. Some of the views went at least 5 levels deep before they...

How big are the tables? Millions of rows?

Creating statistics on a table is usually automatic. You might want to check the table properties on that regard. You...

On the triggers, yes.

Most of the time, but not always, a reporting database can be loaded periodically from the OLTP database. That means, instead of every update happening in...

I don't know about the invalid keyword thing.

Visual Web Developer comes with SQL Express. You'll need to download SQL Express Management Studio from microsoft. http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Once you've downloaded and installed...

You can have recursive triggers (which are usually a problem, but can be done if needed) in SQL Server.

You can have recursive procs in both 2000 and 2005 (might be...

Query text can pretty easily be stored as varchar(max) in a table. Perhaps with a user ID column and a last-used datetime.

Dictionary definition of "Recursive":

Recursive (re-cur-siv) adj: See recursive.

If you can't normalize it, and can't modify the code, because the system is in production, then even if you could add a default constraint to the table to handle...

select name, definition

from sys.sql_modules modules

inner join sys.all_objects objects

on modules.object_id = objects.object_id

where definition like '%' + YourObjectName + '%'

Replace "YourObjectName" with the name of your function, or with a variable, and...

I'd replace the whole thing with 2 "exists" queries.

where exists

(select 1

from table1

where exists

(select 1

from table2

where id = table1.id))

Of course, it'll need something in the outer query that ties table1 to...

Are these two columns in a larger table that has more columns with other data, or is this a table with just these two columns and five rows?

In the case...