This topic will discuss the database owner as the server principal that owns the database or object/job. Often mistaken by the role “db_owner” a fixed role within MS SQL Server. A job will stop running when the owner’s account is dropped, or not active in active directory. — Databases select SD.name as dbname ,suser_sname(owner_sid) as […]
The porsche black box experience, its not just a normal blackbox becouse at porsche they dont do normal. They only do exceptional. They claim the blackbox is specially designed to personally invite you for a driving experience which has never been offered before. Using the most modern technology they will connect your heart and […]
use [DATABASE] select c.name ,c.is_nullable ,c.max_length ,c.precision ,c.scale ,c.user_type_id ,dt.name AS TypeName from sys.columns c join sys.tables t on t.object_id = c.object_id JOIN sys.types AS dt ON c.user_type_id=dt.user_type_id where t.name = ‘[TABLE_NAME]’ order by c.name
Type From To bigint -9,223,372,036,854,775,808 9,223,372,036,854,775,807 int -2,147,483,648 2,147,483,647 smallint -32,768 32,767 tinyint 0 255 bit 0 1 decimal 1E+38 10^38 –1 numeric 1E+38 10^38 –1 money -922,337,203,685,477.5808 +922,337,203,685,477.5807 smallmoney -214,748.3648 +214,748.3647
CREATE TABLE #sp_who2 (SPID INT,Status VARCHAR(255), Login VARCHAR(255),HostName VARCHAR(255), BlkBy VARCHAR(255),DBName VARCHAR(255), Command VARCHAR(255),CPUTime INT, DiskIO INT,LastBatch VARCHAR(255), ProgramName VARCHAR(255),SPID2 INT, REQUESTID INT) INSERT INTO #sp_who2 EXEC sp_who2 SELECT * FROM #sp_who2 — Add any filtering of the results here : WHERE DBName <> ‘master’ — Add any sorting of the results here : ORDER […]
Property Pane Visibility InitialToggleState : True.
If you are in acceptance environment and want your query to run in production, you need to change the connection to the instance/connection of production. To change the connection associated with a query In Query Editor, right-click a blank area of Query Editor, point to Connection, and then click Change Connection. In the Connect to […]
Restoring a T-SQL error or incorrect filter into your MS SSRS dataset(s) can be a lot of work if it occurs several times. In the example below we will search for the error can you gues what went wrong? The comparison is greater than instead of equal to Parameter @color. To find this typo, use […]