To summarize your request for a view to simply reject those things where "somecolumn" has things in it besides numeric digits...

CREATE VIEW dbo.someviewname

    AS

SELECT somecolumns...

Ummmm.... press the {f8} function key...

Thought I'd throw one of my own into the circle...

If you don't have a "Tally" or "Numbers" table, now is as good a time as any to make one.  A...

Jacques,

I'm not sure how your example helps because the cpu time you produce is for the entire server, not an individual spid... as you said about simple elapsed time, if...

I have to admit... I've never seen an ideally designed database  (usually, too many cooks in the design with too little knowledge, you know...

I'm thinking that's likely true because, as someone else pointed out, the TEMPDB database is set to the "SIMPLE" recovery mode.  However, most other operations on temp tables are logged......

If I understand the problem correctly... this might be a good job for a trigger.

... of course, there are no possibilities when you don't respond to the people trying to help.

Does anyone have a Microsoft reference or test code to support that one?  I'm kinda in the "Myth Buster" mode at work about Temp Tables and Table Variables... anything you...

Simple obfuscation using Exclusive-OR is fine for keeping the honest man honest...

But one of the first things hackers do on an SSN column is something like this...

1.  Take a...

SG,

We can help but we need to see some examples of the dates... as you can see from the posts above, there are a lot of possibilities...

Wow, Mark... that's quite the laudry list...

There are many solutions (and caveats as Tim pointed out) to your list of nice-to-haves... if you do a search on this site, I'm...

I don't have one but, rumor has it, that there are encryption tools on the Software Developers Kit disk that comes with SQL Server.  Without a doubt, someone will post...

Good point... but you have to know what the Recovery Model is set to.  If it's set to FULL, even SELECT INTO is logged.  Again, don't take my word for...

Never mind... here's the answer to that last question in my previous post...

http://support.microsoft.com/kb/153441/EN-US/

... and make sure that you read the part that says ...

NOTE: This problem does not...