Validate Deployed Databases by Version
Save all object definitions to a single stored procedure for easy validation
2010-01-14 (first published: 2009-12-18)
764 reads
objects
RE: Accessing data across two servers
Have you linked the server(s), using sp_addlinkedserver (or the Enterprise Manager UI) ?
2005-04-22
RE: Service started then stopped....?
I once had a similar problem with different error message. Actually the message was logged in Event Viewer. I'm not sure whether yours is the same as the one I've mentioned but it was solved after I have upgraded MDAC to 2.8
2005-01-28
3 reads
problem with run PROCEDURE-table is empty
i work with link server (pioledb)the problem is thet the table is empty sometimes an it not work OKhow can i condition the delete ???i wont thet the table is always be fullCREATE PROCEDURE [select_pi2]asDELETE FROM [pitable].[dbo].[Table1]INSERT INTO [pitable].[dbo].[Table1]([val],[uu],[col])SELECT *FROM OPENQUERY(pcntn, 'SELECT value as val ,''UNIT1''as uu ,''FF9900'' AS col FROM picomp WHERE time = […]
2004-12-30
2 reads
SQL LOG Error related to BPool
BPool::Map: no remappable address found.Can you tell me what this SQL Log error might indicate? Thanks!
2004-12-23
2 reads
2004-07-22
Alternatives to self-joins?
I have a small issue, but I cannot find a way out of it - any assistance with this would be great.We are implenting indexed views for a 'data warehouse' type arrangement. The problem is that many of our existing views incorporate self-joins which prevent me from creating indexes on them. These views have been […]
2004-03-10
212 reads
RE: Error 7399 OLE DB provider microsoft.jet......
Permissions are fine... I just don't understand how under one SQL server I can access the Link server and through a different server I can't.
2004-02-11
1 reads
RE: Still slow...could it be hardware?
You need to decide how you intend to read/update the data. If you are doing this is VB.net see a tool like LLBLGEN (http://www.sd.nl/software/) If you are using VB 6 see http://users.quista.net/thealey/download.htm (CodeGEN) for some samples on how to do this. I'm pretty sure your problem #1 has to do with with cursor type when you open […]
2004-01-14
RE: Reply -> Preview -> Post
We've seen the same thing sporadically. My guess is that some of the client side script is hanging up. We'll try to get it resolved tomorrow. I'll take a look at preview.
2004-01-04
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers