Satya, unfortunately the install package is customized in such way, that at the end it revokes access for builtinadministrators. That is, because...
I wouldn't consider this to be a security flaw, because if I alredy have access to the server console and are logged on with local and domain...
A SQL Server instance has been installed by script (afaik an MSI package with a response file).<br />After installation, no one can access the SQL...
I have a similar, but different situation here:<br /><br />A SQL Server instance has been installed by script (afaik an MSI package with a response...
Hi out there. <img src='/community/emoticons/emotion-1.gif' alt=':-)' /><br /><br />As I am trying to get a bit more into T-SQL I'm coming across...
Thanks. <img src='/community/emoticons/emotion-1.gif' alt=':-)' /><br /><br />Seems like I'll use/suggest solely the 'used disk space approch'.
Ah, this sounds like a good idea. I'll enable the logs immediately. <img src='/community/emoticons/emotion-1.gif' alt=':-)' />
As far as I understood it always works that way unless in the database options AutoShrink is enabled. This keeps the server from always de- an...
Well, it will not be me who writes the bills. [<img src='/community/emoticons/emotion-2.gif' alt=':D' />] The definitive charges will be set by the...
Uh, isn't this dangerous? I know from DB/2 that they have things like 'on delete cascade' and though I don't know it I'd guess that SQL Server has...
Oh, sorry, your second post wasn't there when I started typing mine.
I must admit that I don't know - but I'd try to set the owner of the master db to SA and then try again.
@derrickleggett: <br />Yes, you're right. <img src='/community/emoticons/emotion-1.gif' alt=':)' /> I didn't mean to be impolite. Instead of that I...
quote:Originally posted by Flipperaus I have an app (DIY Intranet Application) that when it installs creates the DB's on C:PrgFilesSQLserver.......
Hello DBAs! <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />We're running two nodes in a Microsoft Cluster/SQL Server Cluster...
Oh yes, I did - I quickly learned that Frank's links are always worth reading. <img src='/community/emoticons/emotion-1.gif' alt=':-)' /> And...
quote:Originally posted by ranjitjain Read about MODIFY DATABASE from BOL. Very easy command to use to move db from one location to other I tried...
But all of the fields in the 'general' tab can be edited, so they do not give you reliable information. I have one of such jobs, too. Actually, there...
Hi THIRUVENGADAM,<br /><br />I do sth similar once in a while. Though the file paths are different at least my usernames are mostly the same. I...
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by...
Separate names with a comma.
