Ok, do you have a database ( ABC ) with tables a,b,c,d,e,f,g,h.

User1 needs access to a,b,c

user2 needs access to a,b,c,d,e,f

user3 needs access to d,e,f

etc.....

so create a database role.  ( from object...

Assuming that all of your stored procedures and changes are already in some type of version control system.....they should already be in seperate files.

Write up a script that loops...

You know, if we dont allow the English language to grow and change....we would end up like........the French.....LOL

EP

Lucky

Yes, that was exactly what I was looking for. 

Just didnt see it between the Turkish and Estonian entries.  On an interesting side note, my Irish co-workers are quite offended that it...

I ran into the same error in SQL Server Management Studio when a database owner's login was dropped.  Becaue it was not finding the property that it expected ( ie the...

Also, just in case the job is not scheduled, but run on a regular basis, I would recommend the following change to the script.

left join sysschedules

I made a few...

it is because the history lists a status for each step in the job.

Add a where clause " Where step_id = 0" and you will get the results your looking...

Thanks

The reboot of the service or the server is what I am trying to avoid.    lol

Looks like I am going to have a window this weekend as my systems group...

I have had the same issue, old machines ( and my SAN machines only have a small C drive )

Also, not only does the SQL Server install the code on the...

It will also depend on if you are using IP address for your link server.  Note all other machines Host files will need to be updated to the new address...

A pro opinion for shrinking:  Your backups will run faster.

A con opinion:  If the database will grow again, and entering data to your online system is causing the growth, some...

ids can be transfered between machines using the following script

http://support.microsoft.com/kb/246133

Also if using Log Shipping or Mirroring for your backups, it saves lots of security issues having all of...

Hello

OK, the above script will work.....but things must be done in the following order

1. load the login script, run and extract the existing userids
2. run the add login scripts on the new...

I dont know if this will work, but worth a few minutes of research.

What about setting up an ODBC driver and map it to the Oracle Instance.  Then use sp_linkserver...

Thanks for the info and it is good to know that I am not the only one having the problems. 

I read on one of the other forums that SQL...