[MS SQL Server] Policy Based Management - Naming Convention for Indexes after Create Date |
- Policy Based Management - Naming Convention for Indexes after Create Date
- Access a Postgre SQL DB from SQL 2008
- Ask Question to Vendor?
| Policy Based Management - Naming Convention for Indexes after Create Date Posted: 10 Oct 2013 02:34 AM PDT HI there,I've been trying to figure out a custom way to Evaluate a policy naming convention for indexes, however I would like it to run only against indexes created let's say after 10/1/2013.I have the Naming convention working for every index.Condition must start with usp_However, how can I get it to run only against indexes created after 10/1/2013?I tried setting the following but does not work.Facet: IndexExpression:Field = ExecuteSql('Numeric', 'Set NOCOUNT ON; select crdatefrom sysindexes i join sysobjects o ON o.id = i.id')Operator: >=Value: ExecuteSql('Numeric', 'Set NOCOUNT ON; Set NOCOUNT ON; Declare @CreateDate datetime set @CreateDate=''10/01/2013'' Select @CreateDate')Any suggestions or ideas? Everything is possible. :) |
| Access a Postgre SQL DB from SQL 2008 Posted: 10 Oct 2013 02:00 AM PDT Hi,we have an internal SQL 2008 Server and a remote Postgre SQL Server and want to import data from Postgre to MSSQL. We made tests with Excel and an OLEDB driver and it was succesful, so we do not have any firewall problems.Then I tried to create a linked server in MSSQL, entered name and host, changed the remote login to a specific user, but it failed. The error message said the the Postgre SQL server could not be reached at port 5432, the standard port. Thats correct... because I need to use a different port 5504 to connect through the remote Firewall.How can I change the used port to my special port?Any help is very much appreciated!RegardsOliver |
| Posted: 09 Oct 2013 09:48 PM PDT Hi.what are the points need to ask vendor for database and DBA related points?1. Database design and performance?2. Database administration & different type of documents from vendor?rgdsananda |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment