Need to change a database collation.

Hi, i have a server running sql2000 sp3 on win2000 server.
The server has configured the sql_latin1_general_cp1_ci_as collation,
but on this server a user create a database that has the
Modern_spanish_ci_as
collation.
Every time we make a query on that database from a database that has the
server collation it reports problems with the collation.
We want to change the db collation, but we dont know what effect does
it will cause on the data and the application.
What do you recommend to us to change the collation?
thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
MariaGuzman wrote:
> Hi, i have a server running sql2000 sp3 on win2000 server.
> The server has configured the sql_latin1_general_cp1_ci_as collation,
> but on this server a user create a database that has the
> Modern_spanish_ci_as
> collation.
> Every time we make a query on that database from a database that has
> the server collation it reports problems with the collation.
> We want to change the db collation, but we dont know what effect does
> it will cause on the data and the application.
> What do you recommend to us to change the collation?
> thanks a lot for your help.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
You can use the COLLATE clause on an ALTER DATABASE to change the
default collation of the database:
ALTER DATABASE MyDatabase COLLATE French_CI_AS
However, altering the default collation of a database does not change
the collations of the columns in any existing user-defined tables.
You'll need to change each table with ALTER TABLE.
There are restrictions:
You cannot alter the collation of a column that is currently referenced
by:
a.. A computed column.
b.. An index.
c.. Distribution statistics, either generated automatically or by the
CREATE STATISTICS statement.
d.. A CHECK constraint.
e.. A FOREIGN KEY constraint.
If the database is small , you might have better luck creating a new
database, migrating the objects over, renaming the old database and then
renaming the new one (keep the old one around until you are sure the
migration was done correctly).
David Gugick
Imceda Software
www.imceda.com

Need to change a database collation.

Hi, i have a server running sql2000 sp3 on win2000 server.
The server has configured the sql_latin1_general_cp1_ci_as collation,
but on this server a user create a database that has the
Modern_spanish_ci_as
collation.
Every time we make a query on that database from a database that has the
server collation it reports problems with the collation.
We want to change the db collation, but we don´t know what effect does
it will cause on the data and the application.
What do you recommend to us to change the collation'
thanks a lot for your help.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!MariaGuzman wrote:
> Hi, i have a server running sql2000 sp3 on win2000 server.
> The server has configured the sql_latin1_general_cp1_ci_as collation,
> but on this server a user create a database that has the
> Modern_spanish_ci_as
> collation.
> Every time we make a query on that database from a database that has
> the server collation it reports problems with the collation.
> We want to change the db collation, but we don´t know what effect does
> it will cause on the data and the application.
> What do you recommend to us to change the collation'
> thanks a lot for your help.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
You can use the COLLATE clause on an ALTER DATABASE to change the
default collation of the database:
ALTER DATABASE MyDatabase COLLATE French_CI_AS
However, altering the default collation of a database does not change
the collations of the columns in any existing user-defined tables.
You'll need to change each table with ALTER TABLE.
There are restrictions:
You cannot alter the collation of a column that is currently referenced
by:
a.. A computed column.
b.. An index.
c.. Distribution statistics, either generated automatically or by the
CREATE STATISTICS statement.
d.. A CHECK constraint.
e.. A FOREIGN KEY constraint.
If the database is small , you might have better luck creating a new
database, migrating the objects over, renaming the old database and then
renaming the new one (keep the old one around until you are sure the
migration was done correctly).
--
David Gugick
Imceda Software
www.imceda.comsql

Need to change a database collation.

Hi, i have a server running sql2000 sp3 on win2000 server.
The server has configured the sql_latin1_general_cp1_ci_as collation,
but on this server a user create a database that has the
Modern_spanish_ci_as
collation.
Every time we make a query on that database from a database that has the
server collation it reports problems with the collation.
We want to change the db collation, but we dont know what effect does
it will cause on the data and the application.
What do you recommend to us to change the collation'
thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!MariaGuzman wrote:
> Hi, i have a server running sql2000 sp3 on win2000 server.
> The server has configured the sql_latin1_general_cp1_ci_as collation,
> but on this server a user create a database that has the
> Modern_spanish_ci_as
> collation.
> Every time we make a query on that database from a database that has
> the server collation it reports problems with the collation.
> We want to change the db collation, but we dont know what effect does
> it will cause on the data and the application.
> What do you recommend to us to change the collation'
> thanks a lot for your help.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
You can use the COLLATE clause on an ALTER DATABASE to change the
default collation of the database:
ALTER DATABASE MyDatabase COLLATE French_CI_AS
However, altering the default collation of a database does not change
the collations of the columns in any existing user-defined tables.
You'll need to change each table with ALTER TABLE.
There are restrictions:
You cannot alter the collation of a column that is currently referenced
by:
a.. A computed column.
b.. An index.
c.. Distribution statistics, either generated automatically or by the
CREATE STATISTICS statement.
d.. A CHECK constraint.
e.. A FOREIGN KEY constraint.
If the database is small , you might have better luck creating a new
database, migrating the objects over, renaming the old database and then
renaming the new one (keep the old one around until you are sure the
migration was done correctly).
David Gugick
Imceda Software
www.imceda.com

Need to add additional NIC to SQL cluster - to enable teaming.

Hi
I have 2 questions, but related!
We currently have a Windows 2000 Adv server running SQL Ent 2000 as a 2 node
cluster.
Each node currently has 2 NICs installed, one NIC for the local heartbeat
and the other for the LAN connection.
We now need to add another NIC to each cluster node for failover resillience
on the LAN connection.
The idea is to add the extra NIC, so that we can implement teaming on 2
NICs.
1.What needs to be done to the cluster in order to achieve this and ensure
that the cluster still functions as per normal.
2. The installed NIC has 2 ports, so i assume that additional NIC purchased
may be different, my guess is that teaming different type NIC cards is not a
good idea, therefore i would like to reconfigure for the teaming to be on
the NIC with the 2 ports and the heartbeat on the newly purchased NIC. - Is
this a big job- what needs to be carried out in order to achive this!!!
Cheers Ray
Answers below...
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
<Ray> wrote in message news:eWEmvKBGFHA.2932@.TK2MSFTNGP10.phx.gbl...
> Hi
> I have 2 questions, but related!
> We currently have a Windows 2000 Adv server running SQL Ent 2000 as a 2
> node
> cluster.
> Each node currently has 2 NICs installed, one NIC for the local heartbeat
> and the other for the LAN connection.
> We now need to add another NIC to each cluster node for failover
> resillience
> on the LAN connection.
> The idea is to add the extra NIC, so that we can implement teaming on 2
> NICs.
> 1.What needs to be done to the cluster in order to achieve this and ensure
> that the cluster still functions as per normal.
A properly configured TEAM is not seen by the cluster. In other words, its
seamless. It just works like a single NIC and the Cluster is never the wiser
Cool huh?

> 2. The installed NIC has 2 ports, so i assume that additional NIC
> purchased
> may be different, my guess is that teaming different type NIC cards is not
> a
> good idea, therefore i would like to reconfigure for the teaming to be on
> the NIC with the 2 ports and the heartbeat on the newly purchased NIC. -
> Is
> this a big job- what needs to be carried out in order to achive this!!!
>
Take everything offline - cluster services and all resources. Change the
IP's on the NIC - on each node. Do a few ping tests to verify things are
working. Start the cluster service and use "." to start the Cluster
Administrator.
Use these for information:
http://support.microsoft.com/default...b;en-us;244980
http://support.microsoft.com/default...b;en-us;230356
Good luck, its really not that bad.

> Cheers Ray

Need suggestions on best way

I have several workstations that are running a custom app
using MSDE2000. I need the PCs to replicate with a SQL
server via modem to pick up subscription and exchange
data. What is the best way to accomplish this? Currently
I am using MOBSYNC and scheduleing the event. It has been
unreliable.
connect to your subscriber, go to the management folder and look in the jobs
there. You should find your merge agent there. You can examine its history
there.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Robert" <anonymous@.discussions.microsoft.com> wrote in message
news:810401c495a5$a8170580$a501280a@.phx.gbl...[vbcol=seagreen]
> Here is alittle background. The PCs are WINXP Pro. The
> PCs are schedule within MOBSYNC to once a week dial up a
> RAS server in Dallas, authenicate, and then replicate. My
> issues are as follow. I use the same username and
> password to authenicate on every PC. Each PC is scheduled
> to this function when no other is. Every 30 minutes
> starting at night across the US, a different PC is set to
> replicate. Some PCs indicate that they ran the process
> when looking at MOBSYNC, but the server says it didn't.
> It is difficult to check the RAS server to verifiy it
> connected because of the userid being the same and time
> zone differences.

Need suggestion for BACKUP and Database files on RAID 5 configuration....!

I have RAID 5 with 1 logical drive with 2 partitions with SQL Server 2000 running on SERVER.

what best model for data storage and backup would some experienced one suggest:

basically I want to put Master, Database files and T-Log files away from each other.

-- Data files
-- Log files
-- Master database.

Thanks,

Fahim.

1.For data storage you can put in first partition the SQL software and in second the data, depends on the size of each ;in fact doesn't matter the configuration of data because the availability is supplied by RAID 5, more for same reason you can put all user and master databases in same place !

2.For backup you must storage the data out of this server using tape cassetes or a hdd in the network.

Need SQL for distinguishing SQL 2005 from 2000 and 7.0

I want to use 'ALTER LOGIN' if the SQL Server is running 2005, but have to use sp_password if it's SQL 2000 or 7.0

Currently I use the following SQL to determine the version:

int nVersion = 7;
// this will throw an exception on 7.0
rs = con.execute("SELECT SERVERPROPERTY('productversion')");
if (rs != null && !rs.getEOF())
{
strVersion = rs.getField(0).getString();
if (strVersion == null)
strVersion = "7.";
strVersion = strVersion.trim();
int nIdx = strVersion.indexOf(".");
strVersion = strVersion.substring(0, nIdx);
nVersion = Integer.parseInt(strVersion);
}

Can anyone suggest a cleaner way?

Hi,

if you have the capabilities to use SQLDMO, this would be a snippet for it:

Set oSQLObj = CreateObject("SQLDMO.SQLServer")
version = oSQLObj.PingSQLServerVersion(sServer)

Otherwise if you have SQL Server 2005 and the SMO dll use can also use SQLSMO from .NET.

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de

Need SQL consultant/troubleshooter

A site is having seemingly random lockups and slowdowns on roughly 8
PC's running a Windows app client talking to a SQL Server 2000 server.
I am trying to find a qualified SQL consultant in the Eastern North
Carolina or Tidewater, VA area to take alook and provide guidance as
to where the problem lies.
Where should I look for such a consultant?
Thanks
www.icca.org
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
"Doug Lucy" <dlucy@.mindspring.com> wrote in message
news:vhc6b0l5fm01q8elph279t4c772algogtq@.4ax.com...
> A site is having seemingly random lockups and slowdowns on roughly 8
> PC's running a Windows app client talking to a SQL Server 2000 server.
> I am trying to find a qualified SQL consultant in the Eastern North
> Carolina or Tidewater, VA area to take alook and provide guidance as
> to where the problem lies.
> Where should I look for such a consultant?
> Thanks

Need permission to use bulk load statement in SQL 2005?

Hello,
I've developed a tool in Visual Basic.NET and have a local instance of SQL
Server 2005 running. This tool loads a lot of data into my database. It runs
locally just fine, but when I set it to load the data into the remote
(webhosting) database, I get an error: "You do not have permission to use th
e
bulk load statement."
Can anyone tell me what kind of permission that I need to use this
statement? Using a simple Insert state would take weeks and weeks to perform
the operation. The remote database at the hosting company has a bunch of SQL
Server 2005 databases on it. I'm sure that they won't want to give me admin
rights. Is there anyway that they can give us specifically rights to use a
bulk load statement without giving us access to all the other databases on
the server?
ThanksAdd the login to the bulkadmin fixed server role.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"John Riddle" <JohnRiddle@.discussions.microsoft.com> wrote in message
news:256E7437-06C4-4392-A5DA-C9DF50F70A58@.microsoft.com...
Hello,
I've developed a tool in Visual Basic.NET and have a local instance of SQL
Server 2005 running. This tool loads a lot of data into my database. It runs
locally just fine, but when I set it to load the data into the remote
(webhosting) database, I get an error: "You do not have permission to use
the
bulk load statement."
Can anyone tell me what kind of permission that I need to use this
statement? Using a simple Insert state would take weeks and weeks to perform
the operation. The remote database at the hosting company has a bunch of SQL
Server 2005 databases on it. I'm sure that they won't want to give me admin
rights. Is there anyway that they can give us specifically rights to use a
bulk load statement without giving us access to all the other databases on
the server?
Thanks

Need list of known bugs when running SQL Server Reporting Services

Hi,
We are trying to document a list of known bugs when running SQL Server
Reporting Services on Windows 2000 server OS. If anyone can give us any
pointers on where we can get such a list please let us know.
mail me your reply at gaurav_maheshwari01@.infosys.com
Regards,
Gaurav MaheshwariI am not aware of a published list. Plus your request is pretty silly. Are
you talking RS 2000 or RS 2005. If RS 2000 with what service pack.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Gaurav Maheshwari" <Gaurav Maheshwari@.discussions.microsoft.com> wrote in
message news:5F6ABB2E-7A07-4C60-A5C3-5D137EECB26E@.microsoft.com...
> Hi,
> We are trying to document a list of known bugs when running SQL Server
> Reporting Services on Windows 2000 server OS. If anyone can give us any
> pointers on where we can get such a list please let us know.
> mail me your reply at gaurav_maheshwari01@.infosys.com
> Regards,
> Gaurav Maheshwari
>|||Hi Bruce,
Thanks for your reply. We are using RS 2000 along with SP4. We want to use
it in Windows 2000 server environmant. For that we need the list on Known
bugs.
Gaurav Maheshwari
SE, Infosys Tech. Ltd.
"Bruce L-C [MVP]" न� लि�ा:
> I am not aware of a published list. Plus your request is pretty silly. Are
> you talking RS 2000 or RS 2005. If RS 2000 with what service pack.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Gaurav Maheshwari" <Gaurav Maheshwari@.discussions.microsoft.com> wrote in
> message news:5F6ABB2E-7A07-4C60-A5C3-5D137EECB26E@.microsoft.com...
> >
> > Hi,
> >
> > We are trying to document a list of known bugs when running SQL Server
> > Reporting Services on Windows 2000 server OS. If anyone can give us any
> > pointers on where we can get such a list please let us know.
> > mail me your reply at gaurav_maheshwari01@.infosys.com
> > Regards,
> > Gaurav Maheshwari
> >
>
>|||Gaurav,
no software vendor anywhere in the world publishes anything like a
reasonable list of known bugs to users of their software....the
closest you come to this is known fixes...it is not in the software
vendors interest to publish such things...
Peter|||Hi Gaurav,
As of Now there is no sp4 for sql rs2000. only sp2 is available for
rs2000.
Peter Nolan wrote:
> Gaurav,
> no software vendor anywhere in the world publishes anything like a
> reasonable list of known bugs to users of their software....the
> closest you come to this is known fixes...it is not in the software
> vendors interest to publish such things...
> Peter|||Hi Gaurav,
As of Now there is no sp4 for sql rs2000. only sp2 is available for
rs2000.
Peter Nolan wrote:
> Gaurav,
> no software vendor anywhere in the world publishes anything like a
> reasonable list of known bugs to users of their software....the
> closest you come to this is known fixes...it is not in the software
> vendors interest to publish such things...
> Peter

Need input...Creating Indexes on 37 million row table...

Hello, all. Looking for suggestions, input,
recommendations, etc. I'm running SQL 2K.
I have a table with 37 million rows that I need to create
about 5 new indexes on. The columns already exist. The
db is used for datawarehousing, and contains static
data...the only update is a monthly insert of about 300K
records. Other than that, users only query it all day.
The db is also running in Simple Recovery mode (no need to
log any transactions).
Realizing this will take a LONG time to run, I'd like to
find out the best/most efficient way/with minimum downtime
to get this done. Luckily, I have the luxury of
restricted access to the db while I perform this, if need
be.
So, I'd like to hear from the gurus on how to do this.
Thanks
RozThere really is no faster way to create an index other than to make sure
your log file (even in simple mode) is on a separate raid array than the
data or tempdb. If you have tempdb on a separate array than the data you
can specify the sort in tempdb option to speed it up some.
Andrew J. Kelly SQL MVP
"Roz" <anonymous@.discussions.microsoft.com> wrote in message
news:2746101c4636e$82f9ae10$a501280a@.phx
.gbl...
> Hello, all. Looking for suggestions, input,
> recommendations, etc. I'm running SQL 2K.
> I have a table with 37 million rows that I need to create
> about 5 new indexes on. The columns already exist. The
> db is used for datawarehousing, and contains static
> data...the only update is a monthly insert of about 300K
> records. Other than that, users only query it all day.
> The db is also running in Simple Recovery mode (no need to
> log any transactions).
> Realizing this will take a LONG time to run, I'd like to
> find out the best/most efficient way/with minimum downtime
> to get this done. Luckily, I have the luxury of
> restricted access to the db while I perform this, if need
> be.
> So, I'd like to hear from the gurus on how to do this.
> Thanks
> Roz

Need input...Creating Indexes on 37 million row table...

Hello, all. Looking for suggestions, input,
recommendations, etc. I'm running SQL 2K.
I have a table with 37 million rows that I need to create
about 5 new indexes on. The columns already exist. The
db is used for datawarehousing, and contains static
data...the only update is a monthly insert of about 300K
records. Other than that, users only query it all day.
The db is also running in Simple Recovery mode (no need to
log any transactions).
Realizing this will take a LONG time to run, I'd like to
find out the best/most efficient way/with minimum downtime
to get this done. Luckily, I have the luxury of
restricted access to the db while I perform this, if need
be.
So, I'd like to hear from the gurus on how to do this.
Thanks
Roz
There really is no faster way to create an index other than to make sure
your log file (even in simple mode) is on a separate raid array than the
data or tempdb. If you have tempdb on a separate array than the data you
can specify the sort in tempdb option to speed it up some.
Andrew J. Kelly SQL MVP
"Roz" <anonymous@.discussions.microsoft.com> wrote in message
news:2746101c4636e$82f9ae10$a501280a@.phx.gbl...
> Hello, all. Looking for suggestions, input,
> recommendations, etc. I'm running SQL 2K.
> I have a table with 37 million rows that I need to create
> about 5 new indexes on. The columns already exist. The
> db is used for datawarehousing, and contains static
> data...the only update is a monthly insert of about 300K
> records. Other than that, users only query it all day.
> The db is also running in Simple Recovery mode (no need to
> log any transactions).
> Realizing this will take a LONG time to run, I'd like to
> find out the best/most efficient way/with minimum downtime
> to get this done. Luckily, I have the luxury of
> restricted access to the db while I perform this, if need
> be.
> So, I'd like to hear from the gurus on how to do this.
> Thanks
> Roz

Need input...Creating Indexes on 37 million row table...

Hello, all. Looking for suggestions, input,
recommendations, etc. I'm running SQL 2K.
I have a table with 37 million rows that I need to create
about 5 new indexes on. The columns already exist. The
db is used for datawarehousing, and contains static
data...the only update is a monthly insert of about 300K
records. Other than that, users only query it all day.
The db is also running in Simple Recovery mode (no need to
log any transactions).
Realizing this will take a LONG time to run, I'd like to
find out the best/most efficient way/with minimum downtime
to get this done. Luckily, I have the luxury of
restricted access to the db while I perform this, if need
be.
So, I'd like to hear from the gurus on how to do this.
Thanks
RozThere really is no faster way to create an index other than to make sure
your log file (even in simple mode) is on a separate raid array than the
data or tempdb. If you have tempdb on a separate array than the data you
can specify the sort in tempdb option to speed it up some.
--
Andrew J. Kelly SQL MVP
"Roz" <anonymous@.discussions.microsoft.com> wrote in message
news:2746101c4636e$82f9ae10$a501280a@.phx.gbl...
> Hello, all. Looking for suggestions, input,
> recommendations, etc. I'm running SQL 2K.
> I have a table with 37 million rows that I need to create
> about 5 new indexes on. The columns already exist. The
> db is used for datawarehousing, and contains static
> data...the only update is a monthly insert of about 300K
> records. Other than that, users only query it all day.
> The db is also running in Simple Recovery mode (no need to
> log any transactions).
> Realizing this will take a LONG time to run, I'd like to
> find out the best/most efficient way/with minimum downtime
> to get this done. Luckily, I have the luxury of
> restricted access to the db while I perform this, if need
> be.
> So, I'd like to hear from the gurus on how to do this.
> Thanks
> Roz

Need info to move customers off of SQL 6.5

Good Day all,
I have several applications still running on SQL Server 6.5. I have been lo
oking for white papers about any issues with 6.5, but am unable to find anyt
hing. Can anyone affer assistance? I am looking for anything that might be
outstanding as an issue wi
th security or something high profile like that. Because it is now unsuppor
ted, I would like to find as much information as possible to get people move
d over to a newer platform.
Thanks for the help.Google group archives may be worth a look.
For upgrade information you can refer to:
http://www.microsoft.com/technet/pr...oy/sqlugrd.mspx
For any outstading issues you may want to refer to MSKB at:
http://support.microsoft.com
There are some website which still maintains some 6.5 info like:
http://www.mssqlserver.com/faq/
http://www.sqlserverfaq.com/
Anith

Need Help, DTS is Running extremely Slow!

Hi guys.

I have a DTS package ON SQL 2000 which transfer data from AS400 to SQL 2000 using an ODBC Client Access 5.1 (The DSN was configured by a sysdmin on the AS400 so it is configured properly).
When i execute the package manualy (by right click and "execute package") the package runns fine and ruterns data in no time (Eproximatly 30000 rows in 15 sec).

The problem starts when a job executes the same packagee!!!
When i start the job, the DTS package is running Very Very Slow!!!!
sometime it takes Hours to return a few rows! and it seems that it is stuck.

The SQLAgent is running as a NT Account with Administrator rights, and has full access to the AS400!! so the problem is not the Agent.

by monitoring the AS400, i have noticed that the job/DTS is retreaving the first fetch quickly , and then it is in a waiting status

i have tried everything and cant seem to get this problem fixed

Does anyone know what could be the problem?
I Need Help Quick!!!
Thank You

GilTo maximize CPU resources, you can define a CPU idle condition for SQL Server Agent. SQL Server Agent uses the CPU idle condition setting to determine the most advantageous time to execute jobs.

For example, you can schedule a daily backup job to occur during CPU idle time and slow production periods.

Before you define jobs to execute during CPU idle time, determine how much CPU the job requires. You can use SQL Server Profiler or Windows NT Performance Monitor to monitor server traffic and collect statistics. You can use the information you gather to set the CPU idle time percentage.

Define the CPU idle condition as a percentage below which the average CPU usage must remain for a specified time. Next, set the amount of time. When this time has been exceeded, SQL Server Agent starts all jobs that have a CPU idle time schedule.

But test it before deploying on production.|||Thnx for replying Satya,

I am afraid this ahs nothing to do with CPU resources. Even when i start the job manualy when there is no activity at all an the server the DTS runs Very Very Slow.

I am prety sure that there is somthing else to be done , allthow i will try your advise.

Any suggestions?|||The are a number of thing you can do. It's specific to your job. First of all who has control. AS400 or the database(SQL). I don't know of a DTS package in AS400. So start there, next, you might want to look at the parameters manually vs job. Are there any environmental issues to look at. Such as: numbers of records to commit, indexes, maintenance and backups, buffers size, Look it up on books online SQL Server.|||AS400?

You mean DB2, no?

Have the DB2 dba set up an unload then copy the data to your box...

Then bcp the data in

I know that doesn't address your problem...

What's the execution step in the job look like?

One difference in your methods is the context of which ID is being used.

When you execute it from EM, it's under the context of your id, AND your location.

From the job, it's under the context of the agent AND the server drive mappings..

I'm guessing it's a network issue...

Did the job ever finish?|||Thnx alll 4 replying,

But i am afriad that that is not the problem...

I think i have solved it though...

The Client Access has an option to translate data by a DLL.
it was using one...dont know its name.

removing this dll solved the problem and the job is executing fine now.

thank you all for helping

Gil

Need help! Used Space in dB and Tran files

I have a database about 39GB in size and is running out of allocated space. In the Enterprise Manager the properties for this dB, show that there is 0.00MB space available. I need to increase the size of the dB.

What I need to find out is, which file group is full so I can expand the appropriate file group instead of expanding all the filegroups. Also, is there a way to find the space usage of each file in the file group and also the Transaction log?

db Size 39GB
14 File Groups
17 database files (mdf & ndf)
2 Transaction Log files
180 Tables

I am aware of the sp_spaceused, but the information it furnishes is not enough for me to make a decision.

Need help urgently!!!!check this query out and see if this will be of any help:

select [Allocated_Size_MB]=size*8/1024, [Max_Size_MB]=maxsize*8/1024, name from sysfiles|||Thanks for your reply. The results from the query give me the allocated size.
How can I find the "used" space (or free/available space) in this allocated space?