Try this one :

select sys.schemas.name 'Schema'

, sys.objects.name Object

, sys.database_principals.name username

, sys.database_permissions.type permissions_type

, sys.database_permissions.permission_name

, sys.database_permissions.state permission_state

, sys.database_permissions.state_desc

, ...

If this is a free mobile application, creating a replication per user is not viable.

How many tables do you have to sync ?

How many data ?

A quick search...

Nice.

Easy to use and query much more readable !

IF @offline = 'Y'

BEGIN

EXECUTE sp_dboption 'Test','offline','true'

END

You found your reason !

log_reuse_wait = 5 ; DATABASE_MIRRORING

Database mirroring is paused, or under high-performance mode, the mirror database is significantly behind the principal database (full recovery model only).

For...

or one of the cause listed here :

Factors That Can Delay Log Truncation

http://msdn.microsoft.com/en-us/library/ms345414.aspx

Hi

It should be something like this :

select

substring(pagename, 1,charindex('/',pagename)-1) as sitename, -- or LEFT(pagename, charindex('/',pagename)-1)

count(*) as cachecount

from systempagecache

group by substring((pagename), 1,charindex('/',pagename)-1)

order by count(*) desc

If not, please post your...

Kwisatz78 (1/13/2012)

---

Hi there thanks for the replies. My linked server is setup such that my account is linked to a remote user that has access to the database in...

Are we talking about a Reporting Services report ?

What is the fill_factor of your index ?

See this post : http://www.sqlservercentral.com/Forums/Topic230400-5-1.aspx

- your primary key hasn't to be your clustered index

- only one clustered index per table.

In your Job step definition, what database is set up ? MyDb ?

If not, can you modify it and try again.

Indexation has to be improved :

- No primary key on your table

- An index has to be added on createdDateTS + [DimCustomerKey] + Type (maybe it is your primary key...

Can you post your table definition (create table, indexes, ???).

Thanks

You have to...