S4fGEMj7

1USE [Distrib-PLZ74]
2GO
3IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'UIProperties' AND type = 'U ')
4    CREATE TABLE UIProperties(id INT)
5
6IF EXISTS (SELECT * FROM ::fn_listextendedproperty('SnapshotFolder', 'user','dbo', 'table', 'UIProperties', null, null))
7    EXEC sp_updateextendedproperty
8        N'SnapshotFolder', 
9        N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\ReplData', 
10        'user', 
11        dbo, 
12        'table',
13        'UIProperties'
14ELSE
15    EXEC sp_addextendedproperty 
16        N'SnapshotFolder', 
17        N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\ReplData', 
18        'user', 
19        dbo, 
20        'table',
21        'UIProperties'
22GO