There could be 2 scenarios :

1. Bad guy is internal. This can be controlled by network team by allowing SQL to be accessed only from the specific set of IP's

...

Hope this will help.

DECLARE @Table TABLE
(
PROCESSID INT
, START_DATE DATE
, START_TIME TIME
, END_TIME TIME
, EMPID INT
)


INSERT INTO @Table 
(
PROCESSID 
, START_DATE 
, START_TIME 
, END_TIME 
, EMPID 
)
VALUES...

Please check with your mail admin/network team whether the IP / Host configured in the Profile is white listed? If yes then double check the credentials (if any) which is...

Hope this will help.

-- Database Restore History
SELECT rh.destination_database_name AS [Database],
CASE WHEN rh.restore_type = 'D' THEN 'Database'
WHEN rh.restore_type = 'F' THEN 'File'
WHEN rh.restore_type = 'I' THEN 'Differential'
WHEN rh.restore_type...

I have written my own blog
https://brahmanand.tech.blog

Yeah.. You are right:-)

Will break it into multiple articles and will try to link them.

Thanks for your feedback... I am new to Public forum where I will write something. I...

Sorry I missed to mention it. Please right click on the server instance in the Object Explorer and then go to Standard Report. There are various Standard Reports that may...

Although SQL has feature to define the type of cursor as you have mentioned. But it's not compulsion to define it.

You can simply use the following syntax to define...

You are getting the error because you have not given the Alias to the Query Table. I gave it Alias and it got successfully compiled.

Please find the modified query for...

Hello Anuj,

Please see if the following query serves your purpose.

IF OBJECT_ID('tempdb..#Output') IS NOT NULL DROP TABLE #Output

IF OBJECT_ID('tempdb..#Memeber1') IS NOT NULL DROP TABLE #Memeber1

CREATE TABLE #Memeber1

(

MemeberIDINT

, FromDateDATE

)

IF OBJECT_ID('tempdb..#Memeber2') IS NOT...

Dear Kal,

You can also use various Standard Reports provided by Microsoft in SQL Server Management Studio. Please see if it serves your purpose.

You can also use Policy Management feature of...