Marc Valk dot Net
blogging about…… Microsoft, Cloud Computing
Archive for the ‘SQL Server’ Category
Identify SQL Server version
In: SQL Server
30 Oct 2009Some TSQL command to identify the version of SQL you are running: SQL Server 6.5 SELECT @@VERSION Version Number Service Pack 6.50.479 SQL Server 6.5 Service Pack 5a (SP5a) Update 6.50.416 SQL Server 6.5 Service Pack 5a (SP5a) 6.50.415 SQL Server 6.5 Service Pack 5 (SP5) 6.50.281 SQL Server 6.5 Service Pack 4 (SP4) 6.50.258 [...]
- No Comments
- Tags: SQL Server
a colleague of mine made a super blog post about an operational, near real time, BI platform for monitoring packages in a package sorter for the Dutch TNT Post Pakketservice. Go check it out here
- No Comments
- Tags: Cloud Computing, SQL Server
We had a problem with executing a SQL Job which runs a SSIS Package. Whenever the job started we would get the following error: Executed as user: <domain>\<user>. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 09:13:01 Error: 2009-08-05 09:13:02.85 Code: 0xC002F304 Source: [...]
- No Comments
- Tags: SQL Server
SQL: Microsoft SQL Server, error:916
In: SQL Server
6 Jul 2009I created a SQL User named UserA which was DB_Owner of 1 database. When I connected to this database with SQL Authentication I received the following error: The server principal “User A” is not able to access the database “DatabaseA” under the current security context. (Microsoft SQL Server, error:916) To resolve this error I logged [...]
- (1) Comment
- Tags: SQL Server
SQL Query to identify Kerberos or NTLM connection
In: SQL Server|Security
10 Apr 2009SELECT s.session_id, c.connect_time, s.login_time, s.login_name, c.protocol_type, c.auth_scheme, s.HOST_NAME, s.program_name FROM sys.dm_exec_sessions s JOIN sys.dm_exec_connections c ON s.session_id = c.session_id A query to see if a connection is made with Kerberos or NTLM. login_name together with host_name and program_name will identify the login. auth_scheme will reflect what [...]
- (2) Comments
- Tags: Scripts