https://technet.microsoft.com/en-us/library/ms156356(v=sql.105).aspx Right click on Jobs folder in SSMS and select Manage Schedules To use a shared schedule
Month: October 2014
https://technet.microsoft.com/en-us/library/cc959339.aspx To view the Advanced TCP/IP Settings dialog box Right-click My Network Places , and then click Properties . Right-click the connection that you want to view, and then click Properties . Click Internet Protocol (TCP/IP) , and then click Properties . Click Advanced ,…
SELECT * FROM dbo.SystemAudit FOR XML AUTO, TYPE, ELEMENTS XSINIL XSINIL — for null values to show – which produces — <Notes xsi:nil=”true” /> –, ROOT(‘Pipeline’)
go to sql server config mgr network configuration protocols make sure TCP/IP is enabled
USE master GO xp_readerrorlog 0, 1, N’Server is listening on’ GO
exec sp_spaceused or select name, filename, convert(decimal(12,2),round(a.size/128.000,2))as FileSizeMB, convert(decimal(12,2),round(fileproperty(a.name,’SpaceUsed’)/128.000,2))as SpaceUsedMB, convert(decimal(12,2),round((a.size-fileproperty(a.name,’SpaceUsed’))/128.000,2))as FreeSpaceMB from dbo.sysfiles a
CREATE PROCEDURE dbo.usp_Demo WITH EXECUTE AS ‘SqlUser1’ AS SELECT user_name(); — Shows execution context is set to SqlUser1. EXECUTE AS CALLER; SELECT user_name(); — Shows execution context is set to SqlUser2, the caller of the module. REVERT; SELECT user_name(); — Shows execution context is set…
https://www.mssqltips.com/sqlservertip/2894/understanding-grant-deny-and-revoke-in-sql-server/ Grant – gives perms GRANT SELECT ON OBJECT::Test.TestTable TO TestRole; Revoke- undoes perms whether it’s grant or deny REVOKE SELECT ON OBJECT::Test.TestTable FROM TestRole; Deny – blocks access and trumps all other access DENY SELECTONOBJECT::Test.TestTable TO TestUser; — Query sys.database_permissions to see applicable permissions…
http://msdn.microsoft.com/en-us/library/ms190920.aspx You can override the database collation for char, varchar, text, nchar, nvarchar, and ntext data by specifying a different collation for a specific column of a table and using one of the following: The COLLATE clause of CREATE TABLE and ALTER TABLE. For…