I am working on SqlServer 2000,
When row will be inserted/updated  in one table that data neds to be
inserted/updated into the another DataBase on the same machine. Both
table has different schema, what is the Better solution? I know we can

I need to compare two varchar columns containing date values. One
column contains the 'dd-mmm-yyyy' format in english, the other in
dutch. Problem is that in march,may and october the 'mmm' format is
different. So essentially, the question is: how can I compare '10-

We are running a server with IIS and SQL 2K using the following
configuration:
C: OS/Inetpub
D: SQL 2K DB/Logs

Gurus,
Running SQL Server 2005 SP2.  I noticed when I explore my users SQL database
mappings, a lot of times their default database is "Master" instead of the
various application databases which exist on the server.  Which is correct,

Gurus,
Is there any disadvantage to running a SQL Server in Windows Authentication
mode only?
--

If anyone has any ideas on this one ... I'd appreciate it very
much ...
... I've got one database on our server that refuses to backup ...
several other database work just fine ...

I have a question regarding performing this task on our database.  We run
this once a week, Sunday at 1:00am.  We are noticing that all of a sudden
our Transaction Log is growing virtually from 100MB to 25GB over the weekend.
I am trying to find out if re-organizing the indexes ...

Hi Sql server experts,
Is there a way that I can tell the agent to run a job in the lowest
priority(resource wise)?  like Unix NICE command.
I need to solve this problem we are having ASAP. I appreciate any prompt

I have turned on the database option read_committed_snapshot
alter database mydb set read_committed_snapshot on
this only took 1 sec.
But now I'm trying to turn it off.

Hi I am completely new to scripted actions on Windows machines, I have been
doing these sorts of things for years on Linux/Unix machines. We have a SQL
2005 server which we share with a few departments, all of the logins and
databases are setup the same we create a login called ...

I am in the process of moving some oracle sql into sql server 2005.
where decode(instr(translate(upper(job_id), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ',
'~~~~~~~~~~~~~~~~~~~~~~~~~~'), '~'), 1, 1, 0) = 0
From what I'm told, the code above is used to check to see if the job_id

We have a stored procedure and would like to register some information even
if the stored procedure is rolled back.
Current workings:
1. Client program start a transaction.

Hi SQL Folks,
I want to transpose rows into column based on a column1.
Here is my table
Column1    Column2    Column3    Column4    Column5

I'm running an ASP based report. It's always worked, but for some
reason now I get the following:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E09)
[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission

Gurus,
Running SQL Server 2005 SP2 configured for Windows Authentication on a
two-node cluster running Windows Server 2003 SP2 inside a single Active
Directory domain.   SQL Server 2005 is configured for two named instances