Viewing 15 posts - 2,371 through 2,385 (of 2,453 total)
Use DB2 or other DBMS (Yukon) that supports TIME as a datatype.
August 6, 2004 at 9:21 am
You should be able to get SQL started.
However, I would start to build this environment incrementally. Start with a unclustered server at your primary and secondary, and debug all...
August 6, 2004 at 9:17 am
When SQL Server wants to expand any file, log or database, the operation can fail if the increment size is smaller than the space SQL needs to complete the active...
July 26, 2004 at 4:26 am
You should remove the -T3608 parameter when you are finished moving the system databases. You will have to restart SQL after removing the parameter, as it affects the way SQL...
July 19, 2004 at 1:28 am
You should move Master via the SQL startup parameters. Never try to detach Master, because if somehow it does succeed you will never get it back.
TempDB should only be moved...
July 15, 2004 at 9:40 am
It is not SQL that is taking the lock, it is the tape backup process.
If the success of tape backups is not properly checked, a failed backup may not get detected...
July 9, 2004 at 8:19 am
I have recently tried defragging a W2003 test server running SQL2K SP3a, while SQL was active and using the defrag tool supplied with W2003.
It worked.
Even so, I would not want...
June 30, 2004 at 7:00 am
Jeff,
The key to this has already been posted. The ability to stop/start SQL Agent has nothing whatsoever to do with internal SQL Server authorities. It is purely a NT...
June 29, 2004 at 7:50 am
My experience of Windows Defrag is that it needs the same amount of free space as the largest fragmented file if that file is to be defragmented.
You get a warning...
June 28, 2004 at 2:30 am
If your clients are on a WAN, ensure that the port used by the named instance is not blocked by firewalls. Firewall blocking may not inhibit registration, but it would...
June 24, 2004 at 3:13 am
Are there any cirsumstances where 2 GUIDS could be created with the same value?
If one of the factors in GUID creation is time, then the granularity of the time factor...
June 24, 2004 at 3:04 am
There is a problem on SQL2000 SP3 documented in KB815115 A DTS Package That Uses Global Variables Ignores Error Message Raised by RAISERROR. A fix is available on...
June 18, 2004 at 3:30 am
If you are talking about how to prevent SQL System Administrators from access databases, you can NOT do this. Some other DBMSs allow access by system admins to be prevented,...
June 7, 2004 at 6:02 am
I will have a go at some of the questions...
a) You should always go for a 3NF design at the logical design stage. Until you have a 3NF design, you...
May 13, 2004 at 4:28 am
Viewing 15 posts - 2,371 through 2,385 (of 2,453 total)