Assigning value of a search

I have a stored procedure that builds a select statement based on search options in a web page. At …

Remote Backup

I am having 10 remote location having dial up connection and running MSDE , any way is there so i c…

eWeek Performance Results

http://www.eweek.com/article/0,3658,s=708&a=23115,00.asp compares several databases. SQL Serv…

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…