IMO Enterprise Manager would be to tedious to manage that many servers. It could be used to investigate problems, but for overall monitoring I wouldn't rely on just that. There are a few options. I believe one is a tool called SQL Monitor. I do not have the financial support to buy a tool so I […]
2004-02-20
How about we complain, while we wait for Brian's response. How about this; to make amends, we get another 2 points for pain and suffering and 1 point for punitive damages.
2004-02-06
How about something like...select case when A=B then 1 else 0 end from ( SELECT CHECKSUM_AGG(BINARY_CHECKSUM(*)) as A FROM Table1 ) RC1 , ( SELECT CHECKSUM_AGG(BINARY_CHECKSUM(*)) as B FROM Table2 ) RC2
2004-01-20
2 reads
what about SQLEXECMS, it works pretty well for me and the price is right. http://www.laplas-soft.com/exec-intro.htm
2003-07-31
1 reads
Shas3 - Thanks for the reply, I took a look at what you suggested and the Show System databases and Objects is checked. The user cannot even see the system databases??
2003-07-30
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-07-14
2003-07-11
1 reads
hi, just do the restore again with force restore over existing database, rather then removing it forst Paul
2003-07-11
1 reads
Yes, I am using ADO. How can I cycle(loop) through the records inside the SP itself? Is that possible?
2003-07-08
It looks like a fairly clean trigger already. What you could do to make it a little less repetitive or verbose is declare some variables for the keyn, tbln, rcid, nval, oval fields in your smatth002 table, just for readability, and you might change your subselect to an inner join?: create trigger... ... as begin […]
2003-06-18
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
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