Ok--I've got a VS-2003 VB.NET-based service that scrapes data from an external web site. The site uses a two-step process of showing the query response--in response to the POST request, it returns an HTML doucment containing only a javascript "document.location" redirect which browsers handle...
Found the answer to my own problem: orphaned article
The sysarticles table had entries for an publication that no longer existed. Removing the orphaned entries allowed the drop-column SP to run fine (I have an idea of how the orphans got there and it was due to other issues we had...
select cast(year(productiondate as varchar)) & cast(month(productiondate as varchar))
from table1
First, forgot the close-parenthesis after "productiondate" in the YEAR and MONTH function calls and second follow sean4e's advice about the "+" instead of "&" (which is used to do a logical order...
Table currently replicated from SQL 2000 server to another (with the second also as the distributor).
Using sp_repldropcolumn to drop a column without needing to re-snapshot. When we make the call on the publisher, we get this error:
Server: Msg 4932, Level 16, State 1, Line 1
ALTER TABLE...
Ok--I want to setup an alert to let me know when blocking is going on. I've found referneces to selecting "SQL Server Performance Condition Alert" on the "New Alert" form in Enterprise Manager... But, unfortunatley, when I go in there, I only have "SQL Server event alert"...
So, how do I get...
Oh, I understand that--but I have a feeling that the ability to pick large orders in under a minute instead of the 10-minutes it takes now may take priority over some slower reporting...
Thanks again.
Ooo... by golly there is a clustered index on a non-key field (part number)... Most likely put on sometime ago for some type of reporting.
I'll have to have that changed to non-clustered over the weekend (the database is also replicated and I've got to halt replication before changing the...
I know row-by-row isn't the best, but this is a process that I inherited that I cannot change in the near-term.
The process itself is such: when picking an order, for each item in the order, the warehouse location to be used is determined based on some business rules, a call is made to the...
I've got some triggers that fire on insert that is used to push a copy of each inserted record into an audit database. Lately, inserts into a particular table have started to bog down considerably (~7 seconds per row!).
Data is inserted into the table row-by-row (order picking detail records...
As a follow-up.
We've also found these entries in the SQL Server Log on Server-A (target server) whenever attempting to execute the linked server command:
[COLOR=red]Resource Manager Creation Failed: XACT_E_CONNECTION_DOWN[/color red]
Searches of the MS-KB only report issues addressed in...
Ok--here's the scenario I've got:
1) Server-A: Windows NT-4 (SP6), SQL 2000 (no SPs)
2) Server-B: Windows 2003 Server, SQL 2000 (SP3)
2) Server-C: Windows 2000 Server, SQL 2000 (SP2)
Up until this past weekend, when Server-A was rebooted, I've had a few scheduled jobs on Server-B that did...
Ok--in VB6, to support on-the-fly language changes for our users, we applied a method of loading a list of control translations from a SQL table into a dictionary. Then, for each control in the form.controls collection, based on the control's .Name property (e.g.--mnuFileExit), looked up the...
Thanks! That was perfect! It even handled the re-direct I had to detail with by making striping out the redirect info then making a second web-call...
Thanks again!
Ok--I've got a project where I've got to load the HTML response form a URL into a string, then strip out key parts of the page.
In VB 6.0 I used an object called ASPTear which took a URL and returned the HTML as a string. I figuired that .NET might have such an item built in, but looking...
I have a stored procedure that is to delete all records for an order. The delete statement does not fail, but doesn't remove all of the records I expect it to remove. The statement in the SP is literally:
DELETE
FROM Order_Picked_Items
WHERE (Site = @m_site)
AND...
Getting the above error setting up a subscription using transactional replcation. Both servers are SQL-2k boxes in different domains.
Topology:
Srv-A (Publisher: SQL-2K [no SP])
Srv-B (Dist/Sub : SQL-2K [SP2])
Trusted connections have been established between the domains. I am able to...
Situation:
SERVER-1 (SQL 2000 [no SPs]): Distributor and Subscriber (in US)
SERVER-2 (SQL 2000 [no SPs]): Publisher (in US)
SERVER-3 (SQL 2000 SP 1) : Publisher (in UK)
SERVER-3 (SQL 2000 [no SPs]): Publisher (in CH)
We are using Transactional Replication with continuous update from two...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.