Re: DBA dissappointed in sql server 2005

From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 20:42:11 +0100

2) In Enterprise Manager, open the properties for the login and check "Deny
Access". Or use sp_denylogin. That's for NT logins only though. For SQL
logins things are indeed less simple, although if you have your users in
roles, you can simply remove the user from the role temporarily.

3 & 4) If you organise your users in roles, you won't have that issue. You
only have to make sure that the roles exists on both databases. Or you can
just choose not to copy object-level permissions (disable "Use default
option" in the DTS Export Wizard and click the "Options..." button.

5) See the topics "Multiserver administration" and "Automating
administrative tasks" in Books Online.

Btw, about 1: why do you need compressed backups? Tape drives have built-in
compression and if you back up to disk you can back up to a compressed
folder under most circumstances. 

-- 
Jacco Schalkwijk
SQL Server MVP
"Charles Pritt" <CharlesPritt@discussions.microsoft.com> wrote in message
news:56F4AFBA-6A89-4FF1-99A1-35358C02A57A@microsoft.com...
> Please explain how number 2) already exist in current product.
>
> For number 3 and 4) if you are referring to having the dts wizard export
> an
> object and then selecting a specific table, I have not been able in the
> last
> 4 years to get this to work reliably. Mainly because there will always be
> some user that has access to that object on the source side that doesn't
> exist on the destination side and it fials because the specific users does
> not exists on the destination. Also, I did not see the option to move a
> "object" in the 2005 export wizard.
>
> for number 5) if you are referring to having to register each individual
> sql
> server and then clicking on each of the 75 sql servers one at a time and
> then
> going down to mangement and then sql server agent and then jobs looking at
> the list and then going to the next sql server agent and clicking on it
> and
> then going to management. and so on.... I agree with you ... they have it.
> that is the way i do it now. I am referring to clicking on a icon that
> says
> sql server and then clicking on a icon that says jobs and it list every
> sql
> server and every job and its status. two clicks. a couple minutes to see
> all
> jobs.
>
> no i have not been dissappointed in sql server 2000, it is a far cry from
> sql server 6.5 and sql server 7.0 but there are still things lacking. This
> is
> my job. it all i do everyday, 7 days a week. manage more than 75 sql
> server,
> jobs, users, backups, and quite a few sql server clusters. I'm just
> looking
> for some improvement in the day to day task I perform.
>
> "Jacco Schalkwijk" wrote:
>
>> You must have been disappointed in SQL Server 2000 as well then. 2, 3, 4
>> and
>> 5 are already available in SQL Server 2000.
>>
>> -- 
>> Jacco Schalkwijk
>> SQL Server MVP
>>
>>
>> "Charles Pritt" <Charles Pritt@discussions.microsoft.com> wrote in
>> message
>> news:0255B038-53EE-43C9-A64E-BEB4D45EAFE0@microsoft.com...
>> > I've been looking at the beta2 release of yukon and I am beginning to
>> > be
>> > dissappointed in the product from a DBA viewpoint. I realize that a lot
>> > of
>> > improvements have been made in the programmers side of things, but I
>> > still
>> > have to manage the sql servers and I do not see any improvements in my
>> > day
>> > to
>> > day, week to week regular management task I have to perform. For
>> > instance:
>> >
>> > 1.) i do not see any option to tell a backup to compress the backup
>> > file
>> > as
>> > it backsup a database. this would be a highly desired feature.
>> >
>> > 2.) there is no way to temporarily disable logins without changing the
>> > persons password which is not desired.
>> >
>> > 3.) using dts to export a table from a "development" database to a
>> > "testing"
>> > or "production" database will only move the table definition and data,
>> > but
>> > not the underlying indexes or constraints.
>> >
>> > 4.) using dts to export a view will only create a table on the
>> > recieving
>> > end, not a view.
>> >
>> > 5.) I have 75 seperate sql server boxes, some with multiple instance,
>> > all
>> > with many many databases and scores of jobs. I need something that can
>> > show
>> > me easily the status of all jobs across all the servers without
>> > manually
>> > connecting to each individual sql server instance and then expanding
>> > down
>> > to
>> > jobs. I want to select jobs and all jobs across all instance are shown
>> > sorted
>> > by whatever I choose. Same way i want to select current processes and
>> > see
>> > the
>> > same things.
>> >
>> > the list goes on....
>> >
>> > mayby others can enlighten me and point out some real benefits in the
>> > new
>> > sql server from a dba point of view.
>>
>>
>>