Technical Article

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,087 reads

Technical Article

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: )

2,057 reads

Technical Article

proc to order xp_enumerrorlog

this is a quick stored procedure I put together when trying to find a log for a particular day (xp_enumerrorlogs returns the archive is as a varchar, so 1 is followed by 11, 12 etc rather than 2) sp_display_errorlogs with no parms returns output in archive id order. if the parm 'size' is passed in, […]

2007-09-21

485 reads

Blogs

Storage Field Day 23 – HammerSpace

By

I am thrilled to have been a part of this year’s Storage Field Day...

Daily Coping 16 May 2022

By

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

SQL Saturday Jacksonville Slide Decks

By

Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...

Read the latest Blogs

Forums

Linked Servers Role

By rogue1009

Hello, I have been asked a question which i am struggling to find information...

Options to access/modify cloud data?

By waxensens

Hi, Novice here, so please forgive my simple question. I have previously run Microsoft...

Row wise sum based on condition

By parthi

Hi All, I have an input like below. mytable: id | name | no...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers