Hi, I need a tools that help me to find error in table definitions and
stored proc, on an existing sql db.
Thanks a lot.
P.

[DBNETLIB][ConnectionWrite(send())]General network error.
This used to sporadically happen when DTS'ing data from a local sql server
to our production server.  Now it's consistent.  Local SQL Server is running
SQL Server 2000 SP4 and Production Server is running 2000 SP4.  Now, ...

I've just developed an extended stored procedure in .net framework.
It's being added to the SQL Server 2005, and it's executed properly.
Now, I've got a user defined function as follows:
CREATE FUNCTION [dbo].[GetItems]()

SQL Server 2005
We're trying to implement the application role for Microsoft
Forecasting.  We've gone through the steps, but it isn't connecting.
We can connect easily when using a network login which has rights to

I have an issue where SQL 2005 server was renamed from Windows (i.e. the
server name was changed in Windows),
Then I renamed the SQL server instance to be as the same as the new Windows
name (using SP_DropServer, SP_Addserver ); now, all the maintenance plan

How can i install an SQL Serevr 2005 Standard Version on an hosted server
(without CD/DVD Access) ?
Thanks,
James

I have a problem to migrate my databases from my old computer to my new one.
On both computers I am using MS SQL Server 2005.
To migrate the databases I performed with the Management Studio the
following steps:

I have a windows 2003 server (4gb ram) that is already used to host an
exchange server, lots of files, and it is also a domain controller.
This is used in a small company of 20-30 people. Is it crazy to host both a
sql 2000 and sql 2005 instance on that same server? These will run ...

i have a database that has a datafile of 40+GB and  a log file of 51GB. i
don't need the log file.  i tried to do a shrinkfile command and it doesn't
seem to make the file smaller.  the command i'm running is:
dbcc shrinkfile ('MA_Log', 1000, TRUNCATEONLY)

Just a quick one.
Is it possible for a Full backup job to execute when the particular database
in the status of "Synchronized/ Restoring".
Please let me know if you don't understand what I mean and need further

A log file for one of my databases is very big (over 100GB). This is
very unusual for this database - most of the time it is under 10GB.
I backup database and tried to shrink the log file - didn't work.
I backuped log file with Truncate_Only (didn't need sequence to be

I am trying to automate a scheduled restore of databases from several SQL
Servers to my local development SQL Server (all SQL 2000 STD & Dev.). I can
successfully create the RESTORE scripts and run them directly in QA. However,
I want the scripts stored in a table on the local ...

What would be to the best/easiest technology to use:
We have two SQL 2005 Workgroup servers. One has a heavily used database for
the line of business application. We want the other to have a near to real
time (15 to 30 minutes difference would be ok) copy of the database which is

The database scheme consists of four relations:
Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)

Is there any document available to steps thru how to migrate the current DTS
packages in SQL 2000  to Integration Services in SQL 2005?