sqlclrstoredproc.sql

< SQL Server2005程序设计>

CREATE DATABASE Test
GO
USE Test
GO
CREATE TABLE TestTable (TestColumn INT)
GO
USE Master
GO
CREATE LOGIN [sahil] WITH PASSWORD=N'sahil', DEFAULT_DATABASE=[TEST], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE Test
GO
CREATE USER [sahil] FOR LOGIN [sahil]
GO
ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [sahil]
GO