But you don't need to configure SQL mail to recieve a backup file. You can recieve from any mail (hotmail? or whatever) and then restore directly to SQL. SQL mail is used primary for problems or errors notification using alerts or scripts. For example, if a jobs fail, I want SQL to send an email […]
2003-05-14
Looking through the Wrox Press Book "Beginning PHP4 Databases" the comments that it makes on MySQL and PostGres are MySQL Optimised for Reads only apps. Doesn't support DRI. Doesn't support views or stored procedures. Doesn't support transactions or locking It does make reference to InnoDB which provides an interface to MySQL in an attempt to […]
2003-05-14
I have begun to experiment with FileMakerPro just because. I hit a lot of Oracle servers that are running behind many of the production systems here (mostly large scale datawarehouses and a problem management server). I have hit but go rid of Informix which was running behind our cal center switches. I have hit SYBASE […]
2003-05-14
2003-05-14
1 reads
quote: A developer in our company changed her password and since then this error has been happening intermitently. Is this just happening for SQL Server or for other services as well (file & print, for instance)? K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-05-13
Dear Gurus Well, I do think all those (good!) tips can conduct us to a ..."salomonic" idea -- that I'll try (needless to say) just if-and-when that never-ending-loop happens again...: - That's to say: 1º - disconnect IIS; 2º - close IE; 3º - (re)open IE; and 4º - (re)connect IIS. It worths a try!, […]
2003-05-12
Thanks Jeremy, It puts me on the right track, but how do I get the data into one recordset? I now have the following: Select Distinct AttributeID, CASE dbo.QIMS_FORMS_INSTANCE_DATA.ColumnID WHEN 1 THEN dbo.QIMS_FORMS_INSTANCE_DATA.Data End AS Target, CASE dbo.QIMS_FORMS_INSTANCE_DATA.ColumnID WHEN 2 THEN dbo.QIMS_FORMS_INSTANCE_DATA.Data End AS LowerLimit, CASE dbo.QIMS_FORMS_INSTANCE_DATA.ColumnID WHEN 3 THEN dbo.QIMS_FORMS_INSTANCE_DATA.Data End AS UpperLimit From […]
2003-05-12
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-12
I meant to add that in the case of an infinite loop on the server side, closing IE that invoked the page will terminate the session at IIS so that you should not have to stop and restart IIS. Then opening a new instance of IE should return performance...
2003-05-12
Ahh, but that's the thing, none of the usual SPs or INFORMATION_SCHEMA items report an incorrect size. And none of the usuall DBCC items report any issues.
2003-05-12
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers