Still fixing problems, although I did warn the teams for the consequences of their decisions and their neglecting the advises dba have handed to them.

This fixing is to the advantage...

Kind of like "I heard a brake noise ... now my dog is limping ... Why?"

Please post the ddl of your table and all of the current constraints (including FKs).

Also...

can you provide a bit of input.

- can you find any info in your sqlserver errorlog file(s) ?

- how did you set up your mirroring (ddl please)

- what kind of...

If I'm correct, any restore database command will disable SSB for the restored db.

It is up to you to double check if the SSB guid for the db is still...

GilaMonster (10/14/2010)

Yup.

Currently watching them test to see if a cup of soda can kill you through a windscreen if thrown while cars travelling at highway speed. Actually...

- can you repro the situation ? (DDL ?)

- can you post the actual tsql you tried ?

(and their results)

- what's the relation between the service account and the...

did you try "sp_changedbowner newlogin, true" ?

The maint plan has the "statistics only" option.

Otherwise you might be using something based on:

select 'UPDATE STATISTICS ' + quotename(object_schema_name(object_id)) + '.' + quotename(object_name(object_id)) + ' ' + quotename(name)...

Don't they come with solar cells on the back ... euhm top ...:alien: ????

...

GilaMonster (10/14/2010 11:15 AM)

Developer-side. My...

DBA-part taking over :w00t:

With 64 bit it is advised you set the max server memory for sqlserver !

Set the sqlserver configs "max server memory" to the value you allow it to take...

GilaMonster (10/12/2010)

Oh this wasn't a planned meeting. This...

There are multiple "split string" tvf functions you can find at SSC. Just use its search feature.

Just add an identity column to the result table and join on that.

Congratulations SSC !

Thank you for providing _the_ reference platform for SQLserver and the means to learn on a daily basis !