system and application logs

start --> run --> eventvwr

Its a trick question that encourages people to just cut and paste and see what happens.

the question appears to be on how constraints work but is in effect testing your...

Any patch to SQL will affect the version no. In this case it will change to 4053.

applications are not concerned with the version no of SQL, your app will not...

go with your findings and what MS themselves state in the CU information.

Only apply a CU if it fixes a problem you have actually encountered.

when I have had to apply...

It cannot be done without some downtime.

your options are detach\attach, restore with move option or alter database modify file with offline/online.

choose whichever is fastest for you. alter database is least...

no it doesn't, if you do it through EM the account will be assigned all the permissions it needs at the same time. doing it through the services applet does...

http://www.microsoft.com/sqlserver/2005/en/us/express.aspx

check administrative tools\services

That error normally occurs because instance is not running, its not usually because remote connections are not enabled

Are you sure the instance is up and running and you have the correct instance name. IIRc for the express edition it is called servername\SQLexpress

right click server name, select properties, select security tab and amend the startup service account.

You quit? That was drastic. 🙂

for cert files, see http://social.msdn.microsoft.com/Forums/en/sqlsecurity/thread/5bb750cd-c4e2-44e9-9938-5975bae3d9ca

calico-604598 (6/6/2010)

MOSS 2007 and SQL 2005 Windows 2005

Moving system databases on new locationS on the same server (tempdb, master, model, msdb, resource and CERTIFICATE)

Question 1 :

I will like to...

you could do it with the sqlcmd utility.

what error do you get trying to connect, and what version of SQL and OS.

It may have lost some of its rights, so check. Have you tried reenabling the account as the logon account via EM, or a server reboot?

thanks for posting back tracey.

sounds like you fell foul of the old gotcha of not having the resource database with your master database.

not sure you get that tool with the express edition.

Use the sp_configure system stored procedure via a query window in SSMS to allow remote connections. See BOL.