Microsoft SQL Server Administration

Hi I am trying to configure notification emails on my sql2005 server for SQL agent job failures. I have configured a mail profile in database mail and I can send test emails which are received correctly. I have configured the notification to email me when the job completes but ...

Hello Everyone, I am having an issue that you all have probably seen all over the boards: The server network address "TCP://xxx.xxx.com:5022" can not be reached or does not exist. Check the network address name and that the ports ...

Hi, Could anyone tell me what does COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL/NULL do in the following code? CREATE TABLE [TABLE1] (     [ProjectID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ) Why do I need COLLATE? What does COLLATION mean in table creation? ...