All you need is exchange server and valid MAPI Profile. Specify the profile name under the SQL Mail -> support services and start it. And at the backup job go...

Very good article Brian, Perfect solution for the companies looking for the high security

But at the same time it is very scary if the service account is lost or...

There are so many problems with SP3a. MS is going to talk more about SP3. I would suggest wait for some more time. If you decided to install here is...

Definitely NOT. I would recommend to create more files per each group and place on the different disks (2 to 3 file on each disk), this will definitely improve the...

If it is a server fixed role you can use ‘sp_srvrolepermission’ to see the list of permissions, and for the database fixed role ‘sp_dbfixedrolepermission’. But unfortunately there is no function...

I believe they don't do the data defrayment, but if you re-organize the data you really don't have to do the data defrayment.

I usually store the result of the following query in a table.

Select name, CONVERT (VARBINARY (32), password) from master..syslogins where name in (Select name from Dbname.sysusers where uid <> 0)...

Go to the Services in the Administrative tool from the Control Panel and change the log on for the SQL Server and the executive. You must re-start the server to...

It looks like there is another active thread to this file. Make sure no one else is accessing the File exclusively. Read-Only is fine. I do see these kinda ...

I guess racosta is referring to the Database name instead of server name? Here is an Article on moving SQL to a new Server

http://www.databasejournal.com/features/mssql/article.php/1479841

You can have the job result to log in to Windows Event Log, and then write a program to notify you. There are several products outside to monitor things...

Alternatively you can use the following one to copy single DTS Pack

Go to Enterprise manager -> Data Transfermation services -> Select the package -> Open the package -> In the...

Here you Go

http://www.sqlservercentral.com/columnists/awarren/copyingdtspackagestoadifferentserver.asp

Try the Following one

ALTER TABLE [dbo].[XXX] ADD

CONSTRAINT [FK_ATC_DIM_ATC_LVL_4_CD] FOREIGN KEY REFERENCES [dbo].[RDM_ATC_LVL_4_LKUP] (

[ATC_LVL_4_CD])

Make sure your referencing column in the master table is Primary Key, same data type and the size.