Issue time05:01:00 pm, by tom.green Email 25750 views
Categories: Errors, SQL Server
Problem When running some transactions on a database the following error appears: Msg 9002, Level 17, State 4, Line 2 The transaction log for database 'Database_Name' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_… more »

Leave a comment
Issue time05:32:00 pm, by tom.green Email 23656 views
Categories: SSIS, Security, Errors
  Connecting to a Remote Integration Services Server   When attempting to connect to a SQL 2005 Integration Services machine with a user account that is not an windows administrator on the machine running the SSIS services, you receive the following… more »

3 comments
Issue time12:50:00 pm, by tom.green Email 12146 views
Categories: SQL Server, SSRS, Errors
  When trying to create an assembly, the following error can appear: USE [DBA] GO /****** Object:  SqlAssembly [ASSEMBLY_Name]    Script Date: 10/20/2012 15:16:08 ******/ CREATE ASSEMBLY [ASSEMBLY_Name] AUTHORIZATION [dbo] FROM 0x4D5EA90000300000… more »

3 comments
Issue time12:07:00 pm, by tom.green Email 8000 views
Categories: Performance & Tunning, Indexes, SQL Server
Problem Displaying the Estimated Execution Plan of a query takes a long time to complete.   Solution Although, the query is pretty complex, displaying the execution plan should not take more than few seconds. In my case it took over 20 minutes to h… more »

Leave a comment
Issue time05:01:00 pm, by tom.green Email 20227 views
Categories: Errors, Server Configuration
Problem When trying to import a SQL Server 2000 DTS package to SQL Server 2008 R2 the following error occurs:       Managing DTS packages in SQL Server Management Studio requires the SQL Server 2000 Data Transformation Services (DTS) runtime.… more »

7 comments
August 2017
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

Search

Email Subscription

Enter your email address:

Translate

Advertising











XML Feeds

DBA Blog

Latest posts

SSAS More...
SSRS More...
Server Configuration More...
SQL Server More...
SSIS More...
Server Configuration More...
Errors More...

Poll

Which database platform do you use?

View Results

Powered by b2evolution