First question I have is why are you using user-defined types, what are you using them for? Why in model?

Second of all you need to do some...

I agree, I often build it up that way..

I just think the whole idea, is well, stupid, sure it isn't a best practice to do so, but if we go...

Thats ok, I understand..

CEWII

It should yes.. You shouldn't have to do anything..

CEWII

This view, is it for reporting?

CEWII

It sounds like you need to have permissions setup for that file. My guess is that the user that SQL Server uses to login doesn't have permissions on that...

Short of using triggers to maintain a table I don't have a good answer.. I'd have to know a lot more about your app..

CEWII

You can't fully clear it. Data is written here BEFORE it is written to the MDF. Depending on the recovery mode of the database it may not be...

How often does the underlying data change? If not a lot then you could use SSIS to assemble and bulk load a table with the denormalized data. Or...

It contains the transaction log for a database and is a required file for each database..

CEWII

The last time I dealt with this there was a single table that held all the translations for all the tables.. It was structured like:

MasterId int

TableId int

LanguageId int

TranslatedText nvarchar(200)

The...

Your question is a little ambiguous..

You want to use the login that your SQL Agent to access a file that is a data source in a dataflow task?

From where, SQL...

Does the website use the base tables as well? I'm just a little fuzzy on this whole thing.. I found I have been moving away from using indexed...

Can you ping 'stmprelay.remc' from that machine? If not then this will never succeed. That is an odd name though.. It isn't a fully qualified name. ...

How big are these tables? How long does the re-index take?

The synonym does have to be a drop/create, but I don't think it does any blocking..

When I first read...