CREATE DATABASE [dbname_with-odd_chars (May)] ON (FILENAME = ‘L:something.mdf’), (FILENAME = ‘I:something_log.ldf’) FOR ATTACH;
Category: sql sever syntax
must also USE database GRANT CONNECT TO [domainlogin] in order for them to be able to login
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
SELECT d.name, ROUND(SUM(mf.size) * 8 / 1024, 0) Size_MBs FROM sys.master_files mf INNER JOIN sys.databases d ON d.database_id = mf.database_id WHERE d.database_id > 4 — Skip system databases GROUP BY d.name ORDER BY d.name
SELECT * FROM dbo.SystemAudit FOR XML AUTO, TYPE, ELEMENTS XSINIL XSINIL — for null values to show – which produces — <Notes xsi:nil=”true” /> –, ROOT(‘Pipeline’)
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…