dual primary keys?

In Access it's possible to apply two primary keys to a field (so that both fields must be unique as…

Clustering

Hi all, I want to simulate a clustering in Windows 2000. I have to PC connected with HUB. Both inst…

DTS job Failed, Pkg started manually and work.

? Created several DTS pkgs. All worked fine until today. One of them failed this morning, checked …

reference the CD for retreving the info for docmen

what is sql server ?

What 's interessant in sql server: what are its capacities and properties ?

Problem with with immediate replication

I setted up transactional replication between two servers over internet. This contains two publica…

arithmetic overflow error with log reader agent

First of all I truly believe this site is great, very accountable and dependable I am having a tra…

Enterprise or Standard SQL?

I have a pharmacy client that is looking to do web-based exchange of prescription information among…

Bug Tracking Software

Im currently looking for a bug tracking solution. Either app or web based, use SQL for data of cour…

unwanted blank row in txt file when using isql >>

I use a batch file that runs two ISQL commands that build a text file: (see below) ISQL -U sa -P …

ASP - Reaping the benefits of SQL 2000's FOR XML

There were a very interesting article on http://www.sqlservercentral.com, about using FOR XML for d…

Coding for "Not Distinct"

I would like to run a simple query to identify duplicate records in a table, in other words, someth…

Abstracts for Articles

This is based on comments Andy posted in reference to an article I wrote. Perhaps those of us that…

Exploring Deadlocks

Comments posted to this topic are about the item Exploring Deadlocks Robert W. MardaBilling and OSS…

sp2 to install or not to install

Folks, Just had me admin on the phone asking me my advice on an sp2 install. We have no sps install…