Viewing 15 posts - 61 through 75 (of 90 total)
Try this...
CREATE
PROCEDURE dbo.usp_dropOldBackups
(
@prmLife INT = 0 -- number of days after which device gets dropped
)
AS
May 18, 2006 at 12:49 pm
Just as you did with the system db's. RESTORE ... WITH MOVE...
You may place the user database files wherever the new server configuration allows.
May 18, 2006 at 11:57 am
BTW, it is a good idea to qualify objects with the owner name and even the db name (e.g. myDB.thatUser.objectA) - less work for the server (trying to find which...
May 18, 2006 at 10:25 am
From BOL (note text in red):
Changes the owner of an object in the current database.
sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'
[@objname =]...
May 18, 2006 at 10:14 am
Have you checked to verify the key exists? That error indicates a key (a.k.a. file) is not present.
May 18, 2006 at 10:02 am
Another (documented) option & rather fast...
DBCC
SHOWCONTIG WITH TABLERESULTS
May 18, 2006 at 9:46 am
As Philip said, that is perfectly normal under the following conditions:
1. Memory allocation is not constrained by the SQL Server Configuration Option: Max Server Memory
2. Applications, if running on the...
May 18, 2006 at 8:23 am
Have you tried the same in SQL2K? It doesn't work for me... Check BOL for "converting data types, precedence". You will see that DATETIME is of higher precedence than *CHAR()...
May 18, 2006 at 6:37 am
EM doesn't typically refresh. Manually refreshing the current view is a habit to which one should become addicted.
May 17, 2006 at 1:06 pm
Is there any possibility that they were inadvertently set to read-only (NTFS attribs not SQL)? That would be the only reason I can think that the installer couldn't overwrite them.
May 17, 2006 at 12:23 pm
Simple questions do not always result in simple answers...
1) Logins, not users, have passwords. Logins allow access to the server not to individual db's. Access to db's is via users within...
May 17, 2006 at 11:56 am
Try moving the master, model, msdb and tempdb files in the D:\Data directory to a 'holding' directory. If overwriting is the issue you will soon know.
If you need the data in...
May 17, 2006 at 8:23 am
One thing to keep in mind... test your recovery plan! In my experience, agent-mediated SQL Server to tape backups are prone to failure. Even apparently successful backups will fail to restore. ...
May 17, 2006 at 8:17 am
Yes, keep an eye on your log file...
May 12, 2006 at 10:42 am
The statuses shown in BOL are bit patterns. So a db with status 24 is one with Torn Page (16) and Trunc Log (8).
The use of bit patterns in status columns applies...
May 12, 2006 at 10:37 am
Viewing 15 posts - 61 through 75 (of 90 total)