IF EXISTS(
SELECT 1 FROM MASTER.dbo.sysprocesses WHERE LEFT(program_name,8)= 'SQLAgent')
BEGIN
SELECT SERVERPROPERTY('ServerName') AS 'InstanceName',getdate() AS CurrentDate, 'Running' AS 'SQLServerAgent Status'
END
ELSE
BEGIN
SELECT SERVERPROPERTY('ServerName') AS 'InstanceName',getdate() AS CurrentDate, 'Stopped' AS 'SQLServerAgent Status'
END
Sample Output:
What is Always On in SQL Server – Always On is High Availability(HA) and Disaster Recovery(DR) solution that maximizes database availability for Business to run as usual with minimum impact. Please go though this link to get more details on … Read the rest
Below queries can be used to check Sybase IQ Collation.
Query#1:
1select * from sa_db_properties() where PropName='Collation'
2go
Result:
Query#2:
1select db_property('Collation')
2go
Have you ever heard this DBA terminology before ? Perhaps YES or NO. Yes for those who are already into IT industry for sometime now. NO for those who are not part of IT industry. They are either FRESHERS or … Read the rest