Looks like you have an orphaned user in your restored database. Remap it after the restore with the ALTER USER command. The syntax is something like this (I'm...

Oops! Duplicate post.

You can probably do this without a cursor, although it would be messy. However, this kind of display formatting is better done in the presentation layer than in the...

Is your database in Full recovery mode? How often, and when, do you back up your transaction log?

John

But what was quoted wasn't the whole solution. See my first post...

Yes, there almost certainly is a better solution. But you haven't posted any DDL or data for EVENTS, so we can't offer you any tested code. A good...

On a default Windows installation (depending on the version), it's C:\WINDOWS\system32\drivers\etc\hosts. But you didn't need to ask me that - you could have just typed "hosts file" into your...

In the Derived Column Transformation Editor, there's a list of date/time functions. Pick one of those. If you're unsure of the syntax, use a search engine - there's...

Ask your network people whether there's a DNS alias set up on the DNS server. alternatively, have you checked your hosts file to see whether there's an entry in...

Have you checked the sqlagent.OUT file? That will tell you why it's failing. If the file doesn't exist, or the date on it is older than the last...

Create a new data flow and use a derived column transformation to split the date into its constituent parts.

John

Works OK for me. Please will you provide table DDL (in the form of CREATE TABLE statements) and some sample data (in the form of INSERT statements) for table1,...

That's not a view - it's just a SELECT statement. Please will you post the whole view definition and we should be able to help you.

Thanks

John

Thanks for posting back. It's customary in situations like this for you to post some code or a description of how you fixed it, please, in case someone else...

It all depends how many packages you have, and how distributed are the servers that they read or update. Usually, I would want my config information close to my...