Viewing 5 posts - 1 through 5 (of 5 total)
Found this procedure on the try and let us know if it helped :
--1. Create Database
USE master
GO
CREATE DATABASE mydatabase
ON PRIMARY ( NAME = mydatabase_data,FILENAME = 'c:\mydatabase.mdf',SIZE = 2MB,MAXSIZE = 10,FILEGROWTH...
July 7, 2005 at 7:17 am
Try to figure read might help
http://www.sqlservercentral.com/columnists/ckempster/deattachandreattachdatabases.asp
July 7, 2005 at 6:42 am
In SQL Query Analyser type :
EXEC xp_logininfo 'DomainName\GroupName', 'members'
In vbscript :
Download ADSI scriptomatic from microsoft and ... well some work to do
Marc
March 1, 2005 at 6:54 am
SMO is replacing SQL WMI if I read this correctly.
Will the actual sql 2k wmi ( x86\other\wmi\setup ) still work on this new release ?
February 17, 2005 at 6:14 am
Found the solution to my problem thought I'd share
' MyDB is the target DB
objRoleName = "My_role_MyDB_r" ' Role defined in MyDB
ObjUserName = "NewUser" ...
February 14, 2005 at 9:27 am
Viewing 5 posts - 1 through 5 (of 5 total)