Any help will very appreciated

thank

Hello,

thank for any suggestions.

All people like you make things....

So you mean that using standard ed. I cannot create pertitioned table or index using:

Create Partition and Create Function?

Is it right

There is another way?

Sorry...

there is a mistake.

Point 2, says:

2) I have to explain how to create a backup job (people that does not know anything about SQL)

Also, I add

There are tools like osql and...

Yes you'll be right...scheduling a backup job is very easy.

But (there is always a reason):

1) I am not in charge to create backup on several sql servers (on site and remote)

2) I...

Thank,

I'll follow your directions.

Let me try

I do not if SQL server is 2K or 2K5; in the case of 2K it is not possible use WITH EXECUTE AS, only in 2k5.

I do not the level...

If you want to avoid using DTS or SSIS you can run SQL command inside .net application, using for instance:

osql.exe or isql.exe utilities (SQL 2K, these are utilities to be executed...

Thank a lot

To do it,

You should use a DTS pakage (SQL 2000) or SSIS (SQL 2K5) to perform this operation without writing to much rows of code.

Then, the package can be called...

Thank,

useful suggestions

sorry:

when is written:

but someone says that the right one is: yyyy-dd-mm.

the right one is: yyyy-mm-dd

Thank

Thank for your usefull informations.

I'll install both on the same machine, SQL Server 2000 is always SP4.

thank

resolved:

installing visual studio 2005 and if templte are not present, from vs2005 command: devenv /installvstemplates.

then every was ok.