nope, the job was successfull.

I looked at the schema change history but got only changes what i have made today (create index) but i did rebuild indexes month ago which is done from an...

Is there a way to get t-sql code for Import/Export wizard ? Actually i want to get the code and add some where clause to the bulk insert.

John

could you let me know how to do the trigger ?

any other thoughts on improving performance on my views ?

All the databases are partitioned but still we want to split them for which we have reasons to do. The reason is that we backup and restore database from stage...

It took 2 days for the delete process though it is not finished and now ots rebooted hoping it may take the same 2 days again to recover which i...

Ok i think i figured the problem, I do run these proc fro mdiffernt server at same times may be 2 oe 3 jobs which kick this procedure for...

I am running the above proc in a job from ServerA but the proc is on ServerB.

Apart from the warning message i am also seeing this...

any comments on this ? 😎

I did run sp_help_revlogin to transfer logins but is there a way to find the paswd for that account ?

so how do i make sure INSERT is not conflicted with UPDATE ? what i need to force in T-SQL to do so?

It still sounds strange to me and could not figure out actual cause. I am also planning to do this on regular basis so as to move my dev databases...

All tables had "dbo" as the owner.

Looks like not many had this kind of issues, that is interesting.