this gets me a lot of information about any table/columns that have a rule:

SELECT OBJECT_NAME(OBJS.object_id) As TableName,* FROM sys.columns COLS

INNER JOIN sys.objects...

this can get you started: it shows every dependency that is using a cross database reference:

select

OBJECT_NAME(referencing_id) As ViewName,

OBJECT_NAME(referenced_id) As ReferencedObject,*

from sys.sql_expression_dependencies

where referenced_database_name is not null

getting the column names...

well, so far it looks like a single offending character, so i think you can do a simple replace();

if this produces the desired name , i would update it with...

something like this can help you identify the actual char;

i don't know what unicode null is (is that ASCII code(0)?

but this will help figure it out;

select

name,

...

also, look at this rather long thread:

Select table names from queries

in that thread you'll find a lot of ideas, but the one i'm referring to is Eugene Elutin's posts ...

is this a one time kind of thing?

you could create a VIEW that uses the query, then check sys.sql_expression_dependencies for the objects, and then drop the view again:

select

OBJECT_NAME(referencing_id) As...

nope it's not possible.

linked server password, remote credential password, and also the password used for smtp authentication for any mail profiles are stored in a CREDENTIAL object, and there is...

i just tested this on a virtual Win7/64 installation:

sql_ssms.msi failed for me, and so did sql_tools.msi. it might be failing due to prerequeisites, i'll check that next.

I'd look at with checking the data existence first:

if NOT EXISTS(SELECT 1 FROM SomeTable WHERE SomeCriteria = X)

BEGIN

--BCP code goes here

END

again,...

it looks to me that on my 2012 DVD, you could simply grab the 58 meg MSI found here:

{YourDrive} X:\x64\Setup\sql_ssms.msi, right?

ok my memory is solid, even if my confidence in it is not:

http://www.sqlmatters.com/Articles/Creating%20a%20copy%20only%20backup%20to%20avoid%20breaking%20a%20backup%20chain.aspx

Important : You might have noticed that I've not mentioned transaction log backups or log chains at all....

lol fast fingers today my friend,, but am i correct about a full backup not breaking the log chain?

As I understand it, a full backup will never break the log chain .

for me, i just do a backup with copy only for these situations.

BACKUP DATABASE [SandBox] TO ...

cummings.rd (1/16/2013)

The DB I restored is 8.25 MB; I use SQL management studio 2008, I set the options for the restore as follows...

Overwrite existing database WITH REPLACE

Leave db ready...