Unfortunatly I have no control over table names. Amoung the tables I have in this db are a couple called System_

I can do some sql to find all tables that...

sp_help '

I'm guessing it uses sysobjects in the background and it's not much use if you want to use the date in later code.

Looks perfect. Thanks for your help

srowlands: a trigger fires once per operation. If an update affects 20 rows of a table and there is an update trigger, then the trigger will fire once and both...

I'm no expert on replication, but can't you do a sp_repladdcolumn to create a temp column, copy the data over, sp_repldropcolumn to remove the old one, then do another sp_repladdcolumn...

There are actually two things wrong, the one the correct answer refers to and the additional problem that on an insert, no records will be inserted due to the inner...

Select @var1=col1, @var2=col2 from table where....

HTH

The integer portion of a datetime is the date and the fractional is the time. I don't know the details of how it's stored though.

What are you trying to do...

For some reason I couldn't reply to your other post...

I've found that inserting a date into SQL in the format yyyy/mm/dd is often best. It's unambiguous.

Maybe you can switch the...

By default, a primary key is supported by a unique clustered index, so by dropping the key and creating the index you won't be gaining anything.

You will gain if...

Alternatively if you want to avoid the conversion to char

select count(*) from

WHERE

cast(floor(cast([datetime] as float)) as datetime) = cast(floor(cast(getdate() as float)) as datetime)

The above is faster than a...