Hello,

Are you able to do anything else in the database? Like delete or insert in any table? Are you working on the server or you are connecting from the workstation?...

It is OK.

I work with several industry leaders in CRM (Customer Relationship Management systems) and they do not use referential integrity ability of the database to make their products database...

Hi,

You can you MMC as Carl says if it is not adding a context-aware button or menu item but having Windows Explorer in the same view as EM. See today's...

Or you may create your Management Console

Start -> Run -> mmc /a

File - Add/Remove Snap /In   (or Actions Add/Remove Snap-in depends on OC version)

Add

Select SQL Server Enterprise Manager. Add

Select...

I was interesed in the similar task as to how to add fuctionality to Windows Explorer: menu or buttons. I think that it was Steve Jones who recommended Shell Extensions....

Hello,

Your English is very good for someone who does not use it as a first language. And your idea is a good idea too. Yes, I think it is good to have one...

I agree with Rudy. I think SP is OK. Just remember to backup your Master database before you modify it in any way to a file that will not be...

Hello,

When you say No backups did you mean No SQL Backups or No Windows Backups or both? If the server had Windows backups and SQL Server was stopped during one...

I would not put things in Master for the following reasons:

1. You don't want accidentally corrupt it - things happen.

2. Suppose you want a copy of you admin environment on...

Hi,

There was a concept about 5 years ago promoted through the Microsoft seminars to use multiple databases for the application. I am not sure if the concept is still has...

Hi,

Found my records! One of the cases did happen after SP3 install! Here are my records from Jan. 2003:

"..... <user name> had trouble starting SQL Server Agent on <server name> since he...

Hi,

I had similar problem once long time ago. It was related to the services startup sequence. I am not even sure now what version it was: 2000 or 7.0 The problem...

After you have the files out of the database you may want to run a command-line tool from the WINZIP website to zip those files

http://www.winzip.com/downcl.htm

Yelena

You may run a script as a job that will check what stored procedures in sysobjects were created during last 24 hours, check if a permission is granted to your...

Chris,

Please, remove Guest from db_owner in Master. I am not confortable with that. I would just give Select on all objects in Master to this user account.Then completely disconnect or...