Table parameters are readonly. You cannot select into them. Use Table-Valued Parameters: Table-valued parameters must be passed as input READONLY parameters to Transact-SQL routines. You cannot perform DML operations such as UPDATE, DELETE, or INSERT on a table-valued parameter in the body of a routine. And Table-Valued Parameters: You cannot return data in a table-valued … Read more
Ok, after 6 hours of struggle and ‘googling’ I could finally get this work. The problem was due to some account name conflict. Here are the steps I followed to set it right 1) Un-installed the SQLserver 3) Re-installed it back with following changes In the server configuration section, I changed the account name details … Read more
Meanwhile I have managed to solve the issue. The problem was that I had my own stop list which was indeed empty but my fulltext catalog was associated not with my own stoplist but with the system one. Here are a couple of useful queries for solving stopword and full text search issues: Query stopwords … Read more
According to Aaron Bertand: You need to verify that the SQL Server service is running. You can do this by going to Start > Control Panel > Administrative Tools > Services, and checking that the service SQL Server (SQLEXPRESS) is running. If not, start it. While you’re in the services applet, also make sure that … Read more
Well, glad I asked. The solution I finally discovered was here: How do I configure SQL Server Express to allow remote tcp/ip connections on port 1433? Run SQL Server Configuration Manager. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS. Make sure TCP/IP is enabled. So far, so good, and entirely expected. But then: … Read more