I have a stored proc to do that but how does it get executed as and when there is a new database?

It is checked in both servers.

can we create a group in sql server like windows?

Actually i am looking for a simple method to give read access to a group of users by default on a server to all databases. I know if i can...

Peters i has the same issue and looking for a solution. I restored another msdb database of matching collation and deleted everything in there and trying to move all jobs...

all pkgs are saved in msdb and i am looking for an easy way to move them to another server.

I am trying to alter "msdb" database but i dont think it will allow to do for system databases and so how would i restore msdb with differnt collation?

How can i use different collation while restoring a database?

How would be the performance if i do ROW and PAGE compression both on a database including indexes, is it preferable?

Here is my understanding, though i do PAGE compression it...

Looks like it didnt backup the empty space of around 200gb but when i restored again oin different server even the empty space was restored. So i am shrinking on...

I want to use compression on the whole database, which one would be better ROW or PAGE compression?

How about this..

DECLARE @rowcount int

SET @rowcount = 100000

SET rowcount 100000

WHILE @rowcount >0

BEGIN

BEGIN TRAN

Update dbo.Employee set jobcode = 1 Where jobcode <> 1

SET @rowcount = @@rowcount

...

could you help me to update in batches please.

I see the problem now, there is no check for already updated rows in the loop and so it is an indefinite loop.

so how would i check the updated rows...

revno column has unique records (28) in OBBEAVER.USPA_check.dbo.RevID

fixpaid column in dbo.Adm_History2 has all "0" as of now.

could you tell how would i update them in batches without having indefinite...