You can create DDL trigger as

CREATE TRIGGER ddlTrigger

ON ALL SERVER

FOR DDL_LOGIN_EVENTS

AS

.....

..

…

.

You can use EVENTDATA() function that returns info such as event time, SPID, and type of event firing...

The property you are required is identity. But i am afraid that you can not define identity for a view itself.

You can use crystal reports for JBuilder. Or if you want every thing from scratch then you may look in to JDBC classes for support.

Use sp_addlinkedserver instead of sp_addserver but as markusB said it will work for default instance only. For named instance it will not work.

sp_change_users_login @Action='update_one',

@UserNamePattern='username',

@LoginName='dbo'

GO

provide name of your user in 'username' and then try to map the user by running above command.

Use 'SQL Server profiler' primarily. Depending upon concurrent client requests consider your memory and disk configurations. When your system get slow use OS utilities to monitor CPU and memory usage...

To confirm the reason given in error message use following commands by selecting tempdb

DBCC showfilestats

sp_spaceused

DBCC CHECKALLOC

sp_helpdb tempdb

If it is confirm that issue is due to full file...

You can use ad hoc query with open row set in following way

SELECT *

FROM OPENROWSET('SQLNCLI','dba\test';'sa';'test',

'SELECT * from pubs..authors')

Go

where dba\test is instance sa is id and test is pwd

As extension indicates pagefile is system file and windows may be accessing it for memory allocation to several processes. So you may not customize its security. Its under OS control....

use following by giving scalar function name

sp_help 'scalar function name'

Try to identify process that is using your file. You may use any utility like task manager or process explorer.

Are you able to complete backup process manually? and also try system restart.

Try using local windows account for SQL Server agent and other services. If that solves the problem then later you may trouble shoot the domain account permission and connectivity issues.

I have used red gate tools and found them gud. But i would suggest that you should use trial versions for these three and analyze the best according to your...

Try following

--To delete backup history of all databases before '2007-07-07'

USE msdb

...