This one may work better

sp_MSforeachdb

' select ''?''

select name from master.dbo.syslogins

where SID =

(Select SID from ?.dbo.sysusers

where name = ''DBO'')'

The difference is in ?.dbo before sysusers. I did not...

Hi,

I am supposed to escalate all issues through our Premier Support point-of-contact unless I am submitting the issue as an individual, not as a company employee. I may do...

Hi,

here is a possible script for the owner list. You may query the last backup from MSDB, I have to go now, email me tomorrow I will send you. Pay...

Hi,

2005 BOL says:

To execute CREATE INDEX, at a minimum, ALTER permission on the table or view is required. This permission is granted by default to the sysadmin fixed server role...

Chris,

Submitted those findings to both our Microsoft Premier Support and Application Vendor

If he needs to create tables one at a time, not a butch of 100 (see my previous post for a butch) then could he just create a table, stuff it...

Hi RS,

I talked to my friend the Notes developer and she told me that first, there is another way to connect to Notes database using ODBC, you will need to...

Did not get it. Does it mean sqlquery would like 2 same columns created each time he creates a table and all other columns are different and depend on particular...

Rick,

he may be trying to attach to the network drive, see my reply above, we posted our replies at the same time - Yelena

Hi,

Is your E: drive a network or local drive? If it is a network drive then with one of the following errors

Hi,

I will try to ask tomorrow, she already went home and I don't have notes Designer SW.

Yelena

Chris,

Hope your presentation is successful. I will wait then till you let me know if June cTP fixed the issue and if not then I will report it.

Yelena

Here is the advice from Lotus Notes developer:

Use Notes designer to write code that is very similar to VB code. You can easily output any or all of the Notes...

Chris,

Thanks a lot for your research. Actually, my 6.5 compat level database is a vendor-supported database, I will notify them to. Will let you know more later. I have a...

Or in the Enterprise Manager right-click on Pubs database All Tasks -> Restore Database -> And replace the database name in the box "Restore Database As" with your new name....