Viewing 15 posts - 2,281 through 2,295 (of 2,387 total)
Did you create the backup jobs using maintenance wizard?
January 13, 2003 at 1:58 pm
Use maintenance wizard to generate backup job which will place the date in your database backup file name, even though it is not exactly same as your format. Or write...
January 13, 2003 at 12:03 pm
fhtapia,
How many physical disks do you have in the server?
Configure one Raid 5 and place everything into it is definitely not good. Few suggestions here.
Mirror two disks for your OS...
January 13, 2003 at 11:52 am
You may try to use the OLE Automation stored procedures to create and use an SQL-DMO SQLServer object for this kind of purpose. See BOL for details.
January 13, 2003 at 11:38 am
To modify the logical name of a data file or log file, specify in NAME the logical file name to be renamed, and specify for NEWNAME the new logical name...
January 8, 2003 at 8:15 am
Your problem may related to the permission. SHUTDOWN permissions default to members of the sysadmin and serveradmin fixed server roles. Your SQL Server Agent may stared with a account with...
January 6, 2003 at 9:35 am
Verify whether login BUILTIN\Administrators has been removed. If it does, you have to grant system account [NT Authority\System] to access your SQL Server with 'sa' righr.
December 20, 2002 at 7:35 am
Save package as structured storage file and move those .DTS files to the server and open from there.
December 19, 2002 at 2:29 pm
The problem is nothing to do with the identity or timestamp columns. In order to be able to insert/update data in table, the table must have a primary key defined.
Remeber...
December 19, 2002 at 12:20 pm
Try to change database owner to any one of logins (not sa) and change the database owner back to 'sa'.
December 19, 2002 at 8:41 am
You can turn on/off ODBC trace by changing the key in following registry HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.ini\ODBC too. See http://support.microsoft.com/?kbid=274551.
December 13, 2002 at 8:24 am
You can turn on/off ODBC trace by changing the key in following registry HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.ini\ODBC too. See http://support.microsoft.com/?kbid=274551.
December 13, 2002 at 7:23 am
Database diagrams are kept in system table 'dtproperties'. After database tables, views etc been moved into database B, you can import data from this table in database A into the...
December 12, 2002 at 12:39 pm
I have turned on the trace 1024 and 3605, If there are deadlocks occuring, the deadlock information should also be logged into the SQL Server errorlogs but I don't see...
November 15, 2002 at 11:44 am
You have alos to turn on trace flag 3605 for the locking information be logged in the SQL Server errorlog.
November 15, 2002 at 8:36 am
Viewing 15 posts - 2,281 through 2,295 (of 2,387 total)