Tags » SQL Query

Finding SCCM Maintenance Windows

Use below query in SQL Management studio to find Maintenance Windows on Collections:

SELECT c.Name, c.Comment,SW.Description, SW.StartTime, SW.Duration
FROM v_ServiceWindow SW
JOIN v_Collection C ON C.CollectionID = SW.CollectionID
ORDER BY c.Name

SCCM

Access to run SQL Profiler/Trace

If you need to provide access to someone only to run SQL Profiler SQL Trace you need to Grant ALTER TRACE permission. This feature is introduced in SQL Server 2005… 25 more words

SQL

SQL SERVER - Fix Error 7202 Could not find server in sys.servers. Verify that the correct server name was specified

The other day I received following error when I tried to restore a database from one server to another server.

Msg 7202, Level 11, State 2, Line 1… 95 more words

SQL Authority

Oracle sql query select use rownum

(SELECT Table.*, ROW_NUMBER() OVER (ORDER BY id) R FROM Table)
WHERE R > x and R <= y;

SQL Authority News - Secret Tool Box of Successful Bloggers: 52 Tips to Build a High Traffic Top Ranking Blog

When I started this blog, it was meant as a bookmark for myself for helpful tips and tricks.  Gradually, it grew into a blog that others were reading and commenting on.   627 more words

SQL Authority

SQL SERVER - How to See Active SQL Server Connections For Database

Another question received via email -

“How do I I know which user is connected to my database with how many connection?”

Here is the script which will give us answer to the question.

34 more words
SQL Authority