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.
Using T-SQL in SQL Server · To search for a table across databases in a server
'SELECT "?" AS DB, *
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...
I have logged in to the SQL Server using winodws authentication and created a new login with SQL authentication. Then tried login with the...
The request failed or the service didn't respond in a timely fashion consult the event log or other applicable error logs for...
Log reader agent has failed with an error
Login failed for user 'sql-user-account'.
Right click on the publication name and open...
Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 188
This database is not enabled for publication.
I have used the below...