SELECT name FROM sys.databases
|
DECLARE @str NVARCHAR(4000) = ''
SELECT @str = @str + ',' + name FROM sys.databases
SELECT @str
|
SELECT max_workers_count
FROM sys.dm_os_sys_info
|
SELECT count(*)
FROM sys.dm_os_workers
|
SELECT db_name(database_id) AS 'Database',count(page_id) AS 'Dirty Pages'
FROM sys.dm_os_buffer_descriptors
WHERE is_modified =1
GROUP BY db_name(database_id)
ORDER BY count(page_id) DESC
|
sp_linkedservers
|
select T1.name, T1.product, T2.remote_name, T2.modify_date
from sys.servers T1
inner join sys.linked_logins T2 on T1.server_id=T2.server_id
|
USE DB_Name
Go
exce sp_spaceused N'테이블명'
GO
|
USE DBName
GO
SELECT distinct object_name(id)
FROM syscomments
WHERE text LIKE '%검색어%'
|
 | Dinosaurs Before Dark (Paperback, 미국판) -  메리 폽 어즈번 지음, 살 머도카 그림/Random House |
USE msdb
GO
-- 패키지 파일 암호 확인 쿼리
DECLARE @jobname VARCHAR(128) = NULL
, @stepname VARCHAR(128) = NULL;
SELECT sj.name AS JobName
, sjs.step_name
, sjs.subsystem
, sjs.command
,CASE WHEN sjs.command LIKE '%/DECRYPT "\"%'
THEN SUBSTRING(sjs.command, CHARINDEX('/DECRYPT "\"',sjs.command,1)+12
, CHARINDEX('\""',SUBSTRING(sjs.command
, CHARINDEX('/DECRYPT "\"',sjs.command,1)+12, LEN(sjs.command)),1)-1)
WHEN sjs.command NOT LIKE '%/DECRYPT "\"%' AND sjs.command LIKE '%/DECRYPT "%'
THEN SUBSTRING(sjs.command
, CHARINDEX('/DECRYPT "',sjs.command,1)+10
, CHARINDEX('"',SUBSTRING(sjs.command
, CHARINDEX('/DECRYPT "',sjs.command,1)+10, LEN(sjs.command)),1)-1)
ELSE LTRIM(RTRIM(SUBSTRING(sjs.command,
CHARINDEX('/DECRYPT', sjs.command, 1) + 9,
CHARINDEX('/', sjs.command,
CHARINDEX('/DECRYPT', sjs.command, 1)
+ 1) - CHARINDEX('/DECRYPT',
sjs.command, 1)
- 9)))
END AS pkgpassword
FROM msdb.dbo.sysjobs sj
INNER JOIN msdb.dbo.sysjobsteps sjs
ON sj.job_id = sjs.job_id
WHERE sjs.subsystem = 'SSIS'
AND sjs.command LIKE '%/DECRYPT%'
AND sj.name = ISNULL(@jobname, sj.name)
AND sjs.step_name = ISNULL(@stepname, sjs.step_name);
|
public sub Main()
Dim db_connection As String
Dim strdb_name As String
Dim strsvr_ip As String
Dim strsvr_port As String
Dim FailConn As Boolean
Dim FireAgain As Boolean
Dim conn As New MySqlConnection
FailConn = False
FireAgain = True
strdb_name = Dts.Variables("__v_dbname").Value.ToString 'ssis변수에서 받아오는 부분
strsvr_ip = Dts.Variables("__v_ip").Value.ToString 'ssis변수에서 받아오는 부분
Strsvr_port = Dts.Variables("__v_port").Value.ToString 'ssis변수에서 받아오는 부분
db_connection = "server =" & strsvr_ip & ";user id=userid;password=password;port=" & Strsvr_port & ";database=" & strdb_name & ";"
If Not conn Is Nothing Then conn.Close()
conn.ConnectionString = db_connection
Try
Dts.Connections("connection").ConnectionString = db_connection
conn.Open()
Dts.TaskResult = ScriptResults.Success
'MsgBox(db_connection, MsgBoxStyle.Information, db_connection)
Catch ex As Exception
'Dts.Events.FireError(0, "My Script Task", "An error occured:" + ex.Message.ToString(), "", 0)
Dts.TaskResult = ScriptResults.Failure
End Try
End sub
|
