2004-11-09
Stretch Database
RE: Daylight Savings Time and Backups
For the record, sp_update_job is in the MSDB database, and the rule about stored procedures beginning with 'sp_' doesn't apply. My daylight saving time adjustment job was pointed at the Master database and failed on every server it was deployed on!!! The up side is that I learned that SQL 2000 handles the change even […]
2004-11-01
RE: Question of the Day for 21 Oct 2004
I agree with everyone on this... a stoopid question. MIDDLE isn't a formal SQL-Server keyword and not part of the product.So lets try to have reasonable questions that'll stretch peoples knowledge of the subject product (i.e. Microsoft SQL-Server) and not just throw in things just for the hell of tripping people up.
2004-10-21
RE: Backup strategy for replication
Hi, I have a query on bakcup and Restore with Log files. (SQL server 2000) I have created a Full Backup at 5PM. and Two Transactional backups at Interval one hour i.e at 6PM and 7PM I Tried to restore above Files .... a. Full Backup restore is Done Successfully ( I have Selected Leave […]
2004-10-21
RE: Errors with Cursor in Stored Procedure
The problem that I see is that you don't have the field ZoneCombo listed in your cursor's select statement. You use the OF keyword to limit the updating to specific fields. If you don't include the OF keyword, but just have FOR UPDATE, you can update any of the fields defined in the select statement […]
2004-09-08
PredictHistogram() generates probability over 100%
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!
2004-08-13
RE: SQL query listener?
Sounds like you need a network sniffer. There are a whole host of them. the Sniffer (tm) product I know recognizes some of the TDS packets correctly, or at least the last time I used one for a trace it did. But that was a few years ago. You'll also need some assistance from your […]
2004-08-05
RE: Is it possible to pass a parameter in the Use command?
Phil,Your code work but the DB shown in the query analyzer doesn't change.
2004-07-22
Blogs
Connect With More Clients: Our Partner Directory Has Arrived
By Rob Sewell
The partner directory connects your agency with new customers.
Can You See Who Forced a Plan
I had an excellent group of people in Gothenburg Sweden when I taught there...
Monday Monitor Tips–Finding CUs for My Instance
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
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