You are doing everything correctly. You linked her local login to her remote login. It will work if she logs in to server 1 as her local login. But she...

I think he is asking not about the log file, but about a database files shrinking after deleting data from the database. You can not shrink the data ase below...

David,

It is the only possible answer anyway, see the explanation. You are in the same position when you have to troubleshoot remote users problems. You have no way to know if...

Hi,

I am not getting what is it about 2 servers. Do you have a second server linked? Did you configure linked server logins correctly? Who is the DBO on...

I just looked up the original request and it says that there are 3000 users. I agree with the previous statement of IloveSQL that with this number of users who...

Here is a simple 2 step solution for SQL Logins.

More complex is 1 step cursor solution that I don't publish here.

STEP 1

Import your Active Directory names into any database into any...

Hi all.

How many of you actually removed Builtin/Administrators or removed system admin rights from this group? If you did not, they (them, network admins) have administrative rights anyway and...

Had a script question, but found an answer myself, so I am editing my post.

YV

SQLBill,

XP SP3 or SP2 ?

Yelena

Hello,

Yes, you do need to know this stuff. It is not clear what exam you are talking about. 70-228 is Admin exam and 70-229 is Design exam. But it is...

Just wanted to add: 70-228 may be comlemented next year with the next version of the exam. I still advise to read everything that is mentioned above because basics will not...

44% of all selected answer D) All Of Above. Why? there was 2 opposite answers: that "You cannot edit a replicated column." and "Alter a column." Both could not be...

Hi,

I recommend also to read Part 2 Installation and Setup of Microsoft SQL Server Administrator's Companion. This Part 2 has an excellent description of RAIDS, disks and installation planning for...

Rhett,

You did a good job. Now when your problem is resolved you may want to look back and find out why this happened and how to prevent it. Especially you...

Arthur,

The requirement "It has to "support integrity in multi-user environment with concurrent user access to data".  " is more like a Business Requirement. Next step according to "Analyzing Requirements and Defining...