The fulltext catalog upgrade failed because of an inconsistency in metadata between sys.master_files and sys.fulltext_catalogs
I am using sql server 2008 and when trying to restore .bak file I'm getting this error: The fulltext catalog upgrade failed because of an inconsistency in metadata between sys.master_files and ...
In SQL server with enterprise edition, there are databases with all the tables/indexes compressed. Does it still make sense to do compressed backup?
Inspecting a rather critical database that is used by some software on my system, I found that one of the tables had a primary key on the column Id, where Id is calculated using checksum(newid()). ...
I am try to run bulk insert command on SQL Server 2008 but I am having issues with the security. after researching via internet, the problem has something to do with account delegation and ...
created a login and a user in the master database and linked that user to the login. I created a new database, then went to that database and immediately tried to create a user linked to the same ...
I'm in need of some help with SQL Server. I’m fairly new to SQL Server so bear with me. My situation: We currently have SQL Server 2008 Express installed and running on Windows Server 2003. We are ...