Rajanand Ilangovan
Rajanand Ilangovan

Rajanand Ilangovan

Rajanand Ilangovan

Rajanand Ilangovan

5 followers

I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.

How to search for a table or column in all the databases in a server

Nov 17, 20221 min read 6 views

Using T-SQL in SQL Server ยท To search for a table across databases in a server EXEC sp_MSforeachdb 'SELECT "?" AS DB, * FROM [?].sys.tables WHERE name...

How to fix the error of dynamically generated T-SQL query when the syntax is correct?

Oct 12, 20221 min read 9 views

Problem: I was generating a query using dynamic SQL and copied the result from grid and pasted into a query window and executed the same. This...

How to fix SQL Server SQL authentication login issue when the user name and password is correct?

Oct 10, 20221 min read 15 views

Problem: I have logged in to the SQL Server using winodws authentication and created a new login with SQL authentication. Then tried login with the...

How to fix SQL Server Integration Services could not be started issue?

Oct 1, 20221 min read 8 views

Error: The request failed or the service didn't respond in a timely fashion consult the event log or other applicable error logs for...

How to fix Log reader agent login failure in SQL Server replication?

Sep 30, 20221 min read 7 views

Error: Log reader agent has failed with an error Login failed for user 'sql-user-account'. Solution: Right click on the publication name and open...

How to fix "This database is not enabled for publication" issue when the replication option is already enabled in SQL Server?

Sep 25, 20221 min read 38 views

Error Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 188 This database is not enabled for publication. I have used the below...