sp_displaylogin - sybase style

this procedure takes a sql login name and returns information about the login.anyone who knows Sybase will recognise the name and layout. use :- exec sp_displaylogin 'loginname' to get login information returned.this procedure has been tested on SQL Server 2005 sp2any problems email pgr_consulting @ yahoo.com

2007-11-09 (first published: )

1,013 reads

Collation Checker

this a quick sproc I put together to do various collation checks. databases that have different collations from serverdatabases that have different collations of columns withindatabases that have column collations different from database collation

4.71 (7)

2007-11-06 (first published: )

1,964 reads

Blogs

2020 Advent of Code–Day 3

By

This series looks at the Advent of Code challenges. As one of my goals,...

Welcome to the Azure Data Community, empowered by Microsoft

By

After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...

Daily Coping 24 Feb 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Long SSIS job failed with connection failure

By sqlfriend

I have a long ETL SSIS process, one step is to call a web...

Minimal Downtime Storage Migration of Large Databases

By Dinesh Karunarathna

Comments posted to this topic are about the item Minimal Downtime Storage Migration of...

Some questions regarding Service Broker

By kramaswamy

Hi all, I have a third-party database/application that I'm attempting to augment with functionality...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers