Monday, February 23, 2015

Cannot execute as the database principal because the principal "dbo" does not exist

›
Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impe...
Wednesday, March 6, 2013

Database cannot be opened due to inaccessible files or insufficient memory or disk space

›
Msg 945, Level 14, State 2, Line 1 Database 'db' cannot be opened due to inaccessible files or insufficient memory or disk space....
39 comments:
Tuesday, September 18, 2012

SQL SERVER – SSMS Automatically Generates TOP (100) PERCENT in Query Designer

›
SQL SERVER – SSMS Automatically Generates TOP (100) PERCENT in Query Designer : Earlier this week, I was surfing various SQL forums to see ...
Thursday, May 3, 2012

Lengh of LOB data to be replicated exceeds configured maximum 65536

›
Whenever you try to replicate data from a database that saves the images(filestream) in the database, and you have included those images in...
2 comments:
Tuesday, April 3, 2012

Attached failed, Unable to open physical file, operating system error

›
Some time when you try to attach database files (.mdf, . ldf) to sql server , you might get the error "Unable to open physical file, ...
20 comments:
Tuesday, September 27, 2011

A table with FILESTREAM column(s) must have a non-NULL unique ROWGUID column

›
I was trying to add a filestream column in one of my existing tables, initially i thought it would be very easy for me, but when i got th...
5 comments:
Monday, April 11, 2011

An easy way to get the Definition of an Object

›
I was using the sp_helptext very frequently to get the definition of an object. Here is another easy way to get the definition of an objec...
1 comment: