You have the same object name under different owner that is the reason you are receiving the error. You can use the case statement to get your output

JT Lovell

You bring the most important point. We all do the same to increase the speed of development because most of the project has a deadline of yesterday. This is...

Tao

The version which I use in my production database is similar to what you have mentioned. Just few more columns and change in the table name. When I wrote the article and...

Well I was able to narrow down to the reporting serives. I had a problem while uninstalling reporting services (Beta 2) so I went and removed from registor. Looks like...

Is this happening for only 1 package or for all the packages

What happen to my last reply ?

James

What kind of notification you want to send ? email or net send. As Tahir mention you can write trigger to do the job. Remember trigger comes with an overhead so...

Can you post the UDF ?

SELECT MIN(Login_time) from sysprocesses. will give you the most accurate information

I am sure we cannot change the owner of a Database in Enterprise Manager.

You must be dropping the UDF and recreating it.

Ok. No problem it just mean you are new to SQL Server.

In Brief DTS was the most biggest selling point for SQL Server 7.

Go to Enterprise Manager --> SQL Server...

noeld, you are correct but I would like to increase the scope of the discussion. What if you have a Large SAN Drive and logical drive create from it. Will...

You can change the extension to anything you want. Secondly even ndf can be datafile

Why do not use path instead of storing the whole file