Advanced Querying

Technical Article

Trigger Woes

  • Topic

Hi, I may have misunderstood the concept of triggers, but the following trigger doesn't work, no errors, just doesn't work, can anyone tell me why? Also I don't seem to be able to use columns that do not exist in the table the trigger is defined on, I cannot find any real detailed info on […]

2002-02-14

2 reads

Technical Article

Admin rights to your SQL Servers

  • Topic

How many of you have actual privledges to the physical server that houses your SQL Server, and have local admin rights? A lot of Corporations do not allow a DBA to have access or Local Administration privledges to the server. They have division of resposibilites and only a few select people can log onto the […]

2002-02-14

3 reads

Technical Article

SQL Server OLE DB Provider

  • Topic

We have a VB application connecting to SQL Server 2000, using OLE DB Provider (MDAC 2.6 SP1). We receive the following message "Cannot open database requestes in login 'DBName'" Error code: -2147467259 This is happening in our production environment, but not in our development enviromnet. It's quite rear, don't you think ? All ideas are […]

You rated this post out of 5. Change rating

2002-02-08

7 reads

Technical Article

Data access from Oracle 7.1

  • Topic

Dear All, My requirement is to import the data from Oracle 7.1 (16 bit) into SQL 7.0 (32 bit). An early and clear response will be appreciated. Regards Sanjeev Verma SKV

2002-02-08

1 reads

Technical Article

How have you improved the SQL Servers at your work

  • Topic

I am wondering what each of you have done to improve the SQL Servers where you work and hoping to get some ideas that I haven't thought of for improving ours. I'll start off with one of the improvements I made after starting at bigdough.com: We had a DTS package that would run nightly to […]

2002-02-07

7 reads

Technical Article

Is Foxpro to SQL Server 2000 Replication Possible?

  • Topic

I have a request to replicate information from a Foxpro database developed in Visual Foxpro 6.0 to SQL Server 2000. I was wondering if this is possible. I am interested in using snapshot replication to do a pull subscription from the foxpro data into SQL Server. Best Regards, Jim Reisz

You rated this post out of 5. Change rating

2002-02-06

2 reads

Technical Article

Merge Agent?

  • Topic

Hi, we have SQL2K as a pulisher and 5 other SQL2K as a subscriber,5 Merge Replication are being setup for those machines. All the 4 of them work properly, except one of them wich is the last one i had setup. it works form few day and then stops and then works again...??? Here's the […]

You rated this post out of 5. Change rating

2002-02-04

8 reads

Technical Article

Setting up Dev, Test & Prod Servers

  • Topic

Hello, At present, we only have a production server with no development or test servers. I know this should be a criminal offence, but until now, the SQL Server was not the most important server...but now it has turned into a critical Server, and because of this I have persuaded the manager to upgrade the […]

You rated this post out of 5. Change rating

2002-02-04

1 reads

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers