This is also some cool tool you can use to retrieve the database ids for all databases on your server. I like writing this type of scripts because they come in handy and can help stop someones headache one day. Now, the logic l’m going to use is to find the maximum database id on […]
This is a little post to illustrate how to retrieve all tables in a given schema. This is a handy tool and can be used for various purposes. So lets call this procedure GetSchemaTables, it takes just one variable, the schema name. Remember this procedure has to be defined in the current database to which […]
In this post, l just want to show some cool programming skills and hopefully make it useful for any one interested in learning TSQL and use of variables and some date functions. The main purpose is to write a program that will return the day name such as Monday, Sunday etc of the first day […]
I just want to talk briefly about how we can access sql server instance running either on your personal computer or on a network. Authentication is a big issue for any server because if some successfully passed this gate, they have access to your server and can do lot of things so SQL server provides […]