You can start by using the IsNumeric() function on the varchar column to see if there are values that are not recognized as numeric. As the link says, you...

I don't know the answer to this one because I...

You can just do a convert(INT, datetime_value) and it returns the # of days from 1900-01-01. Of course it also does rounding do when you get to around noon...

Ondrej Liptak-260768 (12/9/2011)

---

Jeff I've been faced the same problem. succeeded solved by IS_MEMBER('Domain\Group').

Hope it helps! 🙂

Cheers, Ondrej

part of function is here:

...

IF SUSER_SNAME() in ('DSDEV\M..L','DSDEV\P...Z','BossUser','e...e','BossUserTest','DS\AP_...SUPP','DS\X...X')

or is_member('DS\AP_...E')=1

SET @WorkLoad='DBOXwg'

else if SUSER_SNAME()...

Brandie Tarvin (12/8/2011)

---

So with this Redmond report about IT losing jobs this year, and possibly next year, how upbeat or pessimistic are you feeling about the industry?

It's hardly any...

I also know Tim Ford and recognize one other name. Mark Johnson, believe (I don't have the site up now, but looked earlier.).

You can combine them, but you will get a warning for each connection that doesn't exist in the package. I prefer to use SQL Server Configurations and store them...

GSquared (12/1/2011)

---

GilaMonster (12/1/2011)

---

Today's nugget of wisdom - when computer is giving all sorts of drive-related errors, first check that the sata cables are properly seated, especially if the computer has...

Gus, Congrats on 21 years. I have a few before I hit that.

I think you need to take more vacations or at least time off.

I agree that thinking time is important. Too often I don't take enough time to think things through completely before I start working. This almost always leads to...

So I had to post this job description I got via email today for a SQL Server DBA position:

Qualified candidates will possess programming skills, such as skill in the use...

It's Thanksgiving Day here in the U.S., so Happy Thanksgiving to everyone who celebrates, and if you don't happy Thanksgiving to you anyway:-P.

I'm very thankful for the friendships that have...

Didn't get a response from Michelle yet, but someone did say that it may just be because she hadn't gotten around to coding in the rebuild. I know that...

Nope I don't know why she is only re-orging partitioned indexes. I'll ask.

This is how SSMS generates the trigger text:

exec sp_executesql N'SELECT

NULL AS [Text],

ssmod.definition AS [Definition]

FROM

master.sys.server_triggers AS tr

LEFT OUTER JOIN master.sys.server_assembly_modules AS mod ON mod.object_id = tr.object_id

LEFT OUTER JOIN sys.server_sql_modules AS ssmod...