Viewing 15 posts - 616 through 630 (of 13,463 total)
also i use this proc to update the job description of SSRS subscriptiosn to have the report name; makes it a LOT easier to track down.
it uses dynamic SQL...
February 14, 2017 at 11:44 am
you could also create a subscription in Standard edition, and use a SQL Agent job to call the subscription job if the criteria is met.
so assume you create...
February 14, 2017 at 11:39 am
There's more than one way to do that.
in my case, the convert function would work nicely, if you include the optional code:
SELECT CONVERT(varchar(10),getdate,112) , where you replace getdate()...
February 14, 2017 at 10:56 am
wrong toolbox.
click in the upper right corner here to get the SSIS toolbox instead.
February 14, 2017 at 10:34 am
LPIM = Lock Pages In memory?
i had no idea that was a permissions headache, but i found an image!![]()
February 14, 2017 at 7:51 am
we'd need to see your update and select statements, really.
does your update inner join to another table?
a SELECT might return more rows, because the other table has...
February 10, 2017 at 9:42 am
great, now go back to your queries for all mail and the query i posted for failed mail;
do you see those messages as sent or failed?
did they...
February 10, 2017 at 9:35 am
find your name in the upper right corner and click it.
basically your profile page then has three links down at the bottom of your picture...
Topics = Original...
February 10, 2017 at 9:32 am
the code generated the command to run. I also pasted it in my post for convenience; it's not as familiar looking as a regular SELECT statement, but it will try...
February 10, 2017 at 9:26 am
notice the item with 40 rows?
that's the one that's stuck.
run teh "ClearQueueCommand" that was in the results:WHILE EXISTS(SELECT
'ExternalMailQueue' AS ServiceBrokerQueueName,
*
FROM
February 10, 2017 at 9:09 am
didn't realize you were running 2005, i should have read deeper. I don't have that version to test against.
comment out that column name, adjust the query a bit till...
February 10, 2017 at 8:52 am
design view caches data when it's run the first time, and uses that for design purposes. it does not run the query every time.
http://stackoverflow.com/questions/338009/ssrs-different-results-in-data-tab-and-preview-tab
if you search...
February 10, 2017 at 7:08 am
I'm assuming you know that shrinking is a bad thing, etc etc.
your command is almost right, just need to tweak it if you want to assign it to...
February 10, 2017 at 6:27 am
ok i found my diagnostics scripts.
run these scripts in the msdb database.
--confirm is_broker_enabled = 1SELECT DB_NAME([database_id]) AS DatabaseName,
[database_id] ,
is_broker_enabled ,
February 10, 2017 at 6:19 am
Ok ive seen that kind of situation before. You can try the sp_mail_stop and sp_mail_start to fix the service broker, but in the past ive had to completely stop both...
February 9, 2017 at 8:32 pm
Viewing 15 posts - 616 through 630 (of 13,463 total)