Simple thing would be imagine 2 tables, with 1 column.

Trigger on each table after the insert of a value into the column

Insert into Tab1 fires Trig1 which inserts the value...

http://msdn.microsoft.com/en-us/library/ms142571%28v=sql.100%29.aspx

Strange on seeing the row_overflow as that should kick in when the row spans more than 8060 bytes, but the maximum row length is only 6148 bytes so strange on...

Unless the de-frag has resulted in ordering which has pushed the lob and row overflow to their correct places in the index.

What is the result of MAX(LEN(column)) for all the...

By query, then use linked servers

With difficulty, 2005 onwards, SQL doesn't store if it is proc/core or server/cal licensed, it is up to you to assign licenses logically to ensure your server estate is covered...

Have you set up the correct SPN's

Have you set the correct permissions to the files it is complaining about not being able to access? Do the files even exist?

Create a job in SQL Agent.

Job Step Type of SQL Server Analysis Services Command

Command below

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Parallel>

<Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">

...

Depends what you are trying to do.

Please follow the link in my signature on posting code and data for the best help.

But with a temp table you would have to...

As with anything licensing and the legalities involved, go and speak with your MS Reseller or MS directly. Do not take what anyone says on a public forum as...

Shrink in small chunks, but then also remember to perform index and statistic maintenance as index fragmentation will be shot to pieces.

If the agent has a lock on it, see what is actually logging to the file, is it the actual SQL Agent Log file or is it a job which...

Duplicate post http://www.sqlservercentral.com/Forums/Topic1397177-146-1.aspx

Please follow the link in my signature on posting performance problems.

But have you checked the execution plan, index fragmentation, use of indexes, missing indexes, general troubleshooting steps etc...

Please follow the link in my signature on posting performance problems.

But have you checked the execution plan, index fragmentation, use of indexes, missing indexes etc etc etc?