Viewing 15 posts - 4,156 through 4,170 (of 6,105 total)
xp_cmdshell will allow you execute the command-line net user. However, this isn't too advisable. We parse users and groups and group memberships nightly using Perl scripts and store the resulting...
July 14, 2003 at 6:40 am
Master must have the guest user, so by default all users have access to it. Same is true of msdb. The guest account in master is required.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start...
July 12, 2003 at 4:47 pm
Check Andy Warren's articles about moving databases. To get the entire contents of a database, the easiest solution is probably detach/reattach, which he covers. This also gets your roles for...
July 11, 2003 at 9:05 pm
If you just mean manually grabbing a file and running it: File | Open.
Then F5 to run what is displayed.
Otherwise you'll have to go to the command line like the...
July 11, 2003 at 9:01 pm
See the replies in:
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
July 11, 2003 at 8:58 pm
If you are opposed to letting SQL Server handle this, don't do the max() technique, mainly because of the performance issues as Frank has measured.
Antares' control table solution has only...
July 11, 2003 at 8:55 pm
Typically the primary key also is the clustered index. If you use an identity, prepare for a page splits hotspot, subsequent fragmentation, and the performance decreases from them. These aren't...
July 11, 2003 at 8:49 pm
It's probably easier to bring the entire group offline and then bring it online after the reboot.
The cluster service is just that, a service. It's typically set to start up...
July 11, 2003 at 8:45 pm
Both are set to mixed mode, right?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
July 11, 2003 at 3:24 pm
A network trace would be real handy right now... Are you or do you have anyone capable of sorting through one? Is Network Monitor set up on the server in...
July 11, 2003 at 1:02 pm
No, it's not SPIDA. Had it been, he wouldn't have been able to log on as SA from another system, which he was able to do. Spida changes the password...
July 11, 2003 at 1:00 pm
Extremely odd. Not sure why it's forcing you to Windows authentication regardless. That doesn't make a whole lot of sense.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance...
July 11, 2003 at 12:51 pm
Okay, if you've got other SQL Server logins connecting successfully, have you verified the sa password? For instance, can you terminal into the server and login? You'll avoid IPSec or...
July 11, 2003 at 12:41 pm
What version and service pack for SQL Server?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
July 11, 2003 at 12:36 pm
This might be of some help:
http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritysecurityadmins.asp
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
July 11, 2003 at 12:35 pm
Viewing 15 posts - 4,156 through 4,170 (of 6,105 total)