Skip to content

Instantly share code, notes, and snippets.

@mudpuddle
Created October 29, 2013 21:47
Show Gist options
  • Save mudpuddle/7223232 to your computer and use it in GitHub Desktop.
Save mudpuddle/7223232 to your computer and use it in GitHub Desktop.
SQL Server Stuff to Remember.
-- osql -U<username> -P<password> -S<server> -i<path to sql script> -o<output>
USE [master]
GO
EXEC z_cdosysmail
'jesse.wegner@obdp.org', -- From Email
'jesse.wegner@obdp.org', -- To Email
'OregonProjects', -- Email Subject
'Done' -- Email Body
GO
USE [<database>]
GO
DECLARE @User varchar(20)
SET @User = '<username>'
--link a system user and an orphaned user (of the same name) together
EXEC sp_change_users_login 'Auto_Fix', @User, NULL, @User
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment