SQL2012/2008R2/2008 Express is free, allows a database of 10 gig, and is much much easier to use than CE;

CE is a very trimmed down database version that is aimed towards...

without the code i mentioned previously, it's really hard to guess;

since i cannot test this,...

the cursor is your # 1 performanceproblem then.

i'm sure you can replace it with a set based function:

if you are doing the same logic to each row in the cursor,...

well, the obvious fix is to use an Inline Table Valued function instead of a scalar function;

i was able to convert it easily, but the example usage you pasted is...

and some ready made code to test it: creates a rule and a column that uses it:

CREATE RULE [dbo].[NumericCharsOnly]

AS

--@value NOT LIKE '%[0-9,-+]%' ESCAPE '!' --bad way...minus and spec...

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