rbs_sp_register_column (Remote BLOB Store)
The procedure registers a user table and column with the server. A registered column is a user application column that the remote BLOB store server uses to reference user application IDs.
Syntax
rbs_sp_register_column [ [ @schema_name = ] schema_name]
[ , [ @table_name = ] table_name]
[ , [ @column_name] column_name]
Arguments
[ @schema_name = ] schema_name
sysname of the schema that the user database is a member of.[ @table_name = ] table_name
sysname of the table the column is in.[ @column_name = ] column_name
sysname of the column to be registered.
Return Code Values
Returns 0.
Permissions
Requires membership in the sysadmin and serveradmin fixed server roles.
Examples
This example creates a user database and a table, and then registers the ID column with the remote BLOB store server.
USE RemoteBlobStore
GO
CREATE TABLE dbo.ApplicationBlobTable (
localId int,
BlobId varbinary(64)
)
GO
-- Register the table's columns in different ways.
EXEC mssqlrbs.rbs_sp_register_column dbo, ApplicationBlobTable, BlobId
GO