1. database diagrams install on db that was restored from SQL7
2. restore a SQL7 user DB to a SQL2k DB
hi; need to backup a user db in SQL 7 (Win2K Adv Svr) and then restore it bck to SQL2000 Std Ver ( W2k Server). How best to go abt doing it ? DB size is abt 1GB. need to bring over the Master also ?? Tks
3. Collation Changed after restore SQL7 DB into SQL2000 DB - SQL Server
4. FIX: Blank Database Diagram in SQL Server Enterprise Manager after VS6 SP6
I have had this problem for a while now, after installing SP6 and ADO2.8 on a WinXP machine. SQL Server's Enterprise Manager showed all Diagrams as blank, even if when I opened them from another PC they appeared OK. The fix is: Locate MDT2DF.DLL (default location= C:\Program Files\Common Files\Microsoft Shared\MSDesigners98). The SP6 version is 2.0.0.9586. This is the DLL that causes the problem. Find the same DLL from another PC with SP5 or extract it from the SP5 archives and check the version. It should be 2.0.0.8958 Now rename the SP6 version as MDT2DF.DLL.OLD and copy the SP5 version into the MSDesigners98 directory. I can't tell for certain (I did it anyway) but you may need to re-register it with: regsvr32 "C:\Program Files\Common Files\Microsoft Shared\MSDesigners98\MDT2df.dll" Open EM and your Diagrams now work correctly. MS->Please release a hotfix ASAP on this!!!
5. from db diagram to db creation - SQL Server
6. Copy a diagram from a db to another db in sql server 2005
Hello, is there a way in SQL Server 2005 to copy a diagram from a database to another one that has exactly the same structure? Thank you in advance, Laura
7. restore a SQL2000 db to a SQL7.0 server
8. SQL7: Access to another db without permission?
Hi, My problem in MS SQL 7.0: User 'John' has access to the database 'Articles' and has all permissions (select; update; insert; delete) to the defined tables within this database. Now in 1 table 'Article' I have a list of articles. The ID (identity increment) of a record occurs in another database 'Orders' where user 'Jane' has access too it with all permissions (select; update; insert; delete) to the defined tables (e.g. Orders.dbo.Orderline). In the Articles.dbo.Article table I created a delete trigger which will check of the ID (Articles.dbo.Article.ID) of the current (deleted) record occurs in Orders.dbo.Orderline. If so a rollback will take place. But, an error occurs because user 'John' who has access to database Articles has no access to database Orders (only user 'Jane'), so my delete trigger won't work. I know that there is a way around to give John access to the Orders database and give SELECT permission to the 'Orderline' table. But this is not what I want, user 'John' must not have the oppertunity to take a look into another database. Is there a solution for my problem (with exception of the use of a 'guest' account)? Thanks in advance. B.M.