LogShip between SQL 2K and SQL 2005

It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and
SQL 2005 is not possible. If any one one knows please confirm this.
Thanks,
Moh
You will get better help in the SQL Server 2005 newsgroups. Please post
your questions there:
http://www.aspfaq.com/sql2005/show.asp?id=1
On 3/23/05 7:44 PM, in article udPCjqAMFHA.3336@.TK2MSFTNGP10.phx.gbl, "Moh
Abb" <mabbas@.aligntech.com> wrote:

> It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and
> SQL 2005 is not possible. If any one one knows please confirm this.
> Thanks,
> Moh
>

LogShip between SQL 2K and SQL 2005

It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and
SQL 2005 is not possible. If any one one knows please confirm this.
Thanks,
MohYou will get better help in the SQL Server 2005 newsgroups. Please post
your questions there:
http://www.aspfaq.com/sql2005/show.asp?id=1
On 3/23/05 7:44 PM, in article udPCjqAMFHA.3336@.TK2MSFTNGP10.phx.gbl, "Moh
Abb" <mabbas@.aligntech.com> wrote:
> It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and
> SQL 2005 is not possible. If any one one knows please confirm this.
> Thanks,
> Moh
>

LogShip between SQL 2K and SQL 2005

It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and
SQL 2005 is not possible. If any one one knows please confirm this.
Thanks,
MohYou will get better help in the SQL Server 2005 newsgroups. Please post
your questions there:
http://www.aspfaq.com/sql2005/show.asp?id=1
On 3/23/05 7:44 PM, in article udPCjqAMFHA.3336@.TK2MSFTNGP10.phx.gbl, "Moh
Abb" <mabbas@.aligntech.com> wrote:

> It seems like with SQL 2005 Beta 2, setting up logship between SQL 2K and
> SQL 2005 is not possible. If any one one knows please confirm this.
> Thanks,
> Moh
>

Logins & its associated tables.

Hi All,

Does anyone knows the query/Script, which gives the list of tables the logins( SQL & Windows Authenticated) have access to.

In other words, the output should be logins and their access to respective tables.

Thanks for all your help.

Naj,

Exec sp_helprotect

Run the above statement in your database, you will see all your objects, not only tables and who has access to those objects. More info, refer Books online - search sp_helprotect

Sample output

--

Owner Object Grantee Grantor ProtectType Action Column

- - --

dbo NarasApp Naras\jay dbo Grant Select (All+New)

dbo NarasApp public dbo Grant Select (All+New)

--

Here Object column shows the name of object and Grantee column shows who has access on the object.

Thanks.

Naras.