Is there anything known where SQL Server service itself would try to initiate a restart on the SSAS service?

The service account used for SSAS and the SQL server engine are...

Also, you set identity insert on, but then not off.

Truncate will clear out the records BUT if you have a recurring ghost problem like I did, it is not an end all solution.

If you are getting the "big record"...

Also, you may have something set to "Append" to existing record, whcih would also make the growth occur. I'd have to know if you checked for space used internally for...

Sort of... ish... yes. I have not seen the issue since my last server restart but I have not confirmed it was a result of an attempted "fix" done.

You can...

AWESOME! Thanks!

I had not been using xp_cmdshell to execute the net use command. I knew I was getting hung up in permissions but just didn't know where. Well, now I...

I had been using "NET USE j: \\SAMESERVER\C$\SQL\SQL_Data\J /persistent:yes", even to the point of running through a scheduled task in a batch script, as the service account. The service account...

To add to that, I had hidden a duplicate field that was still in the definition of the drill through action. I needed to disable a different, still existing field,...

Looks like I forgot that under the cube editor, under the actions tab, under Action target, under Measure Group members, I needed to re-select the measure group members needed. The...

Cores or physical by defining "CPU" as you use it?

Is this a dedicated SQL box or are other applications running?

Do you have any settings for max degree of parallelism on...

Sorry, trying to do a few things but overall

declare @insertednif and @deletednif

select via select

if insertednif <> deletednif

begin

rollback

return

end

update c

set c.nif = (needs reference or is ambiguous).nif

from contribuintes c

join...etc...

Either the above with reference, or just take out the c and preface with full name. Sorry for little detail,...

Take another try at your update statements.

Update ref set column = value

from

table ref

join othertable ref2 on ref.column = ref2.column

First google result I had found:

http://geekswithblogs.net/faizanahmad/archive/2009/01/05/join-in-sql-update--statement.aspx

Have a ticket in with RedGate. Have a ticket in with Confio, but need to update support and version before moving forward with Confio. Confio could not work with the...

Thanks, that problem sounds about right with what I have been seeing. I have an open ticket in to RedGate about this since last week Monday/Tuesday. My search terms had...