Viewing 15 posts - 1,336 through 1,350 (of 2,387 total)
If you are running SQL Server 2000, change it after the restoration using alter database command with modify file option.
You can't do it in 7.0
August 11, 2003 at 9:22 am
http://www.datadirect-technologies.com/products/odbc/matrix/connectodbc.htm
http://www.hitsw.com/products_services/index.html
Is there unique key column on the target tables?
August 8, 2003 at 10:32 pm
Run sp_spaceused @updateusage = true and go back to EM, you will see the changes.
August 8, 2003 at 10:07 pm
Check the restore database command with 'move' option and sp_attach_db in BOL.
Edited by - allen_cui on 08/08/2003 9:59:21 PM
August 8, 2003 at 9:56 pm
It looks to me the problem may come from the driver you used to setup ODBC/OLE DB connection to AS/400.
Can you make select with openquery successfully? Could you provide more...
August 8, 2003 at 9:50 pm
See http://support.microsoft.com/default.aspx?scid=kb;en-us;280106 may help you.
August 8, 2003 at 9:44 pm
You need to review the application to see whether it refers objects with owner name. If it does, you will have problem after changing the owner to dbo without modifying...
August 8, 2003 at 9:39 pm
Someone has similar problem. See http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=15034&FORUM_ID=110&CAT_ID=1&Topic_Title=sysperfinfo&Forum_Title=SQL+Server+Agent
August 8, 2003 at 9:29 pm
It could be network issue according to the error message "Operating system error 64(The specified network name is no longer available.)" or could also be the administrative share G$ disappeared....
August 8, 2003 at 9:27 pm
quote:
Anyway, the MS SQL Server i was using was version 7. Do I need to install MS DTC on our server?
August 7, 2003 at 8:29 pm
quote:
1.) For memory setting, should I select "Dynamically configure SQL memory" or "Use a fixed memory size(MB)" ?
August 7, 2003 at 8:23 pm
See http://support.microsoft.com/default.aspx?scid=kb;en-us;314546
You may transfer the logins from the source server to the destination server or drop the user from database you restored and the grant database access again.
August 7, 2003 at 2:41 pm
Use DBCC OPENTRAN to determine whether an open transaction exists within the log. When using the BACKUP LOG statement, only the inactive portion of the log can be truncated; an...
August 7, 2003 at 2:17 pm
Viewing 15 posts - 1,336 through 1,350 (of 2,387 total)