I think that it would be impossable to get this question correct ( unless you chose the incorrect series)as it does not give you the option to select Local named...

You have several options for determining the port number a SQL Server...

Ah but Gail did you not know that SQL Server is self tuning indexes never get fragmented statistics are always up to date (especially when do an upgrade from oh...

Oh and with regards to interviews. I try to remember that that person had to prepare , get suited and booted , go to the expense and stress of...

I have visited many many client sites where absolutely no maintenance plans exist and in some cases they have a very small window in their 24/7 operation to update...

If you would like to find out more about plan guides goto

http://technet.microsoft.com/en-us/library/ms190417.aspx

in addition I would like to add that index fragmentation may also add to your problems if...

IF this is a SQL 2005 instance then the following may help

select suser_name(role_principal_id), suser_name(member_principal_id) from sys.server_role_members where member_principal_id = suser_id('LOGIN')

select permission_name, class_desc, major_id from sys.server_permissions where grantee_principal_id = suser_id('LOGIN')

Note: LOGIN...

BTW you can read Pauls totally excellent article on recovering corrupt database here

http://www.sqlskills.com/blogs/paul/2007/10/02/SearchEngineQA4UsingEMERGENCYModeToAccessARECOVERYPENDINGOrSUSPECTDatabase.aspx

Ah well perhaps I should have added that you should first open your dos command window -> run -> CMD then from there navigate to the Drive then folder in...

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

You can replace the /qb with /qn if you want a silent upgrade but then you will need to check the install logs...

Are you trying to change a default or named instance of sql server ? if it is not a default instance then you need to change the string MSSQLSERVER to...

The question that I always ask is:

Given that we take a full backup once a week and diff backups every day and transaction log backups every 15 mins and...

:hehe: Glad to see I was not the only one to discover this feature or is it lack of Feature.. and you will also find that if you don't install...

I would suggest that you first check both the SQL server Error log and the Server Event log this should give you starting point hopefully you have enabled logging for...

I think that you should perhaps remember the rule Login to the Server and Access to Database objects. Just because you have been granted rights to Login to the...