Some notes on software development... RSS 2.0
# Tuesday, 08 September 2009

If you change the name of a computer running SQL server you must also update the system metadata stored in sys.servers.
First check the current name by using

If @@SERVERNAME does not show the correct computer name you should change it using the following commands:

select @@SERVERNAME

sp_dropserver <old_name\instancename>
GO

sp_addserver <new_name\instancename>, local
GO



Last step is to restart the SQL Server instance.

Links
How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server

Tuesday, 08 September 2009 08:26:13 (GMT Standard Time, UTC+00:00)  #    -
SQL Server
# Wednesday, 10 June 2009

Sometimes when I log in to a remote desktop session it appears as thought the Windows key is stuck on, so pressing keys like ‘L’ always locks the screen.

The workaround I found is this:

In the Local Resources options for the remote desktop session you should set the Apply Windows key combinations to be On the remote computer

image

Next log in to the remote desktop session.
Press Ctrl-Alt-End to lock the session.
Log in again and the Windows key will become unstuck.

Links
Windows key "stuck" in Remote Desktop...

Wednesday, 10 June 2009 08:55:16 (GMT Standard Time, UTC+00:00)  #    -
Windows
# Thursday, 21 May 2009

The Pre and Post build events in Visual Studio 2008 run as a batch file so you can check the ConfigurationName variable to only do things for Release mode.
For example, to copy the built files in Release mode to C:\Temp

if $(ConfigurationName) == Release copy $(TargetPath) "C:\Temp"


From StackOverflow

Thursday, 21 May 2009 09:25:53 (GMT Standard Time, UTC+00:00)  #    -
Visual Studio
# Wednesday, 22 April 2009

Because I keep forgetting the syntax…

DBCC CHECKIDENT('TableName', RESEED, 0)

Wednesday, 22 April 2009 22:59:53 (GMT Standard Time, UTC+00:00)  #    -
SQL Server
Navigation

Sign In
Extras
Statistics
Total Posts: 116
This Year: 0
This Month: 0
This Week: 0
Comments: 36
About the author/Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2017
Hadrian Phillips

All Content © 2017, Hadrian Phillips
DasBlog theme 'Business' created by Christoph De Baene (delarou)