it will allow to do the addition if the data type is numeric. if column data type is char it will just contaminate.

are you seeing any blocked processes ?

Try with using pivot feature in sql server.

http://msdn.microsoft.com/en-us/library/ms177410.aspx

If you want to get it through T-sql then u can try with SQldiff() function.

Have you tried this?

use msdb

EXECUTE sp_addrolemember @rolename = 'SQLAgentOperatorRole',@membername = 'username'

Try with using INDEXPROPERTY to get the index options.

SELECT INDEXPROPERTY(OBJECT_ID('authors'), 'indexname',

'IsUnique')

for more details.

http://msdn.microsoft.com/en-us/library/aa933195(v=sql.80).aspx

Here is...

heck your backup history in primary server.

use msdb

select database_name, description, backup_finish_date from backupset order by backup_finish_date desc

SQL Server Audit feature can help you that you want.

http://www.mssqltips.com/sqlservertip/1954/sql-server-2008-auditing-feature/

You can use CDC feature if you are using SQL server 2008. it will provide the data changes but it won't give , who did the change.

refer below...

This may work.

If ((Get-Content "Filenam.txt") -eq $Null) {

"File is empty"

}

Check this

http://www.sqlservercentral.com/Forums/Topic632795-1063-1.aspx

You can simply generate the script the user defined function , deploy it in your database

Under properties of SQL Server Agent there's a setting under the job system

tab:"Non-sysadmin job step proxy account" and create proxy account.

Here is a very good example for computed that you want.

http://www.mssqltips.com/sqlservertip/1682/using-computed-columns-in-sql-server-with-persisted-values/