Simple mistake if you look closely at this line

RETURNS numeric(9) AS

The problem is you define no scale and thus 0 is used.

When this happens it will round to whole...

You poor man. Sleepless nights, worrying about who may need to be repremanded, the code snippets floating in your head.

Gotta say I just hit the 9 month mark and anyone...

See the SET ANSI_WARNINGS item in SQL BOL

Here is an example I setup with northwind

file x.xml as defined

<?xml version ='1.0'?>

<document xmlns:sql='urn:schemas-microsoft-com:xml-sql' sql:xsl='x.xsl'>

 <sql:header>

     <sql:param name="CustomerID">ANATR</sql:param>

 </sql:header>

 <sql:query>

  SELECT * FROM (Select TOP 100 PERCENT CustomerID, Count(OrderID) OrderCount

  From dbo.Orders

  Where CustomerID...

1) Is 3rd normal form a good goal to shoot for when designing a DB?  Or, is that probably "too normalized" in practice because it's probably "asking for trouble" later...

First when it is timing out have you tested QA at that moment?

If so what was the outcome?

altering and bouncing seem to fix temporarily so I believe the answer lies...

Can you post your query (edit security items to another name if needs be). May be a logic issue that throws it like this that someone can help with. Either...

Was this DB restored from another server in any manner?

If so look at

sp_change_users_login

in BOL and that should help with the UPDATE_ONE action.

If you are going to install SQL 2K on a system that has had SQL 7 installed you might as well use the upgrade method (IMHO). If you are hoping...

Try this then:

SELECT datepart(mm,cast(replace(birth_date,substring(birth_date,4,charindex(' ',birth_date) - 4) + ' ',' ') as smalldatetime))

It will make sure the month portion is 3 characters only which SQL Server reconizes the following

Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec

for English...

All but the system databases (master, msdb, distribution, and model (model may be fine but I don't recall for sure)) can be done that way. I have done the upgrade...

It will depend on your setup but if you are the default setup for the English version then this should do the trick.

SELECT datepart(mm,cast(replace(birth_date,'.','') as smalldatetime))

Note: 'dec 12,2004' is understood...

Even if he weren't using the SA account without a password as long as he has any account that is potentailly exposed via that ini file that has more than...

You mean you haven't already been doing that?

Just kidding!

But however the dtproperties table is listed as Type system in EM as well as sysjobs in msdb (which also shows as a system table in color in QA). The...