You can actually provide a criteria to sp_MSForEachTable. Like this:

sys.sp_MSforeachtable

@command1 = 'Select * from ?', -- nvarchar(2000)

@whereand = 'and O.name not like ''%sys%'''

You need the alias as the...

I can't even get the value, '2009-12-17 10:45:52.5900000', to CAST to datetime, I get this error:

Msg 241, Level 16, State 1, Line 12

Conversion failed when converting date and/or time...

You could setup a second named instance on the server that would have the correct collation.

If you have access to the code you could modify the code to use the...

Have you checked the SQL Server and Windows error logs for errors?

Jason's query is just off. Andrew's is right. At least based on the test data provided.

Wow, major can of worms opened here. As GSquared mentioned, on this site we are mostly DBA's so we lean toward stored procedures. Paul Neilsen has an excellent...

And 6 months from now you can't make changes because somehow 2 rows are updated. Always code triggers...

Please don't duplicate post it just fragments replies.

Here's the other post where I posted a suggestion.

You could do something like what Tim Mitchell suggests in this blog post. Of course first you need to load the file names from the log table.

Unfortunately I don't know of anywhere that SQL Server collects that information. For future reference the Schema Changes Report gets its data from the Default Trace. You can...

CirquedeSQLeil (12/17/2009)

---

Does anybody see a broken image in place of their avatars or images here at SSC?

About half of the Avatars show a broken image icon in lieu of my...

I can't duplicate the issue on a 2005 box. Perhaps there is an issue with 2000 that was fixed in 2005. The only thing I can think of...

It should match in either case because the parameter itself is NVARCHAR so it should do an implicit conversion.

Here's a test I have done (I'm using 2005 so could be...

This doesn't seem like a permissions issue, per se, as the procedure executes without error.

I'd recommend checking to see if the file exists in SSIS. You can use a...

Lynn Pettis (12/17/2009)

---

Jack Corbett (12/17/2009)

---

Lynn Pettis (12/17/2009)

---

I am having trouble thinking straight on this one, could someone else jump in here and help. It isn't collation, it is the...