What is the type of your SQL Server? Only the Enerprise version allows the use of partinioned views.

Also did you implement the check constraint on the partitioning column on each...

Here is what you want:

select convert(varchar, convert(datetime, '26/08/2003', 103), 1)

select convert(varchar, convert(datetime, '26/08/2003', 103), 1) + ' 10:00'

Bye

Gabor

Hi Nicolas,

What I would do is generate the DDL script with EM including create database.

That one you can run on the client server.

After you can BCP out all the data...

the xplog70.dll is also responsible for the xp_cmdshell

Did you check the cpu and the physical_io columns in the sysprocess table?

Also did you check if you have enough memory to handle SQLServer as well as the OS (and...

Frank,

You may have a German keyboard!

On a "normal" keyboard STRG calls CTRL

(Control anstatt Steuerung)

Or you do not have to put any NT shares on the machine, no "active work" on it (i.e. it should not work as a workstation) and of cours heavy...

And for the transaction logs (which is at least one er database) the best was is detach the DB move your files whereever you want and after attach it again.

It...

But Frank,

THIS IS A PRODUCTIVE DATABASE WHERE OVER 1000 PEOPLE ARE CONNECTED TO!!!

I won't play with rebuilding the master database within my maintenance windows.

It's is just too risky to do...

I'm not really proud of that solution because I don't like cursors but at least it works .

Here is an example based on the pubs database:

declare@t_au_ord table...

Frank,

What do you meen by estimating the db size?

Size of the existing or a planned db?

Because (and of cours you now it) you can use sp_spaceused, hp_helpdb,...

What about Log Explorer for SQL Server from Lumigent? www.lumigent.com.

They are doing selective data recovery as well.

But I don't know how much it will cost.

Gabor

Of cours I did.

See my previous notes.

sp_fixindex is doing dbcc dbreindex for all objects where object_id > 100 and dbcc dbrepair for all objects where object_id < 100.

And there I...

I think I will use C for this time. I just hate mixing up development languages.

The app. will run each morning in the login script each file has between 20...

So guys (special thanks to Frank and Tom),

It seems there is no real answer.

By the way Frank ich habe dein Mail erhalten. Danke)

The story concerning sp_fixindex...