Tag: SQL Server

SQL to add an incrementing counter in results

One thing I alwys forget how to do is to add a sequential number to a query output in SQL.  Using the rank function you can get this.  A  query such as   select rank() OVER (ORDER BY accountid) as xrank, account, accountid from account Will return the accountid and a sequential number based on […]

How to fix the inability to open/view a SSIS package in BIDS

 I recently ran into an issue with a SQL server installation at a client where I tried to open a SSIS package using the BIDS interface but would receive an error upon the package loading that said: Microsoft visual studio is unable to load this document.  To design Integration Services packages in Business Intelligence Development […]

Sysdba fix script for SalesLogix database restores

When restoring a SalesLogix SQL database backup from one server to another, you must synchronize the database’s sysdba user to the new SQL server’s sysdba user.  This can be done using a SQL stored procedure.  SalesLogix provides this procedure under their database folder on the install DVD.   Inevitably I find I need this T-SQL […]

Editing tables in SQL 2008

I recently ran into an issue when trying to edit a SalesLogix table in the SQL Management Studio 2008. I was trying to increase the length of a field while in a table’s design mode. When I went to save my change I received this error: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Pr...

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) news and product updates!

You have Successfully Subscribed!