Hola, tengo este archivo .sql que lo abro desde el sql query analizer, para luego ejecutarlo... es de un laboratorio de practicas que me pasaron.
el archivo contiene lo siguiente...
********************************
restore database doctors
from disk='C:\Documents and Settings\aldo\Mis documentos\aldo\MaqAldo\aldo\cursos\asp.NET\0 Guia de instalacion\labSetup\RestoreDB\doctors.bak'
with recovery,
move 'doctors' to 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\Data\doctors.mdf',
move 'doctors_log' to 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\Data\doctors.ldf'
GO
restore database dentists
from disk='C:\Documents and Settings\aldo\Mis documentos\aldo\MaqAldo\aldo\cursos\asp.NET\0 Guia de instalacion\labSetup\RestoreDB\dentists.bak'
with recovery,
move 'dentists_data' to 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\Data\dentists.mdf',
move 'dentists_log' to 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\Data\dentists.ldf'
GO
restore database Coho
from disk='C:\Documents and Settings\aldo\Mis documentos\aldo\MaqAldo\aldo\cursos\asp.NET\0 Guia de instalacion\labSetup\RestoreDB\coho.bak'
with recovery,
move 'coho_data' to 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\Data\coho.mdf',
move 'coho_log' to 'C:\Archivos de programa\Microsoft SQL Server\MSSQL\Data\coho.ldf'
GO
---Configure Doctors
USE doctors
GO
DECLARE @s varchar(50)
SELECT @s = @@servername + '\ASPNET'
EXECUTE sp_grantlogin @s
EXECUTE sp_grantdbaccess @s, 'webuser'
GO
GRANT EXECUTE ON [getUniqueCities] TO webuser
GRANT EXECUTE ON [getDrSpecialty] TO webuser
GO
GRANT SELECT ON [specialties] TO webuser
GRANT SELECT ON [doctors] TO webuser
GRANT SELECT ON [drspecialties] TO webuser
GO
--Now do the same for Dentists
USE Dentists
GO
DECLARE @s varchar(50)
SELECT @s = @@servername + '\ASPNET'
EXECUTE sp_grantlogin @s
EXECUTE sp_grantdbaccess @s, 'webuser'
GO
GRANT EXECUTE ON [DentistsByPostalCode] TO webuser
GO
GRANT SELECT ON [Dentists] TO webuser
GO
---Configure Coho---------------
USE Coho
GO
DECLARE @s varchar(50)
SELECT @s = @@servername + '\ASPNET'
EXECUTE sp_grantlogin @s
EXECUTE sp_grantdbaccess @s, 'webuser'
GO
GRANT EXECUTE ON [EmployeeAdd] TO webuser
GRANT EXECUTE ON [EmployeeLogin] TO webuser
GO
---For the Demos-------
USE Northwind
GO
DECLARE @s varchar(50)
SELECT @s = @@servername + '\ASPNET'
EXECUTE sp_grantlogin @s
EXECUTE sp_grantdbaccess @s, 'webuser'
GRANT EXECUTE ON [Sales by Year] TO webuser
GRANT EXECUTE ON [Ten Most Expensive Products] TO webuser
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON [Customers] TO webuser
GRANT SELECT, INSERT, UPDATE, DELETE ON [Orders] TO webuser
GRANT SELECT, INSERT, UPDATE, DELETE ON [Products] TO webuser
GO
-------more demos-------------
USE Pubs
GO
DECLARE @s varchar(50)
SELECT @s = @@servername + '\ASPNET'
EXECUTE sp_grantlogin @s
EXECUTE sp_grantdbaccess @s, 'webuser'
GO
GRANT SELECT, INSERT, UPDATE, DELETE ON [authors] TO webuser
GRANT SELECT, INSERT, UPDATE, DELETE ON [titles] TO webuser
GRANT SELECT, INSERT, UPDATE, DELETE ON [publishers] TO webuser
GRANT SELECT, INSERT, UPDATE, DELETE ON [stores] TO webuser
GO
********************************
Esto me tira los siguientes errores y no se porque...
este es uno...
Server: Msg 3101, Level 16, State 1, Line 2
Exclusive access could not be obtained because the database is in use.
este es otro...
Server: Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.
y este es otro...
Server: Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 41
Windows NT user or group 'OSTEL-ALDO\ASPNET' not found. Check the name again.
Alguien me puede ayudar...
solo quiero instalar estas bases para poder hacer ejercicios de asp.net que estoy estudiando...
gracias
Aldo
Crear cuenta