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 ...

also keep in mind a "drop column xyz" is only a catalog operation !

That columns space will only get reclaimed after maintenance or reindex.

and you'll need to convert your date to month-name-part ...

Apparently it returns the data in the same order as the in-list

Select *

from (

Select P.name, TH.Quantity, convert(char(3), TransactionDate, 100) as TrxMonth...

That is a mail server issue .... contact your mail admins.

They may help you figure...

You are correct !!

Apparently it doesn't store the UserName, but the its internal identifier 'S-1-9-3-3482764364-1226597329-2493949361-1082924894'.

I wonder why they would do that !!

They should have documented this behaviour.

In my test...