I still cannot duplicate even when creating an index on a nullable column. Have you tried to drop and recreate the index to see what would happen. Not ideal but...

yes, it is a matter of mapping them into sqls logins first then attaching them to the db via sp_change_users_login. The user account in the db is technically an alias...

I cannot reporduce this on any of my tables but none are over 50k records now and I gave up access to the only large one I used to control....

In most cases the default is just fine. It really depends on if you have specially needs or interactions you need to be sure are prevented while a process occurrs.

If you are going to load anyway why not forgo the tirgger and have the dts kick of a check process afterwards looking at the loaded data. As for why...

When you say "a given months data" are you pulling it over on a schedule and keeping or do you jump around the data a lot?

Most likely better to perform in you front end than on the data side. But that is my only thought right off.

What Service Pack do you have installed.

I have never seen this, but have no relation to understand exactly what you are doing. Can you post the query for the view (complete DDL of the view) so we...

Please do not cross post, most people will look at the active items regardless of where you post. See comments in

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=369898

See what happens when you do this.

select count(1) from tb_Propose where Dt_flag is null

select count(1) from tb_Propose where Dt_flag is not null

select count(1) from tb_Propose 

Just curious.

Per MS

Clustered SQL Server do's, don'ts, and basic warnings

_{If you have an issue that requires you to rebuild or reinstall Full text search on a SQL Server 2000 failover...}

To get this to work create the user in security and do not grant access to the DB. It will casue the issue you are seeing and it only means...

Try as noted in BOL

sp_changeobjectowner  'existing_owner.object','dbo'

without the existing owner it is most likely looking for dbo.Test and not John.Test if say John where the owner.

Are you sure it is missing and that you have not actually turned off the viewing of system objects? Is this the only thing missing?

Does this database have many...