I am working as a sr. Developer for one of the application.
The search should allow to use whild cards.....
Consider that I have three rows in table
1. Mark

ok, I have a table with names of countries.
I have another table with a description field.
I want to join the country_name with the description field, BUT
instead of the join being based on equality, I want it be based on

I've been scraching my head on this for so long. We have two servers (both
running SQL 2005 64-bit Enterprise Edn SP2 on Windows 2003 Standard 64-bit),
one of the servers is able to send the attachment in the email, whereas the
other is failing with Msg 22051 error:

SELECT
 isnull(cval, 1) cval
FROM
 tbl

I pretty much think I know what this does, but I've never seen a
DELETE statement with 2 FROM clauses:
delete from #acc
      from ggg d

I have inherited a SQL Server (2005) from an outgoing DBA and while I'm
familiar with databases from a data structure/manipulation standpoint, the
permissions/security model in SQL Server 2005 has baffled me thus far.  I
digress...

I think my Database is refering to the wrong time somewhere.  If I run
SELECT GETUTCDATE I get the wrong time if I run SELECT GETDATE this shows
the right time.  It looks like it's using GETUTCDATE can I force it to use
GETDATE?  The actual Windows Server is correct as well.

I'm hoping someone here can give me some advice on the best way to configure
my situation.
We're running SQL Ent on Win2KA with 6GB RAM.  We have both /PAE and /3GB
enabled, and SQL set to a max server memory of 2GB.  However, when I look at

I am trying to optimize a stored procedure. One thing confused me is that on
the SQL Profile trace, the version with more cpu, read, and write has less
duration. Usually I see duration is almost directory linked to cpu time.
Does anyone know what could cause this? Thanks.

Production Server: Windows 2000 server, SQL Server 2000 SP2
Test Server: Windows 2003 server, SQL Server 2000 SP3
I have to restore the master database from Production Server to Test Server.
Would it cause any issues? Thanks.

My SQL 2000 server seems to be logging data an hour early, the Windows 2003
time is correct though.  What steps should I take to find out what is
happening.  I'm in the UK and we have to change our clocks for day light,
but these are all set to automatically adjust clocks.

When I run
   select @@servername
where does the servername come from?
It isn't the master.sysservers table like I thought.

i've installed SQL Server 2005 Standard SP2 on a W.2003 Std. SP2, and I'm
worried about the security. Server authentication is "SQL SERVER mixed
mode", and windows firewall is on, but 1433 tcp port is open beacuse the
users needs to manage their databases remotely. Databases are ...

how do i limit SQL servers CPU usage ?  (2005 express)
killer queries are slowing all other services.
mem limited already.
thanks

Hi. I am struggling to link a SQL2005 box to a SQL2000 box via linked server.
I have done this before and am replicating what I did then but I can`t get it
to connect. However when I connect via query analyser using the same
credentials it connects with no issues. Has anyone seen ...