Viewing 15 posts - 211 through 225 (of 1,192 total)
Hi,
Try this. It's untested obviously but should do what you need. You'll need to add a filter in the first insert to exclude other databases if there are any. Also...
January 26, 2015 at 4:18 am
mister.magoo (1/24/2015)
Just click on the "Columns" node in Object Explorer, then press F7 to open the details view...
January 26, 2015 at 3:10 am
crookj (1/23/2015)
SQLRNNR (1/23/2015)
Ed Wagner (1/23/2015)
djj (1/23/2015)
Ed Wagner (1/23/2015)
crookj (1/22/2015)
SQLRNNR (1/22/2015)
Ed Wagner (1/22/2015)
crookj (1/22/2015)
Ed Wagner (1/22/2015)
SQLRNNR (1/22/2015)
StingWrestling
Luger (his tag team partner)
Ric Flair (Whooo!)
The Ultimate Warrior
Road Warriors
Vader
Skywalker
Darth Maul
C3D2
RU12
5318008
January 23, 2015 at 9:27 am
Yeah, I'd be using sys.objects etc for that, or the INFORMATION_SCHEMA views.
Could be nice to have sorting/filtering on the Object Explorer though.
January 23, 2015 at 9:25 am
Ha, thanks & you're welcome. If you're new to SQL Server then this site has to be one of the best resources around.
Highly recommend taking a look at the 'Stairways'...
January 23, 2015 at 7:35 am
No, it'll be in the definition of the trigger, as shown on the link you provided.
Locate the trigger in Object Explorer (under Server Objects\Triggers), right-click on Script as DROP...
January 23, 2015 at 7:13 am
Ah, Ok, I was struggling to work out what was generating the error/email!
Is it not just a matter of modifying the trigger to change the @profile_name parameter when calling msdb.dbo.sp_send_dbmail...
January 23, 2015 at 6:46 am
Do you receive emails from the cluster successfully in other situations? Or check by right-clicking on Database Mail & selecting Send Test Email... and send yourself an email.
If not SQL...
January 23, 2015 at 6:38 am
Ok thanks, if you look in the reporting services logs are there any more details?
January 23, 2015 at 4:20 am
The first place I'd look would be the SET options, are they the same when running on SSMS/Prod?
2 plans in the cache?
January 23, 2015 at 3:36 am
Thanks, connecting via that should upgrade the RS databases automatically. Is the 2005 RS patched to the latest SP (SP4?)
January 21, 2015 at 10:15 am
Hi & nice to meet you Shev!
No punts on Ayla or Kara yet? I've not got a clue who they are!
January 21, 2015 at 9:53 am
Thanks, me too.
One of the reasons I tend to favour T-SQL scripts over the GUI is sometimes the GUI does things you don't expect or can't see 🙂
January 21, 2015 at 5:45 am
No problem, unfortunately I think it'd be down to trial & error - DBCC CheckPrimaryFile is an undocumented command and I haven't seen any info on what permissions would be...
January 21, 2015 at 5:11 am
Cool. I suspect that the GUI is trying to execute DBCC CheckPrimaryFile against the db master file pre-attach to get file information, which is failing as the user isn't defined...
January 21, 2015 at 4:37 am
Viewing 15 posts - 211 through 225 (of 1,192 total)