This procedure will give the list of columns included in the primary key for a given table of given database on given server.
For. e.g.
Get_PrimaryKey 'vrs-118','Demo_StDB','IMAGEREPOSITORY'
2001-08-22
729 reads
Get Primary Key columns of given MSSQL table
CREATE PROCEDURE Get_PrimaryKey
@ServerName varchar(50),
@CatalogName varchar(50),
@TableName varchar(50)
AS
EXEC sp_serveroption @ServerName, 'data access', 'true'
select
COLUMN_NAME = COLUMN_NAME
from master.dbo.SYSREMOTE_PRIMARY_KEYS ( @ServerName,@CatalogName, N'dbo',@TableName )
EXEC sp_serveroption @ServerName, 'data access', 'false'
GO Related content
2001-08-22
383 reads
hx_ShowFixedDriveSpace
Very simple, how much space is free on the hard drives of the SQL Server you are connected to.
2001-08-22
669 reads
hx_OLEDBproviders
Get OLE Providers info I have found this useful in tracking down application driver/connection issues. I only had to use it 2 times. But it did help
2001-08-22
415 reads
2001-08-22
712 reads