And there are off course "cumulative hotfixes" = a set of hotfixes, but not as tested a you would expect for a service pack

If this is to figure out if a db is still being used, just alter your db option "AUTO_CLOSE" to ON.

This way, you will find a "database opened" message in...

- Read the according KB ref for the hotfix !!

- Test it on a DBA test server to prepare yourself for the production rollout (timing, expected problems,..)

- Is this a...

Your Set SQL1 is using @fiscal_month_nm in the sting itself !

That's causing the "must declare varriable" error

I'll have to check that again, but I tought that with sql2008 that limit was removed for a single OS install. (so one OS hosting n sql 2008 instances on...

your trigger will suffer the use of the inline functions in the not in lists. ( Just a gut feeling, but i assume there are queries in the functions)

If you...

Don't use "create table" in your trigger,because it will put a lock on the db system catalog !

If you need a worker object, prefer a #temp table or a @table...

Thank you very much for this valuable feedback.

So this is a windows 2008 clustering issue ... who would have come up with that ??

I think I've been lucky because my...

Indeed the first bit will take a byte, but a byte can host 7 bits (the 8-th one is used for marking another bit-hosting byte is in the row).

That's...

it can save you 3 bytes...

Here's a little test I performed:

I am logged in as dba_sysadmin, but in the script I use execute as login to change user context.

Test it;

Create login RegularSQLUser with password='sUPERSecr@'

go

USE [msdb]

GO

CREATE...

Did your mailadmins enable SMTP for your sqlserver ?

AFAIK a "regular" user just needs to be granted use of a sqlserver mail profile to be able to send mails.

So you...

Tara-1044200 (2/2/2010)

---

Here is another interesting thing... I did an export of the whole database into a new test database and the size seems to went down to 142MB

Can some one...

Tara-1044200 (2/3/2010)

---

I dont think reindexing helped me because reindex will rebuild all indexes and my database grown instead of reclaiming space back.

Only 1 solution i see getting my space back...

Your problem is that your provided string value contains a comma in stead of a decimal !

This causes your convert statement to fail !

DECLARE @str NVARCHAR(MAX)

DECLARE @amount DECIMAL(18, 2)

SELECT ...