Viewing 15 posts - 1 through 15 (of 131 total)
OK, take the code below and modify it to dump everything into a temp table.
Then select jobName from the table where lastRunStat in ('cancelled' or 'failed') then issue a...
March 24, 2010 at 12:48 pm
ok, I figured it out....join is to sysjobs name to convert(sysname, schedule_id)
Note: it will not list out all subscriptions, but only those that have been scheduled and are active.
I...
March 24, 2010 at 9:21 am
My users have the same requirements to
1) Document who has what report subscription
2) Show a list of reports that were scheduled to run...
March 24, 2010 at 8:31 am
I have contacted MS Support, will post their responses here.
MS Says
The account that run the setup has domain and local admin permission on that server, it run remotely....
February 17, 2010 at 1:33 pm
Have you tried installing it in mixed mode, than manually adding the security at a later time using the SA id?
February 12, 2010 at 9:25 am
-- Run this procedure to create a nice report for backups
-- Backups are flagged current if within 24 hours old
-- this also tracks deleted databases (marked Legacy) just in...
February 11, 2010 at 3:26 pm
Have you tried to UNION the results together? This will cause a sort
Also, I find that some of my reports are best ordered by invisable columns that the users...
May 14, 2009 at 10:56 am
=Format(Fields!YourFieldName.value, "##,##0.00")
this works better for float numbers, as you can set the decimals ny changing the format string above
May 13, 2009 at 8:05 am
Why wait when I can write it my self......Here is a function to convert the seconds to DD:HH:MM:SS
now still wondering if I can toggle or if a new report will...
March 2, 2009 at 2:48 pm
I was contracting at a company that had a 7TB database of historical transactions.
For this database it was def. worth the effort, as we could partition the...
January 16, 2009 at 10:18 am
oh, yes one more thing....once you know the SPID, doa DBCC Inputbuffer(SPID) to get the text of the offending message...
June 17, 2008 at 10:25 am
I would say you have some process that is updating every row in your large table.....
do this to identify....this will identify the top disk IO users for the past minute.....change...
June 17, 2008 at 10:23 am
You obesrvations correct, they do not have ANY database objects in source control, so opening a job from source is not an option....much along the line of quitting the contract.....lol
From...
June 17, 2008 at 9:49 am
The list continues to grow......
Server Security
• Local server access granted to domain user
• Local groups
• Domain Users granted to specific Local groups
• Local disk shares
• FTP access
System Programs
• SQL Server running user-id
• SQL Server Agent running ID
• SSIS...
March 6, 2008 at 2:11 pm
Anyone know anything at the network level that might cause a connection to "hang" when it is really dropped at the network level?
EP
February 25, 2008 at 1:07 pm
Viewing 15 posts - 1 through 15 (of 131 total)