Viewing 12 posts - 16 through 27 (of 27 total)
As per BOL.
SQL Server 2008 does not allow for text, ntext, or image column references in the inserted and deleted tables for AFTER triggers. However, these data types are included...
January 30, 2012 at 2:18 am
Replication Concepts- http://msdn.microsoft.com/en-us/library/ms151314.aspx
January 30, 2012 at 12:09 am
Its seems the log backup file got corrupted.
January 29, 2012 at 8:44 pm
Check who all connected.
exec sp_who
January 29, 2012 at 5:27 am
Check this tool.
January 29, 2012 at 12:09 am
sp_cycle_agent_errorlog -- for recycling Sql server agent log.
January 28, 2012 at 9:38 am
You can grant backup database permission on user. without giving db_owner rights.
GRANT BACKUP DATABASE TO [test1]
GO
GRANT BACKUP LOG TO [test1]
January 27, 2012 at 9:26 pm
here is list of books which can help you to choose.
http://www.brentozar.com/archive/2008/08/recommended-books-for-sql-server-dbas/
January 27, 2012 at 8:49 pm
Viewing 12 posts - 16 through 27 (of 27 total)