I suppose that there wouldn't be so much overhead associated with an INSTEAD OF trigger... but, ya gotta be a bit careful how you write them (from what I understand)...

Gova...

This'll do it.  I use a Tally table (simple well indexed table of sequential numbers) for such a thing... if you don't have one, here's how to make one.  It's a...

Our DBA's took the easy way... everyone is part of a "role" and we grant privs, by table, by role.

The only problem with that is that read only tables don't...

Katie brings up a really good point and it really got me thinking about something that aggravates the hell out of me about both my peers and my subordinates...

I'm normally...

You bet... just remember that the "Simple" recovery mode will NOT allow you to recover a damaged DB to a point in time.  The only difference between the 3 recovery...

Not sure that's it, Peter... he lists

Now, what I need is the missing ranges.

1  01-Feb-2006  14-Jun-2006

2  01-Nov-2006  31-Nov-2006

2. 10-Oct-2006  31-Oct-2006

But, 01 - 30 Nov show up in both tables......

If you want to copy an entire database with all schema, keys, and data,... why not just do a restore from a backup???

>>Now, what I need is the missing ranges.

How do you figure that November 1 through 30 of 2006 is a missing date when it clearly appears in both tables for the...

>>I need a pure sql code to complete this issue

Why?

A count of rows from all the tables in a database for the year 1995...

Why?

Where are the tabs located in the text file?

!= is what most GUI folks write and it's a bit more difficult to read than <>.  Other than that, no difference.

What is the datatype for startdate and starttime? 

Nope... don't need the conversion to varchar for date or time.

Since he's converting to DateTime, I'd suggest doing neither.