Viewing 15 posts - 16 through 30 (of 30 total)
Well, the entire point is that we're trying to automate this by scripting it or doing it in installshield, so having the customer manually restore the backup isn't really an...
October 4, 2011 at 9:00 am
I am spoiled by the same thing, which is why I'm having such trouble here.
Okay, I did your test, and you were right. Adding Everyone Full Control to the...
October 3, 2011 at 4:17 pm
It is intended as just being allowed to attach a database does not always give you the right to change its schema.
Okay, but allowing for that use case shouldn't disallow...
October 3, 2011 at 3:52 pm
weird posting glitch/double-post. Deleted.
October 3, 2011 at 3:49 pm
This has nothing to do with installing or upgrading SQL Servers. It's our application.
Right now our application basically requires the sa user/password to install and upgrade. Mostly because...
October 3, 2011 at 3:46 pm
Well, in this case, we're trying to help out DBAs! 🙂
DBAs don't like having to have the "sa" password handed out in order to do upgrades and installs. Now,...
October 3, 2011 at 3:10 pm
If I look at the database properties after the CREATE DATABASE FOR ATTACH, the "Owner" is listed as the login that ran the CREATE DATABASE FOR ATTACH. However, that...
October 3, 2011 at 3:04 pm
I don't think I'm confusing the two. I just don't see ANY utility in a login being able to create databases (and be the "owner" according to the properties)...
October 3, 2011 at 2:48 pm
I did not revoke any permissions. There is no user. There is only a login. And this login has been granted the CREATE DATABASE permission.
This...
October 3, 2011 at 1:55 pm
Is RoleID a bitmask? Or do higher numbered roles always include all lower-numbered roles?
Because you could just change the SUM to MAX in the latter case. It would...
October 3, 2011 at 1:52 pm
That seems to be referring to physical NTFS file security. I'm just refering to getting a login that has created a database for attach, to be able to be...
October 3, 2011 at 1:44 pm
I had worse issues when I tried to run the SQL through OSQL.EXE ... it seemed to like to (almost randomly) truncate strings to be even smaller.
I ended up writing...
July 29, 2009 at 8:23 am
I can and will try that... but there are 760 format files, and one upgrade package is supposed to run against either SQL Server 2000 or 2005.
It would be nice...
December 4, 2006 at 5:18 pm
Well, I THOUGHT it was working. Now it's not working again. I swear I had it working briefly.
The problem is that when I do the:
BCP database.dbo.tablename format nul ...
December 4, 2006 at 4:55 pm
I think I found the source of my confusion, and it does seem to be working now. I was expecting the actual format of the bcp format file to change,...
December 4, 2006 at 12:53 pm
Viewing 15 posts - 16 through 30 (of 30 total)