will you be providing any details? For any meaningful answer we need the CREATE TABLE definitions of both tables, and which "value" (column) triggers some change to be propigated to...

i think it's an html thing, if you put a space or an html non-breaking space, i think you'll fix it:

=" " & IIF(Fields!occ_period_id.Value = Parameters!spid.Value,"Red",IIF(Fields!show_date.Value = "Grand total" OR...

i think you can generate the ALTER TABLE ALTER COLUMN statements with this:

select

schema_name(objz.schema_id) as schemaname,

objz.name as tablename,

colz.name as columnname,

colz.max_length,

'ALTER...

well, the command line program osql can give you a list of all SQL servers that answer on the network, whether they are SQLExpress versions or not would require running...

ok rich; I'm putting a link to CLR Database Project and it's solution; after unzipping it and opening it in the BIDS version of VS2008, if you go to the...

that doesn't sound right...if you can do File>>New Project, is there a template for Database Project?

I know you can download the VS Database Template from MS, and there is instructions...

well, i've done the basic setup lots of differnet ways, from providing a database for the dba to attach, to providing a script for the dba to run, to doing...

why back it up? at the moment of creation it is an empty copy of model. it would be better to simply schedule a script to backup every db at...

that's not the line raising the error; paste the whole trigger.

the error line is going to say something like this:

WHERE SomeVariable = (Select SomeVariable from someTable)

the select in parenthesis is...

this is just a WAG to get the max's without the temp table and double join;

does this return the desired results? how does it perform?

SELECT

s1.Recordid,

s1.SubrecordID,

...

well, without the execution plan that Wayne requested, we can only offer the obvious advice:

the problem is probably the WHERE statement:

WHERE (s1.Substantiation_Indicator = 'N'

OR s1.Substantiation_Sequence_Letter_Code =...

sdounds like you are trying to use this...

Stumpy D (6/11/2010)[hrSo other than indexing restrictions, there is no difference if I declare a varchar(8000) and a varchar(10) to store a 10 character string?

Seems odd as why even bother...

I don't think sql server does not have access to any printer objects; Because of that, I think what you want to do is use/create a program that reads...

i think the biggest impact on varchar sizes has to do with the ability to index the column.

if the column is bigger than 900 bytes, the index rasies an error,...