Are you using a 'public' service like Yahoo and MSN, or a proprietary service, like your employer's (for example)? If a big public service, it's possible that the mail...

'knowingly or unknowingly'... what scares me is what were the problems they avoided with the solution they provided?

As if you needed another reason to lose sleep....

What are you using the object_definition function for?

Also, what if you do this in two steps: 1st, script the table. 2nd, modify the table to add the object_definition...

Congratulations!

I wanted to go back and revisit something you quoted earlier, from a page in the MS site:

Using the Standard User account helps protect the system because all...

Are you testing the SP with 'sa' powers? Have you tested using the same privileges that the production job runs with? Most likely, it's a problem with not...

Some other considerations:

1. If you don't use the order line number, SOMEWHERE in the database, how can you guarantee that the printing order of packing lists, invoices, dunning notices,...

Even with the standard of ALWAYS using TableName.FieldName, ensuring that field names are unique within a database provides greater sanity when talking about the names. How many conversations have...

What if you rephrase this code so that it begins

=Fields!Exam_Description.Value & IIF(.... ?

also, is there any way of using a CASE statement instead of IIF?

also, what version are you...

Please know that this BB does NOT support graphics. your 'looks like this:' is blank. If you place the visual to a web-accessible page, and provide us with...

When you go back to the vendor, ask them to specify what database and version they are citing for the resolution of ambiguous references. Especially since the reference they...

initial problem statement shows trace parameters 1204 and 3604. What's the difference between 3604 and 3605?

Is the data structure identical on both ends? If so, then use your primary key (pk) to test - if the recordcount >0 on a select where pk =...

Does this mean that, after you've placed the 'order by' clause in all the app code, you can remove it from the view, so there's no ambiguity? just a...

is there a reason you don't specify, instead,

WHERE (cm.contact_id = @contact_id) OR (a.branch_id = @branch_id)

and not care if both variables = 0?

See if that speeds up your execution?

What happens when you compare (Fields!Complience.Value + 0) > 11, for a value of 15?