DROP SCHEMA [ IF EXISTS ] schema_name

This can also help to list procedure

select * from sys.all_objects where type='p' and is_ms_shipped=0

but it does not list system procedures:

PowerShell Script:

Add-Type -AssemblyName "Microsoft.SqlServer.Smo, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91";

[Microsoft.SqlServer.Management.Smo.SmoApplication]::EnumAvailableSqlServers()

take a look at this article: https://dougzuck.com/sql-differential-backup-size-prediction

try this

exec sp_removedbreplication N'sqlservername'

take a look at this article: https://msdn.microsoft.com/en-us/library/dd255225.aspx

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/bd2cc7bf-ac88-4232-b967-432a2af2f25e/shared-datasets-not-visible-in-report-builder-30

Redgate or Idera

try this

SELECT name, log_reuse_wait_desc FROM sys.databases

it told you the cause for no emptying the log was REPLICATION

then execute

sp_removedbreplication youdbname

to fix

take a full backup of the database then backup the transaction log then shrink the database.

http://www.sqlserverlogexplorer.com/shrink-transaction-file/[/url]

1. Inserting records in a table

2. Viewing all records from a table.

3. Viewing only selected records from a table

4. Deleting records from a table

5. Changing data in existing...

First, I set up the database recovery model as SIMPLE

Then, delete some old files which gave the log file more space to grow.

To fix this issue enable page level locking on index

ALTER INDEX <index name> ON <table name> SET (ALLOW_PAGE_LOCKS = ON)

GO

I don't think it's possible with SQL Profiler. But if this is just for debugging then you can save the values into a table to check after the fact, but...

Check out the following link hope this will help you https://msdn.microsoft.com/en-us/library/ms151762.aspx