how to join 2 tables using a wildcard?

I am trying to figure out a way, using a sql statement, to join two tables where the join field fro…

sql server 7.0 dts export datetime format

When I use dts to export from my sql server 7.0 database to a text file all of my date fields have …

try/catch

Is there any function like try/catch to catch the errors

Waht is the Best way to crash server?

Hi, All What is the best way to crash server? I mean stress test:-))) I have a new server but when …

Best Practices - Editing

We recently went thru a process of data migration from an AS\400 system to SQL2000. Since then, we…

quick help is needed

I have a domain user account and it is given an administrator's right on my SQL server machine. Whe…

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…