Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 281
  • Last Modified:

How can change a ruler in MS SQL 2005?

Hello guys

How can I change a ruler in MS SQL 2005?

Thanks
Alexandre
0
hidrau
Asked:
hidrau
  • 2
  • 2
2 Solutions
 
hidrauAuthor Commented:
As you can see

USE [CARAJAS]
GO
CREATE RULE [dbo].[Comissao_Vendedor]
      AS @col BETWEEN 0 AND 100

I want to change it and as I could see, there isn't any to do that only drop and create again, is it?
0
 
plusone3055Commented:
http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/6b31849b-9db9-480a-8ae8-9ef4e011652b

according to the artice above

 There weren't predefined layout settings in 2005 if I recall correctly. Try changing the page size properties from inches to cm.
0
 
TempDBACommented:
Yes you need to drop and recreate it. There is no direct way of altering it. However, when you are going to drop, why not use check constraint because rule are going to be deprecated sooner.
0
 
hidrauAuthor Commented:
thanks very much
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now