Tag Info

New answers tagged

3

Even with SQL 2000 Service broker is still your answer. I'm not going to go into how to set up a service broker solution here because to be honest it's complicated and I've only done it once. That being said, design your service broker system in 2008 and 2008 R2. For your 2000 system design a second SB system on one of your 2008 R2 systems (let's use ...


6

I think I would build a table with a queue of some sorts, and have a job poll that table and pick up any work it has to perform. So for example your trigger writes a record id in a table called processqueue, then you have a job that picks up all the records from the processqueue table and do it's heavy lifting for each and every record, removing the record ...


4

For recent versions of SQL-Server that support CTEs (and not the obsolete 2000): Using a CTE and copying a trick of @Paul White in this answer (to get TOP in the recursive part of the CTE): How to recursively find gaps where 90 days passed, between rows WITH CTE AS ( -- Anchor: -- Start with the earliest date in the table SELECT TOP (1) ...


-1

I am not much sure on SQL Server, but this works with PostgreSQL. Using Recursive CTE to start with the day, more comments are inline. create table amn1 ( id int, upd timestamp, price float); insert into amn1 values (5 ,'2015-07-17 09:02:00.000', 65.5), (5 ,'2015-07-17 09:03:00.000', 65.5), (5 ,'2015-07-17 ...


-1

Install MS SQL server 2000 via setup instead of AutoRun. Setup can bypass the compatibility check very easily.


1

How to rename sa to new_sa in SQL Server 2000? How to do and what is the impact I'm not sure how to rename sa in SQL 2000 or even if you can that far back. SA rename impact in SQL Server 2005, 2008, 2008R2, 2012, 2014, Express Edition I have heard of this as a best practice from some people. To the best of my knowledge there is no effect other than trying ...



Top 50 recent answers are included