Sql Server & SSRS Tips

USE [master] GO /****** Object:  Database [TrackingDB]    Script Date: 1/5/2017 9:24:50 AM ******/ CREATE DATABASE [TrackingDB]  CONTAINMENT = NONE  ON  PRIMARY ( NAME = N'TrackingDB', FILENAME = N'D:\TrackingDB_DO NOT DELETE\TrackingDB.mdf' , SIZE = 380928KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )  LOG ON ( NAME = N'TrackingDB_log', FILENAME = N'D:\TrackingDB_DO NOT DELETE\TrackingDB_log.ldf' , SIZE = 517184KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%) GO ALTER DATABASE [TrackingDB] SET COMPATIBILITY_LEVEL = 110 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [TrackingDB].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [TrackingDB] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [TrackingDB] SET ANSI_NULLS OFF GO ALTER DATABASE [TrackingDB] SET ANSI_PADDING OFF GO ALTER DATABASE [TrackingDB] SET ANSI_WARNINGS OFF GO ALTER DATABASE [TrackingDB] SET ARITHABORT OFF GO AL...

-- Create a login for SQL Server by specifying a server name and a Windows domain account name. USE [master] CREATE LOGIN [XDEV\mjawad] FROM WINDOWS; GO -- OR use the code below to Create a SQL Server User --USE [master] --GO --CREATE LOGIN applogin WITH PASSWORD=N'applogin', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON --GO -- Cursor For assigning roles to the specified Users on all databases ------***************************************************************** For DBA'S USE master GO DECLARE @dbname VARCHAR(50) DECLARE @statement NVARCHAR(max) DECLARE @UserName NVARCHAR(100) SET @UserName='[XDEV\DBA]'     ----***** Set User Name here to give permission ******** DECLARE db_cursor CURSOR LOCAL FAST_FORWARD FOR SELECT name FROM sys.databases WHERE --name NOT IN ('master','model','msdb','tempdb') AND state=0 OPEN db_cursor FETCH NEXT FROM db_cursor INTO @dbname WHILE @@FETCH_STATUS =...