i was looking at system table sysperfinfo column 'active transaction'.

can this be used?

on server A setup replication so that it has multiple subscribers. Meaning the publishing articles will have servers B,C and D subscribing to it.

depends on what replication Model you use, there are different setups, you can have 1, 2 or 3 servers handling the process.

an ideal setup to avoid possible bottleneck on your...

Not possible with that secondary server since it's in a standby mode. Log shipping is a backup and restore operation.

Why not just replicate from your primary server, set up a...

ok thx,

I'm thinking abt installing a second SQL instance on the cluster and migrating those databases to this new instance .

I want to setup this instance in a way...

Ok, thanks guys appreciate the inputs

Also isn't the database master key a symmetric key?

could you explain the process of doing that?

Also isn't the database master key a symmetric key?

thanks

should have known that.

i thought there were some built in sql functions i could use for this

ok thx

thx appreciate it

already know what the query looks like, i used the ----- to shorten the thread. it's obviously a problem where the ISNULL section is probly i'm missing a qoute or...

Yes, i want to apply Build 3152

sorry for not being so clear, i want a script that will dynamically select database in which other scripts will execute.

i wanted this in order to exec DBCC scripts for...

Appreciate it, thx for ur inputs