So, if I understand you correctly, you're suggesting to set transactional replication from remote server to local server. Can this be set up to have...
I currently have the remote (master) server set up as the publisher and the local set up as a pull subscriber. Transactions will only be initiated...
I have an ASP.NET web app running on a remote server drawing data from a remote SQL Server 2000. I have a local server on which I want to intstall...
Good advice. The way our system is architected, it will be easy to implement and switch back if a problem arises. Thanks for your help!
Hi Amit, It does seem to work. I created a stored proc which basically uses the code you posted to create a job and add steps and schedule. For...
Well, I probably wouldn't use a trigger with this idea. I'd probably make a new stored procedure that creates the job. That stored procedure would...
Hey Amit, Thanks! That is awesome! According to MSDN, I could leave off ACTIVE_START_DATE because it defaults to today's date right? Also,if I...
Hey... that says exactly like what I need. Can you point me to a good article on how to create a job like you're describing? Thanks!!
Hi Experts! I have a question about triggers. I have a stored procedure that I call from an ASP page that can take a longer amount of time than...
hmmm... didn't get my question answered though... my thread was hijacked! <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />How...
OK, I have some questions about licensing of SQL Server 2000. I'm currently with a web host and want drop the monthly expense for having SQL Server...
Ok All, GOT IT! The app is coded in ASP and I found an SQL Injection vulnerability. I found a script file that was placed on my server which...
Hi All, I've discovered that my server has been compromised and I believe it came through SQL server. I see in my application event log that the...
Hi Adriaan, I follow you now. That's a good point. It brings up some interesting ideas as the architecture of my system has changed. I had a page...
Hi Adriaan, My example was just a simplified version showing how I planned to use the rank column. The actual query is a bit more complex.
Thanks for the tips! I think the extra query would hurt performance in the rowcount method. Twan, would a clustered index be in order here?
That looks like a possibility but your implementation would continually update only the first 5000 each time, wouldn't it? There is nothing there to...
Hi All, I need to do an update on a large number of records in a table. The records to update are determined by the value of a 'groupID' column in...
The scoring table has hundreds of thousands of rows but the groupid limits that amount and rank limits the nubmer of return rows to 40. There are 21...
I have individual indexes on userid, groupid, and weeknum. I have multi-column, non-clustered indexes on (groupid and weeknum) and (groupid, weeknum...
Separate names with a comma.
