a) Enter the URL check the login page open or notb) Default focus should be on user namec) Pass word should be encryption format or not

SELECT 'Drop '+CASE

Declare @sql varchar(8000), @table sysnameSelect @table='table_name', @sql=''Select

Create procedure Backup_all_databasesasDeclare @sql varchar(8000)set @sql=''select @sql=@sql+

http://www.sqlusa.com/bestpractices2005/centurydateformat/ ...

A couple of my colleagues were having a problem when starting Management Studio. Everytime the application started it would show a blank messagebox with just an OK button. Apparently this can be caused by installing the .NET Framework 1.1 (or one of it'...

The following SQL Server T-SQL queries will yield fast (not real time) row counts in each table in the database:...

DECLARE @tables TABLE(table_name VARCHAR(100))INSERT INTO @tablesSELECT name FROM sysobjects WHERE xtype ='u'

Generate SQL Script option from Enterprise Manager/Management Studioselect * from information_schema.columns where table_name='table_name'

Following script which will extract the domain and will also count how many email addresses are there with the same domain address.declare @t table(email varchar(100))insert into @t