Environment discrepencies concerning stored procedures & data types

Im trying to move a database from a NT4 SQL2K server over to a WIN2K SQL2K box.

When i copy the stored procedures over via a generated script, 1 procedure fails to create itself, and the error i get is:

The text, ntext, and image data types are invalid in this subquery or aggregate

the error is supposedly the top line here:

SELECT *, 'cms_Document_Contents_ID'='', 'cms_Language_ID'='', 'Title'='', 'XML'='', 'search_text'='',
'File_XML'=(SELECT TOP 1 File_XML FROM cms_Document_Contents d
INNER JOIN cms_Document_Sections e ON d.cms_Document_Id=e.cms_Document_Id
WHERE d.cms_Language_ID=9 AND e.cms_Document_Section_ID=@.DocumentSectionId) ,
c.active, c.sequence, c.cms_Document_Section_ID, c.cms_Section_ID, c.cms_Document_Type_ID
FROM cms_Documents a
INNER JOIN cms_Document_Sections c ON a.cms_Document_ID=c.cms_Document_ID
WHERE c.cms_Document_Section_ID=@.DocumentSectionId
END

GO

wtf is going on? this works fine on the old server. i tried running it back there and it just complains that the stored procedure already exists.
i am not familiar with SQL, this is someone elses code, i dont understand the error and NEED all the help i can get.Somehow you got single quotes stuck around your column names.

Select 'cms_Document_Contents_ID'=''
...makes no sense. I assume the procedure is createing an empty column that will be populated later. Try this and see if you get the same error:

SELECT *,
cms_Document_Contents_ID='',
cms_Language_ID='',
Title='',
XML='',
search_text='',
File_XML= (SELECT TOP 1 File_XML FROM cms_Document_Contents d
INNER JOIN cms_Document_Sections e ON d.cms_Document_Id = e.cms_Document_Id WHERE d.cms_Language_ID=9 AND e.cms_Document_Section_ID=@.DocumentSectionId),
c.active,
c.sequence,
c.cms_Document_Section_ID,
c.cms_Section_ID,
c.cms_Document_Type_ID
FROM cms_Documents a
INNER JOIN cms_Document_Sections c ON a.cms_Document_ID=c.cms_Document_ID
WHERE c.cms_Document_Section_ID=@.DocumentSectionId

blindman|||Stop the SQL Server, exit the Service Manager, copy the data and log files (C:\Program Files\Microsoft SQL Server\MSSQL\Data\MyDB_Data.mdf, & C:\Program Files\Microsoft SQL Server\MSSQL\Data\MyDB_Log.ldf on my machine respectivley) to your destination server, on that machine you can import (attatch) the data and log files into SQL Server with the following command in the query analyzer (substituing MyDB and the 2 paths with your equivalents):

sp_attatch_db @.dbname = 'MyDB',
@.filename1 = 'c:\path\to\datafilename.mdf',
@.filename2 = 'c:\path\to\datafilename.mdf'

if that is successful id say your home free (refresh your database list), if not, post on this forum, they can help...

.^sUbMSg-\/.

see: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp for info on this stored procedure.

ps: f*ck that DTS export b*llocks im sticking with the raw data files.

The text, ntext, and image data types are invalid in this subquery or aggregate expression.

export copy move transfer transport duplicate mirror import mdf sql database db attach stored procedure retain keep error 2000 7 6.5 8 backup restore detatch

Enumerating publications on a server via RMO

Hello everyone,
I'm looking to get a list of publications on a given SQL Server
instance via RMO. I can't seem to find any information on how to do
this. What I need is, given a server name or existing connection, find
out if the machine is a publisher and if so, get a list of its
publications. Currently I am able to query the publication and
articles, but I have to specify the publication/article name in
advance. I need the ability to discover them at runtime.
Any help or nudge in the right direction would be appreciated,
Regards,
Anthony
Hello everyone,
I was able to find something in the Microsoft.SqlServer.Replication
namespace that does exactly what I want; however, it comes with the
following disclaimer from Microsoft : "This class supports the SQL
Server 2005 infrastructure and is not intended to be used directly
from your code." This leads me to believe that there's another way of
enumerating publications on a SQL Server 2005 instance via RMO, but
for now I'll post what I found because... well, it works for me. The
following is sample code to iterate through all the publications on a
given SQL Server (2005?) instance and enumerate through the articles
within, outputing to the richtextbox rtbFilter :
**referencing :
[C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies
\Microsoft.SqlServer.ConnectionInfo.dllusing
Microsoft.SqlServer.Management.Common]
[C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies
\Microsoft.SqlServer.Rmo.dll]
using Microsoft.SqlServer.Replication;
...
ServerConnection conn = new ServerConnection("sql server name", "user
name", "user password");
try
{
conn.Connect();
ReplicationServer rs = new ReplicationServer(conn);
ArrayList al = rs.EnumLightPublications("name of the database being
replicated", 3, true, true); // 1 = trans, 2 = merge, 3 = all. I
*presume* these are correct (tested through quick trial and error,
didn't find the proper enum equivalent)
foreach (LightPublication lp in al)
{
rtbFilter.AppendText("Name:" + lp.Name + "\r\n");
rtbFilter.AppendText("Description:" + lp.Description + "\r\n");
rtbFilter.AppendText("Type:" + lp.Type.ToString() + "\r\n");
rtbFilter.AppendText("PublisherName:" + lp.PublisherName + "\r\n");
rtbFilter.AppendText("PublisherType:" + lp.PublisherType + "\r\n");
rtbFilter.AppendText("PublicationDBName:" + lp.PublicationDBName +
"\r\n");
rtbFilter.AppendText("\r\n");
TransPublication tp = new TransPublication(lp.Name,
lp.PublicationDBName, conn);
foreach (TransArticle ta in tp.EnumArticles())
{
rtbFilter.AppendText("\tName:" + ta.Name + "\r\n");
rtbFilter.AppendText("\tDescription:" + ta.Description + "\r\n");
rtbFilter.AppendText("\tType:" + ta.Type.ToString() + "\r\n");
rtbFilter.AppendText("\tFilterProcOwner:" + ta.FilterProcOwner + "\r
\n");
rtbFilter.AppendText("\tFilterProcName:" + ta.FilterProcName + "\r
\n");
rtbFilter.AppendText("\tFilterClause:" + ta.FilterClause + "\r\n");
}
}
}
catch(Exception ex)
{
Console.Out.WriteLine(ex.Message);
}
finally
{
conn.Disconnect();
}
Hope this helps,
Anthony

Enterprise Manager Shortcuts for Remote Servers

Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
--
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:
> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
--
Thanks
Yogish

Enterprise Manager Shortcuts for Remote Servers

Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
Julian
Hi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish to
connect to.
Thanks
Yogish
|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:

> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish to
> connect to.
> --
> Thanks
> Yogish
|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish

Enterprise Manager Shortcuts for Remote Servers

Hello and thank you in advance.
I have multiple databases on a single remote MSSQL server (from my ISP). I
can only access them via Enterprise Manager. My quandary is that every time
I log in, I have to click the server name, then wait for the database to
load, then sift through this enormous list to find the database I am seeking
.
I'd like to have shortcuts to each specific database so I can connect and
get to the tables with one click.
Anyone know how to do this?
Thanks,
JulianHi Julian,
Do you have restriction for using Query Analyzer also? If not, while
configuring the client ODBC, you can specify the default database you wish t
o
connect to.
Thanks
Yogish|||Thank you for your reply. I don't think I have a restriction for Query
Analyzer, but I am a novice at best and am only barely qualified to use
Enterprise Manager.
Does this mean I'd have to switch to Query Analyzer or are you suggesting
that I can use Query Analyzer to store my default database and somehow tie
that back to using Enterprise Manager? It puzzles me why Enterprise Manager
doesn't allow you to store a default database for each SQL Server
Registration.
"Yogish" wrote:

> Hi Julian,
> Do you have restriction for using Query Analyzer also? If not, while
> configuring the client ODBC, you can specify the default database you wish
to
> connect to.
> --
> Thanks
> Yogish|||Hi Julian,
You can do lot of operations with Query Analyzer (QA). If you are using SQL
Server 2000 client, you can use Object Browser to access all the database
objects, provided you have the permission.
Check out Books online.
Thanks
Yogish

Enterprise Manager Database Diagram Wizard

I am creating a Table Diagram via Enterprise Manager and the Database Diagra
m
Wizard.
When I copy and paste into Excel, it creates a first column with the numbers
0,1, and 2. Each of these numbers is next to a column. Are these numbers
indicating keys or indexes or what?
Let me know.
Thanks!Hi
Testing this out it seems that this is some internal code, the first column
always seems to have a 1 all other columns seem to be 0, unless it is the PK
which seems to add two to the value i.e. 3 if it is the first column and 2
if not.
Nullability/Datatype/FKs/Indexes do not seem to effect the value.
John
"wnfisba" <wnfisba@.discussions.microsoft.com> wrote in message
news:E7F36117-2633-4F45-994F-3234A9843978@.microsoft.com...
>I am creating a Table Diagram via Enterprise Manager and the Database
>Diagram
> Wizard.
> When I copy and paste into Excel, it creates a first column with the
> numbers
> 0,1, and 2. Each of these numbers is next to a column. Are these numbers
> indicating keys or indexes or what?
> Let me know.
> Thanks!

Enterprise Manager Current Activity not displaying locks / process

I have a problem in Enterprise Manager and need some help.
When trying to identify possible locks via the locks/process ID screen under
the Current Activity option in the Management folder there are no items shown
at all.
At the same time there are around 500 active processes shown under the
process info screen which is in the same Current Activity area in the
Management folder.
I believe that some option has been switched off preventing me seeing the
entries on this screen, so I am looking for a way of switching it back on.
Any ideas would be gratefully appreciated
--
Steven FergusonSteven
All the info you can get from the current activity is a snapshot of activity
at the instant it checks. Even with 500 active processes, you are unlikely to
catch more than a handful at any one time. Processes page in and out very
quickly. If there is blocking occuring, you will see it this way. If you are
trying to get a handle on what locking is occuring, you will not get a very
good picture this way.
Use profiler if you want more details. Here is a link to a very good article
on using profiler.
http://www.sql-server-performance.com/sql_server_profiler_tips.asp
Hope this helps
John
"fergusons" wrote:
> I have a problem in Enterprise Manager and need some help.
> When trying to identify possible locks via the locks/process ID screen under
> the Current Activity option in the Management folder there are no items shown
> at all.
> At the same time there are around 500 active processes shown under the
> process info screen which is in the same Current Activity area in the
> Management folder.
> I believe that some option has been switched off preventing me seeing the
> entries on this screen, so I am looking for a way of switching it back on.
> Any ideas would be gratefully appreciated
> --
> Steven Ferguson

Enterprise Manager Current Activity not displaying locks / process

I have a problem in Enterprise Manager and need some help.
When trying to identify possible locks via the locks/process ID screen under
the Current Activity option in the Management folder there are no items shown
at all.
At the same time there are around 500 active processes shown under the
process info screen which is in the same Current Activity area in the
Management folder.
I believe that some option has been switched off preventing me seeing the
entries on this screen, so I am looking for a way of switching it back on.
Any ideas would be gratefully appreciated
Steven Ferguson
Steven
All the info you can get from the current activity is a snapshot of activity
at the instant it checks. Even with 500 active processes, you are unlikely to
catch more than a handful at any one time. Processes page in and out very
quickly. If there is blocking occuring, you will see it this way. If you are
trying to get a handle on what locking is occuring, you will not get a very
good picture this way.
Use profiler if you want more details. Here is a link to a very good article
on using profiler.
http://www.sql-server-performance.co...filer_tips.asp
Hope this helps
John
"fergusons" wrote:

> I have a problem in Enterprise Manager and need some help.
> When trying to identify possible locks via the locks/process ID screen under
> the Current Activity option in the Management folder there are no items shown
> at all.
> At the same time there are around 500 active processes shown under the
> process info screen which is in the same Current Activity area in the
> Management folder.
> I believe that some option has been switched off preventing me seeing the
> entries on this screen, so I am looking for a way of switching it back on.
> Any ideas would be gratefully appreciated
> --
> Steven Ferguson

Enterprise Manager Current Activity not displaying locks / process

I have a problem in Enterprise Manager and need some help.
When trying to identify possible locks via the locks/process ID screen under
the Current Activity option in the Management folder there are no items show
n
at all.
At the same time there are around 500 active processes shown under the
process info screen which is in the same Current Activity area in the
Management folder.
I believe that some option has been switched off preventing me seeing the
entries on this screen, so I am looking for a way of switching it back on.
Any ideas would be gratefully appreciated
Steven FergusonSteven
All the info you can get from the current activity is a snapshot of activity
at the instant it checks. Even with 500 active processes, you are unlikely t
o
catch more than a handful at any one time. Processes page in and out very
quickly. If there is blocking occuring, you will see it this way. If you are
trying to get a handle on what locking is occuring, you will not get a very
good picture this way.
Use profiler if you want more details. Here is a link to a very good article
on using profiler.
http://www.sql-server-performance.c...ofiler_tips.asp
Hope this helps
John
"fergusons" wrote:

> I have a problem in Enterprise Manager and need some help.
> When trying to identify possible locks via the locks/process ID screen und
er
> the Current Activity option in the Management folder there are no items sh
own
> at all.
> At the same time there are around 500 active processes shown under the
> process info screen which is in the same Current Activity area in the
> Management folder.
> I believe that some option has been switched off preventing me seeing the
> entries on this screen, so I am looking for a way of switching it back on.
> Any ideas would be gratefully appreciated
> --
> Steven Ferguson

Enterprise Manager connection question ..

Hi ;)

I have a database on my server provider ..and i connect via Enterprise Manager ...the thing i want to know is if theres a way to connect direct to my own database ..instead of having all databases in the tree layout and then selecting mine

is there a way in Enterprise Manager to point the Register Sql Server direct to my database ??

Thanksyes, you can create groups at the top of the tree. So I have "Local" and "Others". That way I don't see, or try to comm to, the ones in the "other" node when I look at my "local" one

Enterprise Manager causing lockout of user account on server

When I connect to the SQL Server remotely via enterprise manager as SA my
user account on the server ends up being locked out. Currently my work around
is to log on to the server via terminal service then run enterprise manager
from my terminal service session. I have no problems with my account
accessing enterprise manager through that method. I must point out that I
successfully connect as SA when I run enterprise manager on my desktop. Any
suggest would be most helpful.
I'm not sure how you are logging in on your desktop but it
could be related to the polling of the servers from
Enterprise Manager so you can try turning that off. In
Enterprise Manager, go to the menu to Tools, select Options.
On the General Tab, remove the check for Server State
Polling.
-Sue
On Wed, 2 Mar 2005 05:47:02 -0800, "James"
<James@.discussions.microsoft.com> wrote:

>When I connect to the SQL Server remotely via enterprise manager as SA my
>user account on the server ends up being locked out. Currently my work around
>is to log on to the server via terminal service then run enterprise manager
>from my terminal service session. I have no problems with my account
>accessing enterprise manager through that method. I must point out that I
>successfully connect as SA when I run enterprise manager on my desktop. Any
>suggest would be most helpful.

Enterprise Manager causing lockout of user account on server

When I connect to the SQL Server remotely via enterprise manager as SA my
user account on the server ends up being locked out. Currently my work aroun
d
is to log on to the server via terminal service then run enterprise manager
from my terminal service session. I have no problems with my account
accessing enterprise manager through that method. I must point out that I
successfully connect as SA when I run enterprise manager on my desktop. Any
suggest would be most helpful.I'm not sure how you are logging in on your desktop but it
could be related to the polling of the servers from
Enterprise Manager so you can try turning that off. In
Enterprise Manager, go to the menu to Tools, select Options.
On the General Tab, remove the check for Server State
Polling.
-Sue
On Wed, 2 Mar 2005 05:47:02 -0800, "James"
<James@.discussions.microsoft.com> wrote:

>When I connect to the SQL Server remotely via enterprise manager as SA my
>user account on the server ends up being locked out. Currently my work arou
nd
>is to log on to the server via terminal service then run enterprise manager
>from my terminal service session. I have no problems with my account
>accessing enterprise manager through that method. I must point out that I
>successfully connect as SA when I run enterprise manager on my desktop. Any
>suggest would be most helpful.

Enterprise Manager causing lockout of user account on server

When I connect to the SQL Server remotely via enterprise manager as SA my
user account on the server ends up being locked out. Currently my work around
is to log on to the server via terminal service then run enterprise manager
from my terminal service session. I have no problems with my account
accessing enterprise manager through that method. I must point out that I
successfully connect as SA when I run enterprise manager on my desktop. Any
suggest would be most helpful.I'm not sure how you are logging in on your desktop but it
could be related to the polling of the servers from
Enterprise Manager so you can try turning that off. In
Enterprise Manager, go to the menu to Tools, select Options.
On the General Tab, remove the check for Server State
Polling.
-Sue
On Wed, 2 Mar 2005 05:47:02 -0800, "James"
<James@.discussions.microsoft.com> wrote:
>When I connect to the SQL Server remotely via enterprise manager as SA my
>user account on the server ends up being locked out. Currently my work around
>is to log on to the server via terminal service then run enterprise manager
>from my terminal service session. I have no problems with my account
>accessing enterprise manager through that method. I must point out that I
>successfully connect as SA when I run enterprise manager on my desktop. Any
>suggest would be most helpful.

Enterprise Manager - SQL Server does not exist or access denied

I've searched around google & here and can't find a solution.
I can connect to my database via a connection string on the web serverbut cannot connect via Enterprise Manager or just by ODBC connection onmy local machine.
I can ping the server fine and switched off my XP firewall & my router firewall, port 1433 is also open.
Someone has tested this from another machine and it works fine (cheers).
What else can I try, this is driving me insane!
Thanks in advance
R
p.s I'm on Win XP SP2, SQL Server 2000 sp3a
Did the someone that tested have SP2 or SP1? I recently hadproblems with Enterprise Manager, SQL Server with SP2. I triedthe Microsoft fixes and was unsuccessful. I noticed the problemoccured pre-SP2, once I uninstalled SP2... it worked fine. Icould be wrong and you may have already tried this or experienced withsomeone elses machine w/ SP2 and may work fine, but I suppose if youhaven't tried it yet... it could be something to look at.
I'm using WinXP SP1, SQL Server 2000 sp3a
|||Port 1433 is a TCP port but you can connect to SQL Server through UDP port and Named pipe if you right click in Enterprise manager and go to the server properties may be your firewall have removed some of the connection points and Microsoft have other ports near 1433 reserved but not used. Hope this helps.|||I did the testing and I'm using WinXP SP2, SQL Server 2000 Personal Edition Service Pack 3
|||I stand corrected... then it must the firewall settings for port 1433
|||Ok, now i'm in trouble.
I completly reinstalled XP (Service Pack 1) and am now going straightinto my set top box for my net connection (no firewall/router involved)
I have not installed SQL Server but I cannot connect to my database via a "UDL" file.
I should be able to connect using the SQL Server driver shouldn't I, without installing SQL Server?
If someone could PM me or get me on MSN I would appreciate someone else trying to connect to my database.
R

|||

shincello wrote:

If someone could PM me or get me on MSN I would appreciate someone else trying to connect to my database.

I am still able to connect to the server using the previously-supplied credentials.
|||Ok, thanks tmorton, I didn't realise it was you who checked it before.
Could I just confirm that I should be able connect through the SQL driver in a UDL file WITHOUT installing SQL Server?
I can access the SQL Server within an ASP.NET page on 2 differentexternal servers (web based) but cannot access the server from my'localhost' ASP.NET pages or through the direct UDL link.
The only thought I have beyond this is that my ISP must be blocking some connection?
|||Resolved!
I hooked up to another ISP and it worked straight away, weird eh?
Now i've got to speak to them to try to resolve it..
So anyone on NTL broadband in the UK WATCH OUT!
R
|||I spoke to my ISP and they gave me a list of proxy servers to go through to try to resolve this.
1) Is this likely to help at all?
2) How do I change the proxy server for Enterprise Manager? Or can ijust change my Proxy server for my whole network connection?
Cheers
Rich
|||

shincello wrote:

I spoke to my ISP and they gave me a list of proxy servers to go through to try to resolve this.
1) Is this likely to help at all?
2) How do I change the proxy server for Enterprise Manager? Or can ijust change my Proxy server for my whole network connection?

I'm sorry, this is outside my area of knowledge. Hopefully someone else will chime in.

Enterprise Manager and named instances

Hi, How to connect via internet to MSDE 2000 named instance using Enterprise
Manager?
On remote server (2K Server) there are installed MSDE 2000 default instance
and named instance. Named instance is using port 3077.
Adam,
in the Client Network utility define an alias which points to your
named instance and define the port number.
M

Enterprise Manager (Import Data) - DTS Error

I created a new database in Enterprise Manager and then attempted to import data into this new database from an existing database via the "import data" option. This launches the Data Transformation Services Import/Export Wizard. I select the data source
. I select the destination. I select 'Copy table(s) and view(s) from source database." I select all tables. I select the 'run immediatedly' option. When I click the 'Finish' button, I receive the following message in a message box entitled 'Initializ
e Com:"
Could not create an instance of the DTS Package.
Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.
Problem solved. I installed SP3a and import/export works fine now.
"Ross Russell" wrote:

> I created a new database in Enterprise Manager and then attempted to import data into this new database from an existing database via the "import data" option. This launches the Data Transformation Services Import/Export Wizard. I select the data sour
ce. I select the destination. I select 'Copy table(s) and view(s) from source database." I select all tables. I select the 'run immediatedly' option. When I click the 'Finish' button, I receive the following message in a message box entitled 'Initial
ize Com:"
> Could not create an instance of the DTS Package.
> Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.

Enterprise Manager (Import Data) - DTS Error

I created a new database in Enterprise Manager and then attempted to import
data into this new database from an existing database via the "import data"
option. This launches the Data Transformation Services Import/Export Wizard
. I select the data source
. I select the destination. I select 'Copy table(s) and view(s) from sourc
e database." I select all tables. I select the 'run immediatedly' option.
When I click the 'Finish' button, I receive the following message in a mess
age box entitled 'Initializ
e Com:"
Could not create an instance of the DTS Package.
Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.Problem solved. I installed SP3a and import/export works fine now.
"Ross Russell" wrote:

> I created a new database in Enterprise Manager and then attempted to import data i
nto this new database from an existing database via the "import data" option. This
launches the Data Transformation Services Import/Export Wizard. I select the data s
our
ce. I select the destination. I select 'Copy table(s) and view(s) from sou
rce database." I select all tables. I select the 'run immediatedly' option
. When I click the 'Finish' button, I receive the following message in a me
ssage box entitled 'Initial
ize Com:"
> Could not create an instance of the DTS Package.
> Can anyone tell me what may be wrong? This is SQL Server 2000, SP3.

Enterprise Manager - SQL Server does not exist or access denied

I've searched around google & here and can't find a solution.
I can connect to my database via a connection string on the web serverbut cannot connect via Enterprise Manager or just by ODBC connection onmy local machine.
I can ping the server fine and switched off my XP firewall & my router firewall, port 1433 is also open.
Someone has tested this from another machine and it works fine (cheers).
What else can I try, this is driving me insane!
Thanks in advance
R
p.s I'm on Win XP SP2, SQL Server 2000 sp3a
Did the someone that tested have SP2 or SP1? I recently hadproblems with Enterprise Manager, SQL Server with SP2. I triedthe Microsoft fixes and was unsuccessful. I noticed the problemoccured pre-SP2, once I uninstalled SP2... it worked fine. Icould be wrong and you may have already tried this or experienced withsomeone elses machine w/ SP2 and may work fine, but I suppose if youhaven't tried it yet... it could be something to look at.
I'm using WinXP SP1, SQL Server 2000 sp3a
|||Port 1433 is a TCP port but you can connect to SQL Server through UDP port and Named pipe if you right click in Enterprise manager and go to the server properties may be your firewall have removed some of the connection points and Microsoft have other ports near 1433 reserved but not used. Hope this helps.|||I did the testing and I'm using WinXP SP2, SQL Server 2000 Personal Edition Service Pack 3
|||I stand corrected... then it must the firewall settings for port 1433
|||Ok, now i'm in trouble.
I completly reinstalled XP (Service Pack 1) and am now going straightinto my set top box for my net connection (no firewall/router involved)
I have not installed SQL Server but I cannot connect to my database via a "UDL" file.
I should be able to connect using the SQL Server driver shouldn't I, without installing SQL Server?
If someone could PM me or get me on MSN I would appreciate someone else trying to connect to my database.
R

|||

shincello wrote:

If someone could PM me or get me on MSN I would appreciate someone else trying to connect to my database.

I am still able to connect to the server using the previously-supplied credentials.
|||Ok, thanks tmorton, I didn't realise it was you who checked it before.
Could I just confirm that I should be able connect through the SQL driver in a UDL file WITHOUT installing SQL Server?
I can access the SQL Server within an ASP.NET page on 2 differentexternal servers (web based) but cannot access the server from my'localhost' ASP.NET pages or through the direct UDL link.
The only thought I have beyond this is that my ISP must be blocking some connection?
|||Resolved!
I hooked up to another ISP and it worked straight away, weird eh?
Now i've got to speak to them to try to resolve it..
So anyone on NTL broadband in the UK WATCH OUT!
R
|||I spoke to my ISP and they gave me a list of proxy servers to go through to try to resolve this.
1) Is this likely to help at all?
2) How do I change the proxy server for Enterprise Manager? Or can ijust change my Proxy server for my whole network connection?
Cheers
Rich
|||

shincello wrote:

I spoke to my ISP and they gave me a list of proxy servers to go through to try to resolve this.
1) Is this likely to help at all?
2) How do I change the proxy server for Enterprise Manager? Or can ijust change my Proxy server for my whole network connection?

I'm sorry, this is outside my area of knowledge. Hopefully someone else will chime in.

Enterprise Manager - How secure is it?

I connect to my clients SQL databases via Enterprise Manager. Most of the time the SQL server resides at a web host. A colleague recently told me that this is a huge security hole and I should be using Remote Desktop instead.

I would appreciate other input, opinions, and guidance on this issue.Actually both have problems ... they should both have a secure layer, but none has it ...
You can secure your remote SQL server more by putting a firewall before it that will only allow connections on port 1433 (SQL Server port) coming from certain IP addresses|||Another way to make it more secure is to configure the DB as a named instance, and change the network port to the DB.. This can be done through Enterprise manager.

Entering <NULL> into column via EM

How do I enter <NULL> into table column via EM?
I thought it was Shift + Enter or CTRL+Shift + Enter - but no dice.
Thanks.Its CTRL+0
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Guadala Harry" <GMan@.NoSpam.net> schrieb im Newsbeitrag
news:O9rXxMdSFHA.248@.TK2MSFTNGP15.phx.gbl...
> How do I enter <NULL> into table column via EM?
> I thought it was Shift + Enter or CTRL+Shift + Enter - but no dice.
> Thanks.
>|||CTRL + 0