As per my manager's directive, I am attempting to forcibly shrink the log
files of multiple SQL Server 2005 databases with the following process:
USE [master]
GO

I came across this bug and could not find a solution, and I'm blocked.
Can anyone help ?
I have a table with TABLE CONSTRAINT, located at a SQL 2000 (SP3 or
SP4) server.

If we anticipate our load to double i.e twice the number of customers,etc..,
how do we go about planning if the db system today is adequate to meet that
demand ? What areas should we look at and what to consider to provide that
scale ?

Has anyone run into problems applying patches to SQL Server due to missing
patch uninstall files?
The patch uninstall files in C:\WINDOWS seem like they can be removed as
long as you no longer want to uninstall the patches.

hi, How do I isntall another isntance in existing sql server?
Thanks

I have created stored procs that update SQL and AS400 (Linked server)
tables. I want to wrap both updates in a transaction, however when I do, I
get the error
"The operation could not be performed because OLE DB provider "MSDASQL" for

I just posted a question about my Backup Plan 2005 SQL and I got very good
answers!, but now, I'm getting other problem, I'm checking the event viewer
and I see this error message : "BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG
is deprecated. The simple recovery model should be ...

I am trying to count entries into each column heading by zip code, but when I
run the script below I get the same count across all columns. Can someone
tell/show me how to make these unquie counts?
Thanks in advance.

To speed up the backup of a 23GB sql 2k db used for monthly archives I split
the original file
into 2 files in two separate file groups. I then moved all user tables and
indexes on the secondary

Good Day,
I am receiving the following errors in the event log and the SQL server 2005
error log:-
Date  30/01/2008 12:08:45

I'm trying to give access to users outside my firewall using an untrusted
sql login but for some reason I'm not able to do this.
I've opened up port 1433 on the firewall and pointed it to the server with
the same port number but I'm still not able to make a connection.

Can someone recomend a good website to read up on?

I'd like to know what happens to a log file when you back it up. I received
an error that my log file had grown too much & that I should back it up,
which I did & I no longer received the error.
But what happens when you simply back up a log file? Does it also truncate

I have a client who is having trouble modifying a SQL Server 2005 database
from Access 2003.  I think they are trying to change not only data, but the
DB fields as well (tables, etc.)

We are going to be changing our SQL Server's TCP/IP address. Is there
anything I need to do within SQL to make sure it works correctly?
The machine is not doing replication.
TIA - Jeff.