kandevs (6/12/2009)

---

Hi Dugi,

Thanks for your response.

These are the tables:

table customers has two columns:

CREATE TABLE [dbo].[customer](

[ocustomernr] [int] NOT NULL,

[onaam] [varchar](100) COLLATE Latin1_General_CI_AS NULL,

CONSTRAINT [PK_customer] PRIMARY KEY CLUSTERED

(

[ocustomernr] ASC

)WITH (PAD_INDEX...

Try this:

CREATE TRIGGER TEST

ON CUSTOMER

AFTER INSERT

AS

INSERT INTO articles

SELECT OCUSTOMERNR, 0 FROM INSERTED

Post the structure of your table, just in case and to write the trigger properly!

Don't forget some sample data!

:hehe::hehe::hehe:

wow what a chines DB creation ...and the problem is !? :w00t::hehe::w00t:

You can start from here >>>> http://www.jumpstarttv.com/clustering-sql-server-2005_33.aspx

This article is from Jumpstar TV, the author is Brian Knight ( SQL SErver MVP)

:hehe:

Yea, very nice article! It is in my briefcase now! Thank you for sharing! 😉

thepotplants (6/3/2009)

---

Oracle length() function will count the number of chaarcters in a field.

select id, name, length(name) from SAPR3.test_table

[font="Courier New"]ID NAME LENGTH(NAME) ...

Lynn Pettis (5/28/2009)

---

The two biggest things I like about using CTE's (they were introduce in SQL Server 2005) are:

1) It makes the query itself cleaner. You define what...

izhar (5/29/2009)

---

Try:

SELECT

30.AString

,50.E-3AnotherString

,10.E0SomethingElse

into dbo.TempTable;

select * from dbo.TempTable;

You can see that SQL try to parse the number till the not numeric character and then...

...are you working for http://www.wolframalpha.com/ !!!

Try this:

http://www.sqlservercentral.com/Forums/FindPost721992.aspx

or try to use the code:

USE MSDB;

GO

DECLARE @DeleteBeforeDate DateTime

SELECT @DeleteBeforeDate = DATEADD(d,-30, GETDATE())

EXEC sysmail_delete_mailitems_sp @sent_before = @DeleteBeforeDate

EXEC sysmail_delete_log_sp @logged_before = @DeleteBeforeDate

You can use the system sp for this...search in BOL for these sp:

sysmail_delete_mailitems_sp and

sysmail_delete_log_sp

and I'm sure...

In the Server properties - Connections you should put 0 and it means unlimited connections in Server!

Check it!

After changes you should restart your SQL services!

Let me know is everything...

S Hodkinson (5/22/2009)

---

I have read and re-read BOL regarding setting up database mail for SQL Server 2005 but I cannot get the darned thing to work. I must be...