Aleksandar Tosic's Blog

Msg 14650, Level 16, State 1, Procedure sp_send_dbmail, Line 68

Thu, 23 Oct 2008 14:29:56 GMT

Msg 14650, Level 16, State 1, Procedure sp_send_dbmail, Line 68 Service Broker message delivery is not enabled in this database. Use the ALTER DATABASE statement to enable Service Broker message delivery

Out of memory error when try to preview report

Wed, 15 Oct 2008 10:40:08 GMT

These are good links when getting error "Out of memory" when running report in Reporting Service 2005.

http://msdn2.microsoft.com/en-us/library/ms156002.aspx

http://blogs.msdn.com/lukaszp/archive/2007/01/31/how-to-diagnose-issues-when-running-reports-in-the-report-server.aspx

Truncating a data file

Wed, 15 Oct 2008 10:40:08 GMT

Truncating a data file

The following example truncates the primary data file in the AdventureWorks database. The sys.database_files catalog view is queried to obtain the file_id of the data file.

http://msdn2.microsoft.com/en-us/library/ms189493.aspx

USE AdventureWorks;
GO
SELECT file_id, name
FROM sys.database_files;
GO
DBCC SHRINKFILE (1, TRUNCATEONLY);

How to empty a database file - Emptying a file

Wed, 15 Oct 2008 10:40:08 GMT

Emptying a file

The following example demonstrates the procedure for emptying a file so that it can be removed from the database. For the purposes of this example, a data file is first created and it is assumed that the file contains data.

http://msdn2.microsoft.com/en-us/library/ms189493.aspx

USE AdventureWorks;
GO
-- Create a data file and assume it contains data.
ALTER DATABASE AdventureWorks
ADD FILE (
    NAME = Test1data,
    FILENAME = 'C:\t1data.ndf',
    SIZE = 5MB
    );
GO
-- Empty the data file.
DBCC SHRINKFILE ('Test1data', EMPTYFILE);
GO
-- Remove the data file from the database.
ALTER DATABASE AdventureWorks
REMOVE FILE Test1data;
GO

SQL Server 2005 Service Pack 1

Wed, 15 Oct 2008 10:40:08 GMT

To download SQL Server 2005 Service Pack 1 visit: http://www.microsoft.com/downloads/details.aspx?familyid=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en

SQL Server 2005 Service Pack 2

Wed, 15 Oct 2008 10:40:08 GMT

To download SQL Server 2005 Service Pack 2 visit: http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en

Microsoft SQL Server 2005 Downloads

Wed, 15 Oct 2008 10:40:08 GMT

To download SQL Server 2005 service packs, tools, trial software visit: http://technet.microsoft.com/en-us/sqlserver/bb331754.aspx