xp_sendmail and variables in @query

I am retrieving a set of email addresses using a cursor and setting the address equal to a variabl…

try/catch

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

how to create a user without a login name

I found my existing SQL Server database (called it A) has user (who is the db_owner) with <None&…

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 …

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…