RE: Why Generic Error Handling?
Is this the same question as on SQL Server Performance.com?http://www.sommarskog.se/error-handling-II.htmlhttp://www.sommarskog.se/error-handling-I.htmloffer a good insight on error handling.
2005-05-03
database
RE: SqlServerAgent cann''''t see mail profile only created with Outlook
Or you could forget the hassle of setting up the profiles and use xp_smtp_sendmail from www.sqldev.net
2005-04-20
2005-04-18
Sqlserveragent service started and then stopped
When attempting to start SQLserveragent service, then servie starts and then stops issuing an informaitonal message "SQLServeragent servie on Local Computer started and then stopped. Some services stop automatically if they have no work to do..."This prevents the service from running and from starting dependent tasks. The messge is not logged into the event viewer or […]
2005-04-11
2,493 reads
2005-03-31
Displaying relationships on databases/tables
Is there a sql command that would list all the relationships on a database or even just a table?uanita
2005-03-29
1 reads
Can''t upload reports
I usually use the upload functionality to deploy reports. Today, when I click "OK" to upload the new RDL file, nothing happens. This worked fine for me last Thursday. The only change I know about is that 4 patches were pushed to my workstation on Friday, (KB840315,KB841872,KB841873,KB842526). I have looked these up and don't really […]
2005-03-28
2 reads
Date calculation trigger problem
I am trying to code an after insert, update trigger that will calculate a date but I am having a problem with my date variables being an invalid data type. I rightly or wrongly chose to try and perform this operation using a trigger because of a condition has to be tested and a few of the fields […]
2005-03-28
1 reads
RE: how to find sa password
SA may not be the only login that can perform a backup. Backup permissions default to members of the sysadmin server role and the db_owner & db_backupoperator database roles. If there's a login in one of those roles that you know, use it to do the backup.If you do a search on this site for […]
2005-03-16
RE: Curious Locking
Thanks for that..had a look.The execution plans were identical.I tried varying the indexes on this table. One index in particular was dropped and it cured the problem....the query now runs in about 5 minutes instead of an hour. Funny thing is the same indexes exists on a similar test system and that runs ok??Thanks again..Graeme
2005-03-11
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers