In Profiler trace the Object altered/created/deleted events.

have u added procedures after the night backup.

nice article

Hi

do the nt group users have separate logins for each one of them? if so you can query the sys.logins table.

You can use a source control like vss. In SQL 2005 vss can be integrated to SSMS.

Hi

looks like you are importing some data that is violating the connstraint you have set for the column.

Is your db in single user mode. other wise there shud be no issues to connect to it from the app.

instead of attaching and detaching you can do a backup...

my 2 cents...

i did not see xp_cmdshell configuration option in sp_configure.

make sure you have a good box with enough RAM.

How do you login to sql server? with a network account login or sql login

Hi

Use the isnumeric function.

ex: select sum(cast(col1 as int)) from table1 where isnumeric(col1) = 1.

Does the account that cause the error have proper rights on the system.

Hi

i was able to update the view from SSMS. Anything specila on the columns that you are trying to update

ex:- identity columns..

you have a lot of reading to do 🙂

Why do you want the query text in the trigger.