Technical Article

Script to list all user and roles

This script list all the users defined for each database on the server, it give the database name, the login name and the role defined.Its use full to have quick view of witch users are dbo on witch databaseEnsure that you have the result in grid in query analyzer, and just cut and paste the […]

(1)

You rated this post out of 5. Change rating

2002-04-18

961 reads

Blogs

From SQL Saturday to Day of Data

By

A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...

PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters

By

You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...

A New Word: La Guadière

By

la guadière – n. a glint of goodness you notice in something that you...

Read the latest Blogs

Forums

BCA KCU WISMA ASIA | Tlp/Wa:0817866887

By layanan 24jam BCA

Tlp/Wa_Cs:0817-866-887. Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu Sel., Kec....

non ascii columns in a utf-8 .txt file

By stan

hi, we couldnt get our upstream data source developers to supply what is sometimes...

PolyBase Trace Flags

By Leo.Miller

Are there any good articles on all the trace flags that are enabled on...

Visit the forum

Question of the Day

Running SQLCMD I

I run the SQLCMD utility as follows:

lcmd -S localhost -E
I then type this (the 1> is the prompt):
1> select @@version go
If I hit enter, what happens?

See possible answers