RE: Monitoring SQL Server Cluster
Allready tried that.Is there a method to polll the cluster service itself for this type of events? Preferably to the virtual machine. Regards
2004-08-13
backup
Review of IIS Admin Tool (No, its not a SQL article)
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/col
2004-08-10
2 reads
RE: Interesting ! Update query with alias ?
Interesting AJ! If you read the BOL reference I posted, it specifically states and shows by example that the syntax won't work.Guess that's one of the 'flukes' in SQL Server.-SQLBill
2004-07-29
RE: Delete taking too long
If you are absolutely positive that the records that you are about to delete don't have an related records in other tables then, as part of the delete process, try dropping the constraint before you do the delete then re-enable the constraint afterwards.
2004-07-29
RE: sql server 2000 trigger for checking duplicate email in a table
Hmmm - not quite sure what you're after. Do you have a 'person' table containing an e-mail field and want to maintain a separate table which contains just e-mail address (and, presumably, a foreign key back to the main 'person' table)? So do you therefore want to migrate your e-mail addresses away from your 'person' […]
2004-07-29
RE: sql server and photos
Im using access data pages for now, but Im open to anything that can do what I need. Access isnt allowing me to enter the info. what is the easiest way to do a web page with a sql database back end??? The only requirement is I have to be able to have a very user […]
2004-07-28
RE: How to capture error message
As you mention, the test from sysmessages isn't that helpful. Try this interesting technique, http://qa.sqlservercentral.com/columnists/ajethva/capturingtheerrordescriptioninastoredprocedure.asp
2004-07-26
RE: RecordCount problem with static recordset
Try changing the ADODB cursorlocation to be adUseClient. Then you should be able to get a recordcount. The problem is the recordcount uses client always and when the cursor location is on the server it can't get a count.If the above gives a -1 add re.movelast and rs.movefirst and then check record count.
2004-07-23
Merge replication error, foreign keys
I'm running into an issue with merge replication that has just started to crop up. I wrote a nice process for checking data in/out of a tablet for field work and something was missed in my documenting HOW I set it up.When I go to run a pull merge subscription from the subscriber I am […]
2004-07-21
70 reads
automatic statistics collection?
I read that this is a default configuration, but where do I check to see if it is configured and how do I change it?
2004-07-20
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