I totally agree with Brian and dcpeterson. There should be an individual login for each user. It is like a private property.

Fred, if you work for ASP with many customers, why would not...

Oh yes,

You are sure right. I did have a recollection that db_dlladmin creates objects as dbo, checked it out, no, sysadmin membership. oops... My login has implicit sysadmin membership, yes....

Linda,

I am sure it could be a workaround.

I have a test database owned by someuser (someuser is a local server login). Then I added my Windows Domain login to this database users and made her db_ddladmin....

My manual says:

A relation is in 4NF if it is in BCNF and

has no multi-valued dependencies.

Khalid,

I would assume that you need to go to Tools->Macro->Visual Basic Editor

You can use VBA from there. In VBA you may use ADO or something to connect to SQL Server....

Dorothy,

Please post any error messages including relevant error messages in all 3 logs: application, security and system.

If it does not help then use .NET ability to create logs /post errors...

Jeff

select CAST(@@servername as varchar(20))

Yelena

I think # 4 may be vulnerable too if you pass 'syslogins' or 'master.dbo.syslogins' or sysusers as a first parameter, 'name' as a second and 'sa' or 'admin' as a third.  Use your...

Thanks to all. I will check Ebay.

You may also send me a private message here if you think you have extra books that you think are really good.

Yelena

There is a bigger "theoretical" problem. Most of the developers and sysadmins who may even have a decent T-SQL or Network knowledge confuse Enterprise Manager with SQL Server. In approximatly...

Brian, Frank - I do have a hobby of reading theoretical books not only on databases. It is just not my idea of fun  spending $93.78 at 10% saving for...

Hi,

do this in Query Analyzer and post here both result sets.

If you are not comfortable posting company data then send me a message by clicking on the link with my...

Phill,

Did you mean a link SMTP Task from the main page of your reference or did you mean to follow XP link and download XPSMTP.DLL ? Looks like useful thing.

About...

Hi,

You have to make sure what you would like: to make logins same as users in the database or make users same as logins.

What we usually do is to...

Hi,

Join the club!  Some time ago I had to work with the database where the name contained  a -

I had to enclose the name in [ ] all the...