473,289 Members | 1,953 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

DTS import renames my SPs to previous names

I am using SQL Server 7 SP4.

I have created a blank database in which i am trying to import using DTS
wizard all tables/views/stored procedures without any DATA (records).

I keep getting different errors when importing the views and/or the SPs.
I've tried many things unsuccessfully.

Now even after the error msg of the DTS, i see some of the SPs under
their previous names.

In other words, let's say i have an SP called zprocDeleteProduct and
this SP was previously called procDeleteProduct.

When i check the 2nd database, i see the SP as zprocDeleteProduct
instead of seeing it as procDeleteProduct.

I have other SPs that are being imported with their previous names.

I have renamed these SPs from within Access XP. I don't create SPs
in SQL EM or SQL Query Analyzer.

How can i fix this problem? I don't want to import SPs under their previous
names.

Thank you
Jul 20 '05 #1
3 1873
Open query analyzer, and execute "sp_helptext zprocDeleteProduct" (or
procDeleteProduct). the output will be the text of the SP. The name
that appears immediatley after the "CREATE PROCEDURE" is the name your
SPs will be imported as. may also want to check your sysobjects table
to verify that names match.
FYI - MS Access isn't "a handy tool to administer SQL Server". Use
Query Analyzer as much as possible, use MMC (Enterprise Manager) as
SELDOM as possible, and use Access never. :-)
Alexey

"serge" <se****@nospam.ehmail.com> wrote in message news:<Jo*******************@news20.bellglobal.com> ...
I am using SQL Server 7 SP4.

I have created a blank database in which i am trying to import using DTS
wizard all tables/views/stored procedures without any DATA (records).

I keep getting different errors when importing the views and/or the SPs.
I've tried many things unsuccessfully.

Now even after the error msg of the DTS, i see some of the SPs under
their previous names.

In other words, let's say i have an SP called zprocDeleteProduct and
this SP was previously called procDeleteProduct.

When i check the 2nd database, i see the SP as zprocDeleteProduct
instead of seeing it as procDeleteProduct.

I have other SPs that are being imported with their previous names.

I have renamed these SPs from within Access XP. I don't create SPs
in SQL EM or SQL Query Analyzer.

How can i fix this problem? I don't want to import SPs under their previous
names.

Thank you

Jul 20 '05 #2
Oh, and by the way - if you are transferring objects without data -
use the "Generate SQL Script" wizard in Enterprise Manager, then run
that script in Query Analyzer on the target database. DTS is useful
for data migration, not object migration.
Alexey

"serge" <se****@nospam.ehmail.com> wrote in message news:<Jo*******************@news20.bellglobal.com> ...
I am using SQL Server 7 SP4.

I have created a blank database in which i am trying to import using DTS
wizard all tables/views/stored procedures without any DATA (records).

I keep getting different errors when importing the views and/or the SPs.
I've tried many things unsuccessfully.

Now even after the error msg of the DTS, i see some of the SPs under
their previous names.

In other words, let's say i have an SP called zprocDeleteProduct and
this SP was previously called procDeleteProduct.

When i check the 2nd database, i see the SP as zprocDeleteProduct
instead of seeing it as procDeleteProduct.

I have other SPs that are being imported with their previous names.

I have renamed these SPs from within Access XP. I don't create SPs
in SQL EM or SQL Query Analyzer.

How can i fix this problem? I don't want to import SPs under their previous
names.

Thank you

Jul 20 '05 #3
I will use the Query Analyzer to transfer the scripts instead of DTS.

Thanks Alexey
"Alexey Aksyonenko" <Al***************@coanetwork.com> wrote in message
news:14*************************@posting.google.co m...
Oh, and by the way - if you are transferring objects without data -
use the "Generate SQL Script" wizard in Enterprise Manager, then run
that script in Query Analyzer on the target database. DTS is useful
for data migration, not object migration.
Alexey

Jul 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Dan | last post by:
Could someone please help me with auto importing a series of data files into an Access table. I tried to follow code given below in a previous messagebut i'm getting error messages. Here's my...
15
by: daniroy | last post by:
Hello everybody, your help will be very very welcome on a very classic question... I have some Excell Macro background, a little bit of VBA knowledge. I import daily from Internet series of...
4
by: Jeremy Sanders | last post by:
Hi - Is it possible to override the import process so that if in my program I do import foo.bar Python will look for bar in a directory which isn't called foo? I want my module/program to...
11
by: kaisersose1995 | last post by:
Hi, I've got an import procedure working, using a standard import specification to import a .csv file into a temporary table. The problem i'm having is that i have 4 different sets of borrower...
1
by: crybaby | last post by:
when I do this in my python code and run it in windows xp, it creates ctemp/..../.../.../../ so on and creates file t. Not file starting with the name complist and ending with .txt...
4
by: George Sakkis | last post by:
Unless I missed it, PEP 328 doesn't mention anything about this. What's the reason for not allowing "from .relative.module import *' ? George
0
by: ilochab | last post by:
I'm writing a python package that will contain a logging service for twisted in python style. I'm using some modules I downloaded from a twisted trunk, that are not released with twisted but have...
0
by: Laszlo Nagy | last post by:
ohad frand wrote: So this is what you have: /1/tmp1.py /1/tmp2.py /2/tmp1.py /2/tmp2.py
0
by: Gabriel Genellina | last post by:
En Fri, 13 Jun 2008 22:38:24 -0300, Dan Yamins <dyamins@gmail.comescribió: I don't get *why* do you want to remove the 'archive' attribute before reloading the module. Just reload it *without*...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.