Viewing 15 posts - 2,101 through 2,115 (of 6,105 total)
If you can take the database offline, you can do this: Detach it from SQL Server using sp_detach_db, copy it over, and then reattach it using sp_attach_db (you'll probably want...
June 12, 2006 at 5:37 am
It depends on what you're trying to do. A small SQLExpress box only the one user touches... you probably won't see any noticeable performance gains using stored procedures. And if...
June 12, 2006 at 5:33 am
The only catch with XP is usually with the firewall. If everything you're doing is local to the server (you're not going to connect to the SQL Server install from...
June 12, 2006 at 5:21 am
We are looking into it, but thus far haven't attempted it. I'd be interested in any comments on the subject as well.
June 12, 2006 at 5:17 am
The undocumented stored procedure xp_servicecontrol only runs local to the SQL Server. By executing it against the remote procedure you could determine if SQL Server was up, but only if...
June 12, 2006 at 5:16 am
Scripts like these can often be found in the Microsoft TechNet Script Repository. This should work for you:
This gets back a list of...
June 12, 2006 at 5:04 am
I have GSX server 3.1; my first attempt to build the cluster ended in a complete fiasco: both the quorum and shared data disks got trashed when I tried to...
June 9, 2006 at 6:56 am
The heartbeat only verifies that the SQL Server can be connected to. It doesn't handle keeping local groups in sync. Nothing is responsible for doing so within the operating system.
On...
June 9, 2006 at 6:53 am
The Network Service account is supposed to run with less privileges than System on the local server. However, when it has to go across the network, it effectively does as...
June 9, 2006 at 6:49 am
The Access version used in that article was Access 2000. When setting up a new connection via the DSN is when you get that dialog box (provided the connection doesn't...
May 31, 2006 at 8:14 am
*waps himself for not reading closer*
You said you are set up for Mixed Mode. If you recently changed the setting, the SQL Server will need to be restarted for the...
May 31, 2006 at 6:54 am
In Windows NT/2000/XP/2003, when a user logs on, a security token is generated for the user. This contains the information on the user's security group memberships. This token is only...
May 31, 2006 at 6:50 am
You should still be able to connect to the SQL Server using that setup if you've made successful connections to SQL Server 7.0 and 2000 servers. One of the things...
May 30, 2006 at 3:37 pm
Key escrow is a problem, like you describe. If you create the database master key it can handle the key escrow for you, however, there is the security trade-off you've...
May 30, 2006 at 3:34 pm
A few of us help out QAing the Questions of the Day when we can. Lately I've been slammed at work and home so I haven't been able to. It...
May 30, 2006 at 3:31 pm
Viewing 15 posts - 2,101 through 2,115 (of 6,105 total)