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…

Assigning value of a search

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

dual primary keys?

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

Best Practices - Editing

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

eWeek Performance Results

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

sql server and arabic langage?

Did you know can sql server support arabic langage and how ? Otherwise, please send me any document…

Log file 13 GB

Hi I want to reduce the log file, size 13 GB but maintaince backup want run, how do I manuelly run …

DTS job Failed, Pkg started manually and work.

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

what is sql server ?

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

reference the CD for retreving the info for docmen

Remote Backup

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

Trigger Problems Part 2....

The Saga continues... Can you call stored procedures from a trigger? Can you make the trigger run a…

Clustering

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

ORACLE 9i Linked Server

Hi, I have a SQL Server database named HENDRA on Windows 2000 Advanced Server. I want to configure…

sp_rename Error

Please can anyone help me. I am trying to remname a column in a table. However I am getting the e…