Know all Database sizes in a server.

We can know how much space a database is occupied in hard disk by using sp_spaceused function. If we want to find all database sizes at a time, we have to provide use  and sp_spaceused for all databases. It takes some time to write all those T-sql statments. My script will find each and every […]

3 (2)

2003-09-16

1,649 reads

Get BCP out for all tables in a DB

           The script mentioned below will export data in all tables into textfiles to a physical path on your system using BCP utility from a Database. The sql commands used in this stored procedure are BCP utility,Identity function and temporary tables.    Here you required to give 4 input parameters, they […]

2002-03-15

1,589 reads

Rows count for each and every table in a DB 

       By using this script one can find number of rows for each and every table in a database. Just cut and past this script in your DB and excute. A stored procedure will be created as 'Get_rowcounts_for_eachtable'. If U excuted this stored procedure, U can get all tablenames and rowcounts for respected […]

2002-03-07

584 reads

Blogs

Azure SQL Database – Error Logs?

By

Ok, so Azure SQL doesn’t really have its own error log based somewhere on...

Pluralsight Free April

By

It’s a few days into April, but not too late I hope to mention...

Daily Coping 7 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Read the latest Blogs

Forums

For loop in C# script component

By rohitkocharda

Hi Everyone,I have a script task calling a sequence container. What i would like...

More Time to Certify

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Time to Certify

Difference Between Lists

By BTylerWhite

Comments posted to this topic are about the item Difference Between Lists

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers