Pages

▼
Thursday, March 24, 2022

Is Full Text Installed in your SQL server

›
  SELECT  CASE WHEN FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1 THEN ...
Tuesday, December 14, 2021

Get all databases a login can access

›
-- First Check you have access in all the databases in your system.. SELECT s.* FROM master.sys.databases s WHERE HAS_DBACCESS(s.name) = 1 -...
Thursday, February 13, 2020

SQL server browsing history in SSMS

›
Where do we the file, which stores the history of sql servers which we browse through SSMS. C:\Users\ [YourUserName] \AppData\Roaming\...
Wednesday, February 5, 2020

Script to pull database user and their roles, permissions

›
DECLARE     @sql VARCHAR(2048)     ,@sort INT DECLARE tmp CURSOR FOR /*********************************************/ /*********   DB...
1 comment:
Friday, August 17, 2018

How to find your IP is static or Dynamic

›
Open command prompt.. type  IPconfig /all If you find DHCP Enabled ....:  Yes,  -- it says your IP is Dynamic                          ...
Tuesday, March 7, 2017

Simple Dynamic SQL to get system tables information

›
Simple Dynamic SQL to get all tables row count from the database. You have many number of ways to get this information. SELECT 'SELECT ...
Thursday, January 12, 2017

Restore/Attach the database with out Log(ldf) file.

›
-- You can attach a database to the server just with mdf even though you dont have ldf. USE [master] GO EXEC sp_attach_single_file_db @dbnam...