Hello everyone, i need some help(((
i am  creating a procedure as this :
---------------
CREATE procedure [dbo].[automated_mark]

SQL Server 2000
We have a database that crashed and the log file is bad and the last good
backup was october, so the transaction log is bigger than the data file.
Since the  transaction log is corrupt,and we have no backups because the last

I am working with a fellow developer that cannot view database diagrams on
his machine. He can log into another machine and view them just fine.
Enterprise Manager has been removed, reinstalled and service packed to the
correct level.

If I have the following scenario:
1.  Stored Proc (ProcA) is started.
2.  ProcA starts a transaction.
3.  ProcA calls ProcB.

Is anyone familiar with a way to have a Windows 2003 DHCP server log to an
SQL server?

I am creating table in sql server 2005, by using the below script,but it
showing  "syntax error near (" The below script is created from generate
script option of sql) ,I ll apprecite the solution asap,Thanx guys
SET ANSI_NULLS ON

I am new to database administration, and I am considering my options
for backups. We are using SQL Server 2005 Standard.
I have done some reading and have determined the right backup scheme
for us is a weekly complete Simple backup with daily Differential

I am not able to BULK INSERT data files in SQL 2005 because it is
complaining about the format of the format description file (.fmt) (it says
something about invalid xml character ...) I am aware of the new XML format
definition and obviously by default SQL assumes that the format ...

I haven't had the time to study and evaluate yet but I hear SQL Server 2008
has new features to support GIS and Mapping. Can somebody provide me with
clarity, a synopsis and perhaps a URL which outlines and explains this
particular type of functionality?

Hi - I just created a job in SQL Server using Management Studio.  This is the
first time I've tried to build a job.  The job failed to execute at the
scheduled time and it fails when I start it manually.  Looking at the Job
History, the error message says, "Executed as user:NT ...

In a development environment,
developers are logged into CorpDomain on workstations joined to CorpDomain,
running Windows XP SP2,
they use Enterprise Manager to connect to SQL 2000 databases using SQL logins,

I have an expression that returns Invoice amounts for the current
month. I try to Sum this though and get the aggregate of mixed data
types error. I've tried to convert the dates, but then get the 'trying
to Sum on data types other than numeric'. Can anyone help me figure

Is there any way to compare two schemas and see the differences. Usual
story - client has changed their database structure, sent me  a new
copy and I need to know what's changed without looking at each
table...best I've come up with so far is to script each database and

Quest recommended that we should increase MemToLeave (currently -g512) to
1024MB. 64-bit is not an option in the short-term. I am sceptical here and I
need your input.
Windows 2003 Ent.

I just looked on my SQL server runing SBS 2003 and noticed that all my
database file are growing to huge sizes. When i investigate further i have an
.mdf and .ldf files tat are really big. How can I control these file.  I know
i can;t delete the .mdf file however does the .ldf ...