Viewing 15 posts - 3,001 through 3,015 (of 3,233 total)
Is 'NewProspectJoJo' your spreadsheet name? Does 'E:\WUTemp\NewProspectJoJo.fmt' exist? Does the SQL Server service account have access to E:\WUTemp? It sounds to me like the format file does not exist (just...
March 8, 2006 at 3:06 pm
It depends on what an Application DBA is. I would guess that the Application DBA is a development DBA? If this is true, then here are a few possible differences (depending...
March 2, 2006 at 4:13 pm
Use SQL Profiler and capture the Security Audit>>Audit Login Failed event. You should be able to capture the login that is failing. You can then at least see if it...
March 2, 2006 at 3:55 pm
It sounds like you want to implement your own locking control. There are a couple of ways to do so. First, you could wrap your stored procedure up in a...
February 28, 2006 at 12:26 pm
First of all, you need to make sure you have SQL Server running on your workstation. Open up your services window in control panel. Look for MSSQLServer. If it exists...
February 27, 2006 at 10:35 am
Just double-click on the Maintenance plan in the Database Maintenance Plans window and you will be able to edit the activities that that plan will perform. Doing this will automatically...
February 24, 2006 at 11:05 am
Using the Database maintenance plan wizard is an effective way to schedule backups.
1. If you create the job using the DB Mainenance plan wizard, make changes to the job using...
February 24, 2006 at 10:52 am
We are using Windows 2000 Advanced Server. I just read a kbase from Microsoft stating that the 3GB switch will only work for SQL Server 2000 Enterprise or Developers edition. We...
February 21, 2006 at 1:55 pm
AWE is required for memory above 4GB. You do not need it unless you plan on using more than 4GB.
February 21, 2006 at 1:48 pm
Logically partitioning the mirrored pair will not get you the benefits you are looking for. The only way to better the performance of SQL Server through the disk subsystem is...
February 17, 2006 at 4:48 pm
When you say the database is locked by its user database, what does that mean? Doesn't it give you a user name? Do you recognize the host name?
Right-click on...
February 17, 2006 at 4:24 pm
Use EM to find out who is connected to that database. I imagine it is your EM session. Shut down your EM and try the QA command again.
February 17, 2006 at 4:01 pm
Using QA:
USE Master
sp_dboption '<your DB name>', 'SINGLE_USER', false
February 17, 2006 at 3:35 pm
SQL Server 2000 does not include triggers in any of it's INFORMATION_SCHEMA's. Try using the system tables:
select * from sysobjects where type = 'TR'
February 17, 2006 at 11:16 am
Viewing 15 posts - 3,001 through 3,015 (of 3,233 total)