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…

Error in SP with PRINT statement

Hi, I added another local variable to a stored proc and got the following error: 'Only constants, e…

execute stored procedure in DTS task

I want to execute a stored procedure in DTS task. This stored procedure has one input parameter and…

DTS Status

Where does SQL Store the status properies of a package after it has executed. For each step in the…