I usually let windows download patches and SPs from a trusted and filtered internal WSUS server, but I install manually during scheduled maintenance windows. Usually I do this every 1...

Can you expand a bit?

An example would help a lot.

Unfortunately there's no builtin tracking system in SQL2005.

You can set up a DDL trigger and log changes to a table.

Something similar to this:

CREATE TRIGGER [TR_Auditing] ON DATABASE

...

So, no doubt that the offending column is the one with LONGVARCHAR data type.

I have no idea how this can be set in T-SQL. Have you checked the provider's documentation?

No way, AFAIK.

I had to do something similar in the past and I ended up changing the program name property in the connection string to add the connected windows login....

Have you tried dropping the existing package first?

You could try to find the offending column excluding the other ones from the query.

For instance, if columns A and B have a default value, you could try to insert...

Are you sure that the error comes from the text column? That message would make more sense on a numeric column.

So, this means you're human, after all. 🙂

Enjoy your vacation, Gail: I'm sure you deserve it.

Stefan Krzywicki (6/24/2011)

---

Also, after you post, there's a bar that says you're subscribed at the top of the posts. To the right of that there's a link for "Edit Subscriptions"...

Also, I'm not using the email client to read SSC notifications.

I set up an email filter that forwards all emails from "notifications@sqlservercentral.com" to a nice email to RSS service called...

I don't know if it helps, but you could click "Topic options" on the top right corner, "Subscribe to Topic" and choose "No email notification (just add to list)". I'm...

Ah! I didn't notice it. My bad. :blush:

Thanks for the pointer.

Jayanth_Kurup (6/23/2011)

---

I recently learned that we could host database files on a Raw partition , I always assumed they would have be part of a file system , btw i...

It doesn't say "permission denied", it says "login failed".

I think it's a username/password issue. Have you double checked the credentials?