Rename Rule in SQL 2000

Hi,
Is ther any method to rename Existing Rule name in SQL Server 2000
ThanksJaved
> Is ther any method to rename Existing Rule name in SQL Server 2000
To rename a rule, use sp_rename
"Javed Iqbal" <JavedIqbal@.discussions.microsoft.com> wrote in message
news:A9C406BD-DF2F-4D3E-8362-12BD1C2AC624@.microsoft.com...
> Hi,
> Is ther any method to rename Existing Rule name in SQL Server 2000
> Thanks
>

Rename Rule in SQL 2000

Hi,
Is ther any method to rename Existing Rule name in SQL Server 2000
Thanks
Javed
> Is ther any method to rename Existing Rule name in SQL Server 2000
To rename a rule, use sp_rename
"Javed Iqbal" <JavedIqbal@.discussions.microsoft.com> wrote in message
news:A9C406BD-DF2F-4D3E-8362-12BD1C2AC624@.microsoft.com...
> Hi,
> Is ther any method to rename Existing Rule name in SQL Server 2000
> Thanks
>
sql

Rename Files using sql/t-sql

Is it posssible to rename files using SQL/T-SQL? One method could be the xp_cmdshell command but I want to rename files on the netowrk and xp_cmdshell commands do not support UNC paths.
Any ideas?
ThanksOriginally posted by vmlal
Is it posssible to rename files using SQL/T-SQL? One method could be the xp_cmdshell command but I want to rename files on the netowrk and xp_cmdshell commands do not support UNC paths.

Any ideas?

Thanks

This works fine:

xp_cmdshell 'copy \\server1\backup\backup.sql \\server1\backup\backup2.sql'

xp_cmdshell 'copy \\server1\backup\backup.sql \\server2\backup\backup2.sql'|||you can create a bat file on your local machine in which you can enter all your commands. You can then execute this with the xp_cmdshell.