you said it occurs when the package is run on the server, by the proxy or service account, right? or by another, specific user.....

check the permissions on the...

you'll need to use good old fashioned strings or REPLACE functions.
and you need to take into account the data types....you said number, but is it a string representing a...

look in the windows event logs;
you might see something like the network guys installing patches, which required a reboot;
look deeper into the sql server log, specifically at...

changing the owner for object or jobs are just  object level schema lock; no instance wide affects. if someone is connecting or updating , you might have to wait for...

i was thinking of recovering table space, typically tied up in indexes or in heaps.
 and not reserved space for the whole database.

AS Jeff mentioned,you have to shrink...

if you run the query below in a given database, it will check the index statistics and tell you the last time a table was read/updated since the last time...

minor annoyance: the email link for old vs new forum posts: new posts have a direct link to unsubscripbe.
old posts have the generic link to all the items you've...

Over the weekend, I saw a huge flood of the same kind of spam we were getting in the old forum software; mostly links to current events like football games...

each database has a system view named sys.database_role_members, which is just ID's associated ot roles; you have to join that against database_principals to get what you are after.
you'll need...

After a large delete, you'll need to rebuild the indexes on the table.
the deleted items still take up the pages they used to occupy, and reindexing rearranges and deletes...

I managed to break the javascript in a post, so I cannot edit the post, nor use the mini "Explore "menu in the upper right that typically has a link...