sp_msforeachtable

ADD SQL OBJECTS(TABLES, VIEWS, SPS, UDFS ET AL) TO ALL THE DATABASES ON THE SERVER.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4 (1)

You rated this post out of 5. Change rating

2011-11-14 (first published: 2011-09-19)

671 reads

Finding no. of Rows in all tables of a datbase in one line of script

Consider you have 100+ tables in your database, you want to find a quick way to find no. of rows in each table

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

3 (15)

You rated this post out of 5. Change rating

2011-01-11 (first published: 2010-12-22)

2,455 reads

I’ll walk through the KDA UI and tackle the first challenge before diving into...

While I mostly write about SQL Server, I have a soft spot for Kusto....

Many organizations list customer testimonials and quotes on their websites or literature. It makes...

Hi Guys, I'm not sure if this is possible or not, but let me...

Comments posted to this topic are about the item Life Moves Pretty Fast

Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...

Can I have a collation expression like this in SQL Server 2022?

...
WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS
...