ok now i discussed with my provider, they did not grant me owner rights, now i have owner rights. but it did not solve the problem, i watched while installing the scripts on the database and i could see that the installation is stopping after creating the table version and three stored procedures for "Version".
now i know i have owner rights, the database was cleaned (no old stuff in it) and the webconfig was perfectly new (i copied it again after every try). so it would be interesting which script is starting after the version-script und what it needs that my provider cannot give by now.
thank you for your response,
greetings sabine
here are the three stored procedures which were installed and after them it stopped:
create procedure dbo.FindDatabaseVersion
@Major int,
@Minor int,
@Build int
as
select 1
from Version
where Major = @Major
and Minor = @Minor
and Build = @Build
create procedure dbo.GetDatabaseVersion
as
select Major,
Minor,
Build
from Version
where VersionId = ( select max(VersionId) from Version )
create procedure dbo.UpdateDatabaseVersion
@Major int,
@Minor int,
@Build int
as
insert into Version (
Major,
Minor,
Build,
CreatedDate
)
values (
@Major,
@Minor,
@Build,
getdate()
)