I have a sql server 2000 database configured on Full Recovery Model.  The
transaction log is growing quite big (26 GB currently), here is what I did
to shrink it and didn't work and hopeing that somenone will help me fixing
this issue:

Im in the process or setting up an active /passive cluster on SQL 2005
standrad.
Do i need to use AD or can i setup my SQL servers without it ?
Both are sharing a DB.

I am using SQL Server 2005.
I have the option to store a Tiff image inside SQL Server or In the file
system.
I have 15,000 images per day. I have the option of storing them in PCL

As above really. We have one application which uses SQL Server 2000 as a
backend. The people who used to maintain it left a long time ago, and I need
to configure BackupExec to backup the database but I do not have the SA
password. The local administrators group has been taken ...

I have a server with Windows 2003 Server 32 bit and 10 GB of memory (I
use physical address extension).
I would like to set my SQL Server 2005 server (standard edition) to
use 8GB, instead of the 1.6 max it uses today. I searched the posts

Anyone else getting this error when trying to install KB948109?
Error Number     : 1635
Error Description : Unable to install Windows Installer MSP file

I have SQL 2005 and wanted to know if there is an SQL backup called
"Maintenance Backup" other than the Maintenance Plan backup? Thanks.
-- Carolyn

Using VS2005, I can fill a DataSet with multiple DataTables. After this is
done, how would I make a call to that DataSet that can produce distinct
results without having to make a direct SQL call?
I don't even understand that question! So, let me explain further:

Hello...I know there have been several posts about this but I still can't
resolve my problem. I'm using sql 2005 xp_cmdshell statement to try and
access a mapped drive or to map a drive using net use in a query analyzer
session as follows:

using DTS to output scheduled query to csv ?
Hi,
I need to run a bunch of queries out with office hours when the system is
quiet. Im using SQL agent to scheudule a query but i cannot seem to output

I'm in the toner cartridge recycling/manufacturing business and I'm building
a software application to control our inventory. I'm having this problem and
I've tried for several months to solve it without success.
Here are my tables:

I'm trying to create pivot, my data are area, sub area, member code.
On Pivot/Crosstab data area i want to calculate how many member that
access in sub area, and how many member that access in area, where as
on the raw data it self my member has many record on each area and sub

Hi, do you know any free SQL Server query management (query analyzer) that
have code-complete, shows the tables, fields, etc...
Version 2000 or 2005 !
Thank you very much!

We've been dealing with this issue for 3 weeks now, and i've gotten tired,
frustrated, and as some of you may have noticed: a little cranky.
We have an application that we wrote. It runs fine on our development 2005
machine, it runs fine on their test 2005 server, but when they ...

I am try to exec the folowing statement i got error, syntax error near
go......
DECLARE @DBName as VARCHAR(100)
declare @SQL1 varchar(800)