She's not there

ANSI_NULLS

Usage of Null

Change the Settings of a Database Object Using Powershell

This post tells you how to change the QUOTED_IDENTIFIER and ANSI_NULLS settings of a database objects using Powershell.

Get Your ANSI_NULLs Settings Consistent

William Talada brings us a short article to help you check your ANSI NULL settings and gives you a few reasons why you might want to make them consistent.

RE: Do I still need Business Objects??

Here is one way for users to use Analysis Services. If you want to dispense with Business Objects you'll need to look at Micorsoft Reporting Services in conjunction with Analyis Services. Business Objects and Crystal Reports are doing some merging of the two products so you'll need to look at the recommended upgrade path for […]

RE: Getting MAX value

primary key, you have? Important it is! Without, leads to the dark side. Yoda will assume it is called "ID" for his example ... more meaningful, Yoda hopes yours is! hmm? Consider: UDPDATE TABLE YOurTable SET GL_Control = (SELECT COUNT(*) FROM YourTable B WHERE B.Fiscal_Year = YOurTable.fiscal_year and B.Fiscal_Period = YOurTable.fiscal_period and B.ID <= YourTable […]

RE: Changing the CREATE PROC basic template

Thanks Peter!  This is just the lead I was looking for.

RE: Stored Procedure Use Results from another?

Just to add to Allan, you can nest stored procedures up to 32 levels.

RE: "Disappearing" Table. Why?

I posted a reply last week, am sure I saw it here for a while but now gone.  From quick google search I believe this behavior is MDAC dependent, so only safe way to proceed would probably be something like this "if @@transcount > 0 commit" whenever you make modifications w/in OpenRowSet.  It bothers me […]