Locate primary key - foreign key relations

Recently one of my friend was doing some investigation in a new/unknown database and had really hard time locating the primary key – foreign key relations. Like it’s really tough to locate these relations when not enforced at database level in terms of primary key and foreign key constraints. But generally all database developers keep […]

4.14 (7)

2011-09-14 (first published: )

2,720 reads

Combine multiple rows into single output

We can use this function to combine multiple rows into single one. Generally to create comma separated list for each unique item. So this can create comma separated product list for any given category. The same can be used to make a list of items in a given order.ThanksMohit Nayyarhttp://mohitnayyar.blogspot.com/

5 (3)

2007-09-14

3,597 reads

To Get Latest SQL Job Status

This query will give you the current job status of all scheduled jobs on sql server. Just by using sysJobs, and sysJobHistory table you will get to know the details about the last status of the scheduled jobs, irrespective of their status like failed, successful, or cancelled.Note: You must have admin right on MSDB database […]

3.54 (13)

2003-09-04

7,138 reads

Blogs

Cloud Computing: Myths, Mysteries, Vampires & Vultures - a free seminar to help you learn more about "the cloud".

By

To be honest you probably think that migrating to the cloud sounds great, and...

DBCC CHECKDB – Msg 7928, Level 16, State 1, Line 3 The database snapshot for online checks could not be created.

By

Do you execute DBCC CHECKDB on your Azure SQL Database? From past experience I...

Introducing Data Céilí Dublin 2020 – Ireland’s newest Data Platform event

By

Today we have launched Data Céilí Dublin 2020, Ireland’s free, community led, Microsoft Data...

Read the latest Blogs

Forums

Import Export Wizard error "Too many fields defined"

By DBA_007

Hello All, Iam receiving the below error while exporting data from a database(xyz table)...

Delete Please

By kewlrobd

Delete Please

Backing up a database named update

By kewlrobd

I have what I think is a unique situation.  I recently deployed an application...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers