There's no way we'd dump SQL for anything else, we've pretty much tied ourselves in (much to MS pleasure im sure).

I do agree with Steve that I wish MS would...

Happy aniversary,

We're busy migrating from Itanium 2's in production to quad socket dual core x64 cpus, hopefully they'll be a lot better as they've doubled the clock speed since we...

try long weekend my friend

I could be wrong but i think i've seen this sort of thing in the past when there was a problem on our internal network.  I'd ask the network admin...

I think that you can't go far wrong with the Inside SQL Server 2005 series, Kalen Delaney wrote the one for SQL 2000, the 2005 version consists of 5 books...

The quickest way to check is to look at the services running on the server where SQL is installed, if the SQL Server service is running as local system rather...

I agree with Steve, this would not be a good use of triggers, much better to have a job that queries the table than try to do too much on...

that you should run DBCC UPDATEUSAGE to correct the count

Speaking as someone who has done this quite a few times I want to congratulate you on a job well done.

As we all know it's either going to work 1st/2nd...

Wow, a majorly good article, I faced similar problems a while back but on 2000 (fingers crossed we dont get something similar on 2005 when we upgrade at the end...

I think what Colin is trying to say is that in 2005 you can use table partitioning to do the hard work for you.

If you partition on date then you...

What an idiot, i have no idea why i never just thought of exec-ing the SP over the linked server, that worked a treat

I'd thought of that but you're only allowed a maximum of 2 prefixes, i'd need 3-4 [linkedserver].database.owner.table.

Unless I can get away with just using linkedserver.table and set up the linked...

Thanks very much

absolutely, last day at work today so the moral's have been put to one side so they don't affect the party this afternoon

Merry...