Warning - Divide by zero error encountered in SQL Server

Read more »

Apply To :
* Microsoft SQL Server 2008 R2

Warning Message :
"Msg 8134, Level 16, State 1, Line 1. Divide by zero error encountered."

Warning Database is In Use when Restore

Read more »

Apply To :
* Microsoft SQL Server 2008 R2

Warning :

Msg 3101, Level 16, State 1, Server TEST, Line 1
Exclusive access could not be obtained because the database is in use.
Msg 3013, Level 16, State 1, Server TEST, Line 1
RESTORE DATABASE is terminating abnormally.

Warning - When Print Report Can Not Display The Webpage

Read more »

Apply In :
* Microsoft SQL Server 2000
* Microsoft Internet Explorer 6

Warning :

General Network Error in SQL Server Query Analyzer

Read more »

Apply To :
Microsoft SQL Server 2000

Rule "Microsoft.Net Application Security" Generated A Warning

Read more »

Apply To :
* Microsoft SQL Server 2008 R2
* Windows Server 2008

Case :

When running installation of Microsoft SQL Server 2008 R2,  

there is a rule warning, that generated below

Unable Connect To Server or Failed When Login for User 'sa'

Read more »

Apply To:
Microsoft SQL Server 2000

Problem: 

* Could not login to SQL Server Query Analyzer using user login SA ( or System Administrator )

* Forget the password of user login SA 

* Display warning 

Warning Must Declare The Scalar Variable

Read more »

Apply To :
Microsoft SQL Server 2008 R2

Warning: 

Must declare the scalar variable "@sql_1".

Could not Replace Space Character in SQL Server

Read more »

Apply to:
Microsoft SQL Server 2008 R2


Problem:

Could not Replace Space Character in SQL Server

Note:
Control character Value
* Tab = char(9)
* Line feed = char(10)
* Carriage return = char(13)

Warning: Could Not Find Stored Procedure

Read more »

Apply in :
Microsoft SQL Server 2008 R2

Solution:

* * * * * 

Error 1068 - The dependency service or group failed to start - When Run Manually SQL Server Agent Services

Read more »

Apply To:
* Microsoft SQL Server 2000

* * * * *

Msg 3102 - RESTORE Cannot Process Database Because It Is In Use By This Session

Read more »

Apply To :
Microsoft SQL Server 2008 R2

* * * * * 

The Backup Set On File 1 Is Valid with RESTORE VERIFYONLY Statement

Read more »

When run this query:
/*-----code:start-----*/
RESTORE VERIFYONLY FROM DISK = 'D:\DB_Simulasi_20120717_1500.bak'
/*-----code:end-----*/

Result Messages:

The backup set on file 1 is valid.

It Means:
* File backup "DB_Simulasi_20120717_1500.bak" is ok.

Msg 3201, Level 16, State 2, Line 1 - Cannot open backup device When Run RESTORE VERIFYONLY Statement

Read more »

When run this query:
/*-----code:start-----*/
RESTORE VERIFYONLY FROM DISK = 'D:\DB_Simulasi_20120717.bak'
/*-----code:end-----*/


Error Messages:

Msg 3201, Level 16, State 2, Line 1Cannot open backup device 

'D:\DB_Simulasi_20120717.bak'.

Operating system error 2 (The system cannot find the file specified.).

Msg 3013, Level 16, State 1, Line 1 

VERIFY DATABASE is terminating abnormally.

Msg 15281: SQL Server blocked access to procedure 'dbo.sp_send_dbmail' of component 'Database Mail XPs'

Read more »

Error Messages:

Msg 15281, Level 16, State 1, Procedure sp_send_dbmail, Line 0 

SQL Server blocked access to procedure 'dbo.sp_send_dbmail' 

of component 'Database Mail XPs' 

because this component is turned off 

as part of the security configuration for this server. 

A system administrator can enable the use of 'Database Mail XPs' by using sp_configure. 

For more information about enabling 'Database Mail XPs', 

see "Surface Area Configuration" in SQL Server Books Online.

Note:
Use the Database Mail XPs option to enable Database Mail on this server.
The possible values are:
• 0 indicating Database Mail is not available (default).
• 1 indicating Database Mail is available.

OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005

Read more »

Error Messages :

Server: Msg 7399, Level 16, State 1, Line 1 

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. 

The provider did not give any information about the error. 

OLE DB error trace 

[OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005:  

The provider did not give any information about the error.].

* * * * *

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' Supplied Invalid Metadata For Column

Read more »

Error Messages : 

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' supplied invalid metadata for column 'KdCabang'.
The data type is not supported.
OLE DB error trace
[Non-interface error:  Column 'KdCabang' (ordinal 1) of object
'SELECT KdCabang, Cabang FROM [Sheet1$]'
reported an unsupported value for DBTYPE of 0].

* * * * *

Error SQL: Could not locate entry in sysdatabases

Read more »

Error Messages : 

Server: Msg 911, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][SQL Server]
Could not locate entry in sysdatabases for database 

‘HRD’.

No entry found with that name.
Make sure that the name is entered correctly.

ODBC SQLState: 420000 - RESTORE DATABASE is terminating abnormally

Read more »

Error Messages:

Microsoft SQL-DMO (ODBC SQLState: 420000) 

Exclusive access could not be obtained because the database is in use. 

RESTORE DATABASE is terminating abnormally.

“The system cannot find the file specified” When Using xp_cmdshell

Read more »

Apply To :
Microsoft SQL Server 2000

Error Messages :

The system cannot find the file specified. When using xp_cmdshell.

Error Messages - Incompatible Server Version When Restore Database

Read more »

Apply To :
Microsoft SQL Server 2008 R2

Error Messages :

Msg 3169, Level 16, State 1, Line 2 

The database was backed up on a server running version 10.50.1600. 

That version is incompatible with this server, which is running version 10.00.1600. 

Either restore the database on a server that supports the backup, 

or use a backup that is compatible with this server. 

Msg 3013, Level 16, State 1, Line 2 

RESTORE DATABASE is terminating abnormally.