The trigger is firing all the time, the issue is that you have something in your trigger code that is missing an update. I have to be honest and...

Interesting, I'd never seen the .d0 trick before. At least I came up with the LIKE solution on my own. I always seem to forget the %[range]% functionality...

The easiest way to check user rights is to check in Enterprise Manager in the security area of the database to see if the user is

granted rights to the...

I think you are stuck deploying it 3 times. There may be a way to write something in .NET that mimics the deploy process where you supply a path...

Madhivan,

Can you explain where you found this and why it works?

I did not find anything about this is BOL.

Thanks,

I was going to ask Jeff the same question. I knew there were issues with IsNumeric, try IsNumeric('$'), but I've usually been able to deal with those issues in...

I've always worked in small shops, but I always insist on separate dev and production systems. Since I and my co-workers have fill all the roles from design to...

There is not a function that does that, but you can use the isnumeric function and a case like this:

Select

Case

...

Yeah, but that doesn't ship with SQL Server.

So what do you want for when:

1. d1 > d2

2. d1 is null

3 d2 is null

Here is an idea:

IIF(d1 is nothing or d2 is nothing, -1, Abs(DateDiff("d", d1,...

Why don't you change the error output of the data conversion task to send the error to a file so you can see the data that is causing the error?

My...

Check out this article: http://www.sqlservercentral.com/articles/T-SQL/63681/

What else is running on your SQL Server when you are running the SSIS packages? Does the SQL Server take the same network routes to the source and destination...

Maqsood,

If you have read through this thread you should have understood that there is not a way to update system tables in SQL Server 2005/2008.

IMHO, you need to...

You would get more ideas if you adequately explained your problem. Am I to understand that you have a SQL Server database which you are connecting to using MS...