Viewing 9 posts - 1 through 9 (of 9 total)
thank you for your reply. It seems to be a good idea to give them these permissions. I will do so. 🙂
June 23, 2016 at 7:26 am
EXEC msdb.dbo.sysmail_help_profile_sp
June 21, 2016 at 3:32 am
It works in this way:
DECLARE
@day char(2) = UPPER(SUBSTRING (datename(DW,getdate()-1),0,3))
,@folder nvarchar(2000) = N'C:\Temp\'
,@as nvarchar(128) = N'AnalysisServices'
DECLARE
@server SYSNAME = @@SERVERNAME
,@linkedServer SYSNAME = (SELECT name FROM sys.servers WHERE provider...
November 20, 2015 at 6:33 am
To get the object-ID for my job I would use something like this:
SELECT *
FROM
OPENQUERY([TESTAS],'SELECT OBJECT_ID FROM $SYSTEM.DISCOVER_OBJECT_ACTIVITY WHERE OBJECT_PARENT_PATH = ''servername.Databases''')
Igor, thank you for your great support!
November 6, 2015 at 4:25 am
Thank you. I created the linked server "TESTAS" and the connection test is okay.
SELECT * INTO [Test].[dbo].[TestAS] FROM
OPENQUERY([TESTAS],
'SELECT [CATALOG_NAME] FROM $system.DBSCHEMA_CATALOGS')
November 6, 2015 at 2:27 am
Now it works! Definition code in information_schema.routines ist varchar(4000), the definition code might be incomplete. So I needed to use another source.
If you change @var to 'V', you can...
August 21, 2015 at 7:12 am
okay, I've feared this. Thank you for your reply.
August 21, 2015 at 1:55 am
Viewing 9 posts - 1 through 9 (of 9 total)