Recent content by MikeWiz9

You can do this by fully qualifying the query. eg. SELECT * FROM Database1.owner.tableA A INNER JOIN Database2.owner.tableB B ON A.field1 = B.field2

Add to the where clause, AND o.xtype = 'u' So it should look like this... SELECT u.Name as "User", o.Name as "Object " FROM sysobjects o JOIN sysusers u ON u.uid = o.uid WHERE u.Name = 'dbo' AND o.xtype = 'u'

We're a third party and they give us read/write access. We gave their DBA scripts to create the databases for us. I'm pretty confident it is not our application since we have it installed at other clients and this is the first this has ever happened. Hopefully we will be able to track down how...

Any recommendations of applications for viewing transaction log files?

I have seen the records in the SQL Server database table via enterprise manager, so I know they are making it to the server. One of the ways I'm trying to "monitor" the situation is creating triggers on each table any time a record is deleted and put that into a temporary table. I also have...

I have an application using an Access front end with a SQL server 2000 backend. Just recently we noticed that some records are mysteriously disappearing from SQL Server. The records are entered through Access via ADO calls. The records are in the SQL database, but then minutes or hours later...