For SQL Server 2005, let's say a machine dies, but you have backups
for everything (all user and all system DBs).
After getting a new machine and the OS installed and SQL Server
installed and the DBs restored, are there any configuration items

Howdy.
I'm attempting to use DATEPART to give me a two-digit month, and further, to
cast that as a nvarchar. It is rendering March as '3' instead of '03'.
Is there a way to get '03' here????

I'm trying to implement full-text search for the albanian language. What's
the best way to implement it?
Based on my current understanding the most feasible way is to:
1. Use one of the supported lnaguages, for example Turkish.

I'm trying to run a query to list the total number of cases for a
contact over a set period for each country.
I've created the following query -  but I need to include the
countries where a match isn't found.

Need exact difference between delete,truncate and drop table.
Thanks in advance

I am trying to write a stored procedure that would take two
parameters: db name and the username and will grant that user execute
permissions on all stored procedures for that particular database.
That stored procedure should reside centrally on my database that I

I want to synchronize several tables of 1 local db (SQL Compact) with a
server db (SQL Server Standard) (both db's have the same schema) via an ADSL
connection (over the Internet). The sync is ONLY from the local db to the
server db. I want to achieve this in a simple way by ...

example
Select col1, col2, (col1+col2) as total
from table1
where total > 0

What I have is 2 columns. They need to be mutually exclusive. They are both
integer columns that allow nulls. They need to be constrained so that one
column is always null. For example column a has a 1 then column b must have
null. If column b has 10 then column a must be null.

Hi, I have a sql 2005 with Sp2 applied. My Build is 9.0.3054
Now I have the error described in Fix 934459 (The Check Database Integrity
task and the Execute T-SQL Statement task in a maintenance plan may lose
database context in certain circumstances ), but my build 9.0.3054 ...

1) We are running the full backup every satuday 23.15 hours. before that we
are
2) There is another maintenance process starting at 22.05 PM(optimization)  
and 22.30 PM (integrity).  While CHECKDB is running, the more transaction log

I'm relatively new to SQL admin. Have a database that is almost 59GB in size:
the .mdf is 58.8GB and the .ldf is 3MB. Recovery model is Simple. I suspect
the db is larger than it needs to be because everymonth we run a routine in
our business application (MAS200 for SQL Server) ...

Simple question.
Let me give some background. To increase performance on one of our SQL 2000
servers we decided to use filegroups for two of our biggest tables. What I
did was create one filegroup called ‘others’ with it’s own .ndf file, and a

SQL Server 2000 SP4 (Windows 2000) - DB2 V 8.1 FP14 (Linux RH  3.1)
I need to transfer data from a DB2 that is on the Linux server to SQL Server
2000 database. The data would be in small amount and for 5-6 tables. What is
the best way to do this and what do I need ?

is there a way to run a query that will search through my entire database
for a specific word?