سرویس پایگاه داده

..............................................................................................

Change the owner of tables and store procedures in SQL Server

By default who over creates the table, store procedure or the View is the owner of the object. There are several scripts you can run to change the db back to dbo . There is one good thread you can refer to : In additional note there is a script you can run in query analyzer and it creates the query ( first go to menu / query / set : result in text ) and then copy and paste the result back to query analyzer and it simply changes all owners.

SELECT 'EXEC(''sp_changeobjectowner @objname = '''''+ ltrim(u.name) + '.' + ltrim(s.name) + '''''' + ', @newowner = dbo'')' FROM sysobjects s, sysusers u WHERE s.uid = u.uid AND u.name <> 'dbo' AND xtype in ('V', 'P', 'U')AND u.name not like 'INFORMATION%' order by s.name


SQL Injection (Database Hacked)

If your database ( SQL or Access ) got hacked but your files are not changed, that is most probably because of SQL injection. You should verify all browser inputs and URLs before running them. The link provided here is a guideline of what you can do to prevent that.
This is considered the lack of security in web application and it is not related to server.