exec sp_msforeachdb 'use [?]

if db_name() not in (''tempdb'')

begin

alter database <> set read_only

end'

however, there should be no active connections.

Cheers

Jannie

Hi

Just a hint, if you are doing backup monitoring instead of using output from funny programs and try to format them.

Checkout msdb

backupset

backupmedia

backupmediafamily

Even if you use 3rd party apps, these...

Well you need need to find out if you replication agent is delivering (running) on a sunday?

Replication use jobs to kickoff the exes that run replication. So technically you need...

ahem.

How do you reply to a thread with 23 thousand replies?

Is there any more value to be added in this thread?

Cheers

Jannie

Hi

If you just want a subset of columns from the order table you can simple open the article and go in and untick the columns you don't want.

Just keep in...

The CHARINDEX and PATINDEX functions return the starting position of a pattern you specify. PATINDEX can use wildcard characters, but CHARINDEX cannot.

From BOL

Just on the filegroup side of things.

If you have a single LUN sitting behind e:\ then filegroups will not give you more throughput, except!

If you pump vast amounts of data...

Just while you are on this.

Did you do your partition alignment on formatting the new drives?

If you didn't or don't know what I'm talking about checkout the Jimmy May Disk...

Replication didn't work,

Can you give more detail on what didn't work.

I have used mirroring and replication and there is a few things to look out for.

When the mirror is broken...

6 disks phew.

Interesting that the size of your database never came up, also what is you workload.

It might not be entirely SAN or extreme material but you can do your...

Hi

You should refrain from you that type of code as it's print to sql injection.

Rather using something like sp_executesql and variables.

You will also get better performance by using parameters...

Hi

You can look at joining sys.partitions to sys.allocation_units.

Once you have that done you can just sum that data pages.

that will give you the physical size.

If you want the number of...

ok

well there are only 2 agents of major concern

1 - log reader, if this don't run log run out of space etc or people get grumpy cause they don't get...

Hi

What are you trying to acheive ?

Cheers

Jannie

Hi

Just remeber that blocking is a symptom , you can either find some code that is not optimal or that the server don't have resources.

Also make sure that your indexing...