if the referenced table has a specific column name (in the example [StatisticsName]), this will find all objects that are referencing the object(ie table) in question.

...

using row number is how i would find the dupes.
the query i'm using here can be switced to a delete by simply swapping the commenting the --DELETE and commenting...

you can end up getting the empty  "toolbox" from visual studio, which IS NOT THE SAME as the ssis toolbox.
there's always a shortcut for the SSIS toolbox and SSIS variables...

I think the Flat File Connection Manager will create a...

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...