Pages

▼
Thursday, May 17, 2018

SQL Server Job Failed [SQLSTATE 42000] (Error 3013) and (Error 3202)

›
My SQL Server job is failing throwing errors as shown below  [SQLSTATE 01000] (Message 3211)  Write on "\\backup-location\folder\d...
1 comment:
Monday, May 8, 2017

Identity Specification (Is Identity) SQL Server Table

›
Saving Changes is not Permitted. Tables need to be dropped and re-created. Message is appeared while you try to change the (Is Identity) Co...
Wednesday, August 10, 2016

Message 15063, Login Already Exists

›
Recently, I received an error from a Share-Point 2013 database creation from the Farm Account As you all know, while triggering a new dat...
8 comments:
Friday, September 18, 2015

Lost SQL Server access, forgot 'sa' password no clue how to gain access?

›
I recently encountered an issue where I didn't have access to SQL Server and I was asked for help to debug and gain back control o...
1 comment:
Wednesday, October 15, 2014

Database in Recovery Pending State

›
Database 'db_name' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorl...
2 comments:
Friday, September 5, 2014

›
High PLE high Performance. Page Life Expectancy commonly called as PLE,  is number of seconds a page will stay in the buffer pool.  The ...
Thursday, September 4, 2014

SQL Server Error Log Recycle (ERRORLOG file growing large)

›
SQL Server Error log is too large and has grown upto 24GB, it takes a lot of time to open and sometimes hangs and SSMS gets into not-respo...
1 comment:
Monday, July 21, 2014

Where does SQL Server 2012 License Key gets stored?

›
Many of my folks had a question about MicroSoft SQL Server License Key. SQL Server license key can be found at the below location the r...

Connecting to the Integration Services service on the computer "SERVER_NAME" failed with the following error: "Access is denied."

›
TITLE: Connect to Server ------------------------------ Connecting to the Integration Services service on the computer "SERVER_NAME...
1 comment:
Friday, June 27, 2014

Cannot see ODBC Driver after installation of Oracle 11g client.

›
I installed the ORACLE client tool full Administrator option Still not able to see the ODBC drivers for Oracle? I know I have ins...