Wondering if anyone has any clues on following problem I'm having with a linked server. This problem is something that occurs with WinXP SP2 and is documented in the following KB article:839279 - You may receive a 7391 error message in SQL Server 2000 when you run a distributed transaction against a linked server after you […]
2004-08-15
7 reads
Check SQL Server installation log sqlstp.log at c:\winnt directory.
2004-08-13
2004-08-12
Hi there...We are using .NET (VB .NET) frontend applications to analyse Data from SQLServer 2000. We use stored procedures where we can.First of all, when using stored procedures through the Command Object and adding Parameters, SQL-Injection is avoided.Secondly, by seperating the business logic and data logic more scalability is acchieved. If I have a reporting tool, […]
2004-08-10
Ok. I dont see the difference at all in 2 queries. They are same. I think its a mistake. since both queries are same, why would the result set be differet. I think my answer about "identical recordsets? " is correct. or someone please shine a light on my head and explain why there is […]
2004-08-10
2004-08-10
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-09
I think that Sheilesh is trying to convert the non-clustered primary keys to clustered, and that they cannot be dropped because of foreign keys. Yes, other non-clustered indexes need to be rebuild, because of the way sql server then points these non-clustered index keys to a primary key to a row for faster table access.Sheilesh didn't […]
2004-08-08
Advertising content removed by the SQLServerCentral.com staff
2004-08-03
Hi there,We have a couple of problems that are affecting just a few (2 out of 10) users who are using Enterprise Manager on a remote Server over Terminal Services.1. Registration of Servers does not stickI can register SQL servers under various groups, and they are recorded in the registry, but when I close / re-open Enterprise Manager, […]
2004-08-03
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers