Somehow you are not running the last SQL I gave you. I know that because ANAvn isn't in it anywhere. Do not put this SQL into the stored procedure at all. It is only for problem analysis and should be run all by itself. Leave the SP alone for now.
2004-10-07
Nice!You are exactly correct. I have a noparam stored proceedure they just have to execute. Takes about 3 sec. I will slap them for you! They are complaining because our environment has grown about 20 fold this last year and with each expansion, another task has to be completed to test. This has slowed development […]
2004-10-06
I am not saying that you remove referential integrity. This could very well be a design issueex:1.Resources (ResourceId (PK), ResourceName)2.Connectors(ConnectorId(Pk), ConnectorName)3.Connections (ConnectorId1(PK), ConnectorId2(PK), ResourceID(PK))I really don't know enough about your model but You should look at it more than once to see if a different approach seems naturalOn the other hand The Logic once encapsulated […]
2004-09-28
1 reads
Hi all,After rebooting the server that run SQL Server 2000, I got error for a few replications. "The subscription(s) have been marked inactive and must be reinitialized. NoSync subcriptions will need to be dropped or recreated".I managed to reinitialize some of them but there is one particular Transactional Replication that neither I could reinitialize nor delete […]
2004-09-28
41 reads
Hi Aaron, The user has execute permission on the stored procedure, but when the stored procedure tries to insert, he gets a permission error.
2004-09-28
1 reads
2004-09-14
I was doing some time trials today and couldn't get enough data to really "hurt" the procedure, so I hit upon the Cross Join functionality. Say you want a million+ records and your biggest testing table has only 1000.All you have to do is Cross Join it to itself and you get 10002 or a million […]
2004-09-09
1 reads
take care that you might face some problem if you make SQL Server and SQL Server Agebt work on Local account ...it is recommended to set it to a Domain account (and must be from the adminstarors Group)I hope this help u
2004-08-15
2004-07-22
2004-07-08
In the modern data-centric landscape, SQL stands out as the dominant tool. It's essential...
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...
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