2018-11-05 (first published: 2018-10-22)
812 reads
2018-08-08 (first published: 2018-07-22)
381 reads
2018-07-17 (first published: 2018-06-26)
841 reads
User access management on DB & object level
It will help to find and manage the users access on DB level
2018-07-05 (first published: 2018-06-26)
387 reads
Script out EXISTING database mail profile's settings
Script out EXISTING database mail profile settings
2018-04-25 (first published: 2018-04-23)
10,377 reads
Login restriction from selected applications and users
It will help to DBA for restrict the SQL Users login from selected applications programs and track there logins with Host name and other details
2018-04-11 (first published: 2018-03-29)
593 reads
DB Blocking Automated E-mail Alerting with Blocker SP ID & query's
It will Help DBA to monitor the instant blocking and can take the action immediately on blocker query and users.
2018-04-05 (first published: 2018-03-22)
970 reads
Grant Sp_who2, & who3 proc execution without granting sysadmin access
It will help to development team to find their developed & DB server status check.
2018-03-28 (first published: 2018-03-22)
847 reads
All Link servers working status check and failure alert over E-mail
This procedure will help you to automation of link server failure status check with help of SQL agent job scheduling. Job query :-
exec proc_check_linked_servers 'profiler name','E-mail ID'
2018-02-07 (first published: 2018-01-30)
491 reads
Blogs
Join me in Germany in June
I have been selected to speak at the DataGrillen conference later this year. I will be...
Daily Coping 26 Jan 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 25 Jan 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Data sources on another domain
Hi, bit of an odd one this. I have a customer who wants to...
Script all objects in a sql database where name starts with Custom
Is there a way to automatically script all the objects where name of objects...
Inconsistent error with OPENROWSET from XLS
We have a process that we run to import parts into our inventory database. ...
Ask SSC