The Worst Asp.net Host

Jul 20, 2005

Whatever you do, don't try aspwebhosting.com . One day recently I got
an email from them saying that my account had been suspended for using
too much cpu time. There was no further explanation. Those bastards
took my site offline, removed my email account, blocked my ftp access
and even refused to let me get a backup of sql-server data. I sent
them an email (using a yahoo account since they had shut down my own
server) to ask what I could do to get my data. Rather than answer my
email they simply put me their BLOCK list. All of my emails are now
automatically bounced. I only sent them one email and it was very
polite. My website is gone. My data is gone. All of my files are
gone. The loss of time and effort combined with damage to my business
is unforgivable

View 6 Replies


ADVERTISEMENT

The Worst Execution Plan For A Function

May 7, 2008

Hi,

I use a SQL Server 2000 and I am trying to use function instead of a ad hoc query because I REALLY have to do it, but some issues must be solved. SQL Server is using a optimal execution plan when I run query and the worst execution plan for function.

Here are the informations you might need to help me:

Table DDL



Code SnippetCREATE TABLE [IRES] (
[CPF_CNPJ] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TIPO] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[IMPEDIMENTO] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[GRAU] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DT_ULT_OCOR] [datetime] NULL
) ON [PRIMARY]
GO





indexes
sp_helpindex ires



Code Snippet
name description keys
IRES_CPF clustered located on PRIMARY CPF_CNPJ
IRES_IMPED nonclustered located on PRIMARY IMPEDIMENTO





PERFORMANCE INFO

QUERY - it takes 2s to run and server makes an index seek on IRES_CPMF index




Code Snippet
select 'query ad-hoc',*
from IRES
where CPF_CNPJ = '000002230'
and TIPO = 'F'

EXECUTION PLAN
Clustered Index Seek(OBJECT:([bmcires].[dbo].[IRES].[IRES_CPF]), SEEK:([IRES].[CPF_CNPJ]='000002230'), WHERE:([IRES].[TIPO]='F') ORDERED FORWARD)


FUNCTION - it takes 20s to run and server makes a index scan on IRES_IMPED index!!!!




Code Snippet
CREATE FUNCTION fn_ires_crivo
( @cpfcnpj nvarchar(9) )
RETURNS table
AS
RETURN (
SELECT CPF_CNPJ,
TIPO,
IMPEDIMENTO,
GRAU,
DT_ULT_OCOR
FROM dbo.ires WITH (INDEX (IRES_CPF) NOLOCK)
WHERE
CPF_CNPJ = @cpfcnpj
and TIPO = 'F'
)
go


select cpf_cnpj
from fn_ires_crivo('000000029')

EXECUTION PLAN
|--Filter(WHERE:([IRES].[TIPO]='F'))
|--Bookmark Lookup(BOOKMARK:([Bmk1000]), OBJECT:([bmcires].[dbo].[IRES]))
|--Parallelism(Gather Streams)
|--Index Scan(OBJECT:([bmcires].[dbo].[IRES].[IRES_IMPED]), WHERE:(Convert([IRES].[CPF_CNPJ])='000000029'))


View 7 Replies View Related

What Is The Host Name?

May 30, 2007

I am trying to connect to a remote MSSQL database through a manager program called "SQL Manager Lite". The first thing that the wizard asks me is the "host name".

How do I find this host name? I just mention that I am trying to connect to a database on a shared hosting.

.

View 3 Replies View Related

Building An NT Box To Host SQL 7

Oct 25, 1999

I'm in the midst of planning how to build an NT box to host SQL 7.0 and was wondering if there is any advantage to segregating the RAID 5 Array (5 x 18GB drives) into numerous *logical* partitions to separate database and log files (I can't see what advantage there would be if the disks are all on the same array, but..)

If anyone has any pointers or links to recommended NT configurations for hosting SQL, I'd appreciate hearing them.

TIA,
RM

View 1 Replies View Related

Host Name Not Displayed

Jul 19, 1999

When using sp_who and sp_who2 on SQL Server 6.5 I seem to get inaccurate results .

Each spid seems to be using the same host name, and the host name used is one that hasn't been connected to SQL server for several months.

Is there a problem with the connection management ? If so how do I find this out ? and how do I fix it ?

View 2 Replies View Related

Change Host Name

Oct 19, 2007

hi,
I change the PC name. so now @@servername returns the oldname.
I try sp_dropserver and I got an error:

Msg 15015, Level 16, State 1, Procedure sp_dropserver, Line 42
The server '[IBM-E81EB247FF3]' does not exist. Use sp_helpserver to show available servers.

I run sp_helpserver and I get the oldname:

IBM-E81EB247FF3IBM-E81EB247FF3 rpc,rpc out,use remote collation0 NULL00

any idea ?
many thanks
Noam


Noam Graizer

View 1 Replies View Related

Deploy .MDF To A Web Host

Mar 17, 2006

Hi all,I'm new to SQLServer (Express edition) so I was wondering: if the webhost supports SQLServer 2005 do I just need to move the .MDF file to mydirectory on the web host to be able to use it?Thanks,Lorenzo

View 3 Replies View Related

Is There A Free Ms Sql Host?

Oct 5, 2006

I am looking for a free ms sql database for my programs, but i don't want to host it on my computer, because my web host does not allow servers to be run and people connecting to thme.

View 1 Replies View Related

DB Engine :: Host-name And Name Are Not Same?

Aug 31, 2015

when I run the Query "Select @@ServerName" it is providing the server name which is not same as I connect to SQL Server.example : My SQL Server Name is "XXX123" and when I run the above query it is Printing as "YYY123"

View 5 Replies View Related

How To FTP To Host(Mainframe)?

Jan 24, 2008

Hi,

I am trying to send files over to an ftp server on Mainframe using scripts that is provided in this link, but I can't get it to work.
The problem is the sendfile method concatinates the source file name to the MVS dataset name which causes the issue.

Here's my code (FTPConn is a connecation mgr for FTP):


Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime



Public Class ScriptMain


Public Sub Main()



Dim mgr As ConnectionManager

mgr = Dts.Connections("FTPConn")



Dim conn As FtpClientConnection

conn = New FtpClientConnection(mgr.AcquireConnection(DBNull.Value))



Dim toFiles As String

toFiles = "ftpp.a.b.xxxxx.yyyyyy.int"

Dim fromFiles(0) As String

fromFiles(0) = "c: est.txt"

Try


conn.Connect()

conn.SendFiles(fromFiles, toFiles, True, True)

Catch ex As Exception





Finally

conn.Close()

End Try





Dts.TaskResult = Dts.Results.Success

End Sub



End Class



Output:


SSIS package "Package.dtsx" starting.

Error: 0xC001602A at Package, Connection manager "FTPConn": An error occurred in the requested FTP operation. Detailed error description: 200 Representation type is Ascii NonPrint

200 Port request OK.

501 Invalid data set name "ftpp.a.b.xxxxx.yyyyyy.int/test.txt". Use MVS Dsname conventions.

View 13 Replies View Related

Web Host MS Sql Performance - My Fault?

Feb 14, 2007

Hi,
I'm using SqlServer 2000 at a web host, and share this db with about 200 others (it's an inexpensive web host so I guess there is not very much traffic on most of them, but I can only see their db IDs so I don't know what organisations they are or the urls they have).
Usually, my web site runs fine, but lately it's really really slow (as in non-functioning in reality). I'm in the middle of coding my seach functionality, so I fear that I'm causing this myself. ;-)
However, there are only ten posts in my test db, so it should be a piece of cake for SqlServer. The other .aspx pages runs rather slow too now, but when I start a programming session they have worked fine (this has happened three times now so I don't know what to conclude). When the server slows down, it can stay down for hours. I've also tried to access my site from other computers but get the same result, so I guess it has nothing to do with caching (I also tried emptying my browser's - IE7 - cache). I have several asp web sites with Access dbs at the same web host, and they all work fine. In addition, I have no problem viewing and editing my db at the web host via SqlServer Management Studio Express.
What do you think of this problem? Should I go for a more expensive web host? Should I give them the "It's not you, it's me" speech? ;-) Or is it really me?
Below's my search code, and as you can see, there are some integers there to make sure the loops don't run ad infinitum. I don't really think the problem actually lies with my search code, as everything worked well a week ago, but I don't know...
BTW, if you think my code can run much faster without getting too tricky, please let me know.
Please help!
Pettrer
If Page.IsPostBack Then
Dim soktext As String = Trim(SokTextBox.Text) + " "
Dim tillagg As String = ""
Dim varv As Integer = 1
Dim loopvarv As Integer = 0
soktext = Replace(soktext, vbCrLf, " ") 'vbCrLf = mellanslag i VB-terminologi
Do While InStr(soktext, " ") And varv < 100
soktext = Replace(soktext, " ", " ")
loopvarv += 1
Loop
While Trim(soktext).Length > 0 And varv <= 20 'Loop för att identifiera ord och lägga till dem i sqlsatsen, ett i taget
Dim icke As String = " "

Dim ordet As String = soktext.Substring(0, soktext.IndexOf(" ")) 'Det godkända ordet läggs till i tmp-strängen
soktext = soktext.Remove(0, soktext.IndexOf(" ") + 1) 'Tar bort det som just använts (eller varit för kort)
If ordet.Length > 1 Then 'Blanksteg och ensamma bokstäver förhindras att komma med i sql-satsen
If ordet.StartsWith("-") Then 'Det är ett minusord
icke = " NOT " 'I sqlsatsen blir det alltså AND NOT (...)
ordet = ordet.Remove(0, 1) 'Tar bort minusttecknet från söksträngen
End If
tillagg += " AND " & icke & " (artistnamn LIKE '%" & ordet & "%' OR " & _
"beskrivning LIKE '%" & ordet & "%' OR " & _
"kulturhemvist LIKE '%" & ordet & "%' OR " & _
"kontaktnamn LIKE '%" & ordet & "%') "
End If
varv += 1
End While
Dim kat As String = ""
If KategoriDropDownList.SelectedValue <> 0 Then
kat = " AND (kategori1 = " & KategoriDropDownList.SelectedValue & _
" OR kategori2 = " & KategoriDropDownList.SelectedValue & _
" OR kategori3 = " & KategoriDropDownList.SelectedValue & _
" OR kategori4 = " & KategoriDropDownList.SelectedValue & ") "
End If
Dim lan As String = ""
If LanDropDownList.SelectedValue <> "alla" Then
lan = " AND lan = '" & LanDropDownList.SelectedValue & "' "
End If
ResultatDataSource.SelectCommand = "SELECT DISTINCT TOP 200 folknuID, kategori1, kategori2, kategori3, kategori4, initial, artistnamn, lan, kontakthemsida, kategori1, (COALESCE(audio1,'') + COALESCE(audio2,'') + COALESCE(audio3,'')) As audio, (COALESCE(video1,'') + COALESCE(video2,'') + COALESCE(video3,'')) As video, (COALESCE(pressbild1,'') + COALESCE(pressbild2,'') + COALESCE(pressbild3,'')) As pressbild " & _
"FROM Mytable " & _
"WHERE shown = 1 AND shownadm = 1 " & _
tillagg & _
kat & _
lan & _
"ORDER BY initial"
ResultatLabel.Text = "SelectCmd: " & ResultatDataSource.SelectCommand
ResultatGridView.DataBind()
End If '*** på sökkoden

View 7 Replies View Related

SQL Express On A Public Web Host

Mar 28, 2007

Are there any restrictions, limitations or anything to prevent the use of SQL Express database being used with my ASP.NET 2.0 application on a public web host?
If so, what are they?
Thanks.

View 10 Replies View Related

Move Mdf Database To Host

Jan 20, 2008

HiAs i have read, there have been discussions before how to move a local MDF databas to MSsql server at a webhost.But i cant figure it out, i know the answere is out there but i cant find it.I have downloaded the Host Deployment tool that generates a .sql file from my database, it looks ok.The problem is that my host dont allow me to execute this. I have also tried to run a file called RunSql.aspx  that should help me execute my .sql file.But i recieve errors
Opening url http://mydomainz1.com/mydbfile.mdf.sqlAn error occured: System.Net.WebException: The remote server returned an error: (404) Not Found. at System.Net.HttpWebRequest.GetResponse() at ASP.runsql_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in d:hsadminaccoundidmydomainz1.comRunSQL.aspx:line 58The line 58 is empty
 Is there anyway that a mdf file that i have build in VWD 2005 can work as a standalone database?I would like it to be as a .mdb database that is simple to move and so on.
Or do the mdf database have to have a MSsql Express or a MSsql Server?
 Grateful for help!
/ mitmit

View 1 Replies View Related

What Is The Best Way To Export MSDE Db To SQL Db On Host?

Jul 22, 2004

I have a DNN install on my local PC that I would now like to transfer to my remote host server. What is the best way to do this? I have exported the db locally but see no way to import it on the host.

Thanks!

View 9 Replies View Related

SQLEXPRESS Database To Host

Feb 10, 2006

I created a sqlexpress database in visual studio 2005 and can't figure out to move the database to my hosting company( godaddy ).  I can't connect remotely to the database on my hosting company.   Whats the best way to go about this?

View 1 Replies View Related

Changing Host Server Name

Oct 24, 2000

At work, we are in the process of moving a server running SQL Server 7 from one domain to another. A part of this domain change will necessitate that the server be renamed. In a couple of tests that we ran we found that changing the domain does not cause problems, but changing the server name does. How does one register the databases with the new server name without reinstalling everything from scratch?

Any assistance would be greatly appreciated as we are under a time crunch here. Please reply to my email as I am unable to check this board often.

Thanks,
Mike Sinnott

View 1 Replies View Related

SQL 6.5 And SQL 7.0 Simultaneously Active On Same Host

Mar 26, 1999

Has anyone developed a workaround to have SQL 6.5 and SQL 7.0 simultaneously active on the same NT 4.0 Server host. The use of VSWITCH.EXE to switch between SQL 6.5 and SQL 7.0 in not an acceptable solution. There are several applications that are only supported under SQL 6.5 and will not be upgraded to SQL 7.0 for another 3 to 6 months.

There are other applications (ERP and data mart) that were developed specifically for SQL 7.0 to take advantage of its new DTS, OLAP, and query capabilities.

All these applications need full-time access to their respective databases.

The obvious solution is to host SQL 6.5 and SQL 7.0 on separate servers. The client has a "monster" database server which would be too expensive to duplicate. Using a "standard" PC to host SQL 6.5 would significantly compromise performance of those applications.

Any advice or suggestions would be appreciated.

Andrew Dominguez, IMS
ajd@cwix.com
909.625.4066 / 7826 fax

View 3 Replies View Related

Rename SQL Server Host Name

May 31, 2001

I have change the name of my host by "network neighborhood"
and user sp_dropserver and sp_addserver.
But when rebooting the host, I have this following message.

"Your SQL Server installation is either corrupt or has been
tampered with (unknown package id). Please run setup."

But I change the name of the hostanme to the former name, there
is no error.

Please, can you advise me something ?

View 3 Replies View Related

MS SQL Problems After Host Migration

Nov 17, 2004

My reseller web host (DIY) migrated a few weeks ago to a new data center.
Unfortunately, my MS SQL databases were not migrating properly. (as well as
other things). I have multiple sites that are not functional due to
problems with their migration.

When I looked at some of the databases, the table structure had been
migrated, but not the data and apparently something else.

Some of the databases of this error when trying to access it:
--- error ---
Error for database: DATABASENAME
Microsoft OLE DB Provider for SQL Server error '80040e37'
Invalid object name 'TABLENAME'.
--- end error---

Some of the databases I can actually access but get:

Microsoft OLE DB Provider for SQL Server error '80040e2f'
Cannot insert the value NULL into column 'TABLENAME', table
'DATABASENAME.dbo.TABLENAME'; column does not allow nulls. INSERT fails.
Everything in all databases worked perfectly before the migration.

They tell me that they have done what they can. They tell me that they are
at the mercy of Psoft who assisted with the migration.

Does anyone know of anything that can my host that can help them figure out
the problem.

Any assistance will be GREATLY appreciated.

View 1 Replies View Related

Migration From Physical Host To VM?

Jun 25, 2015

we have:

(1) one physical server :

OS : Windows Server 2003
Active Directory, DNS, DHCP, File Server, Print Server and SQL Server 2005

and we will install new (2) two server for High Availability with VMware vSphere (ESXi) 6.0

and we will have (2) two Virtual Machine :

1st VM :
OS : Windows Server 2012 R2
Active Directory, DNS, DHCP

2nd VM :
OS : Windows Server 2008 R2 (becaure SQL Server 2005 does not work with 2012 R2 link)
SQL Server 2005 Service Pack 3

My Question is : What is a safe method to Migrate Database's from Physical Host (Windows Server 2003) to 2nd VM ?

View 9 Replies View Related

Error 11001:No Such Host Is Known.

Nov 11, 2006

I was trying to allow remote user to access sql server 2005 database.I have done configuration and tested on my computer,it works well.But from other computer,I can not use the new user to login.

Error message is :no such host is known.

How can I resolve it?

View 3 Replies View Related

Copying A Database From Web Host

May 21, 2007

Hi. I have a client with a database hosted on SQL Server 2005. I don't have a paid version of SQL Server at home so am just using SQL Server Express. I'm getting INCREDIBLY FRUSTRATED that I can't use the "copy database" wizard from SQL Server Express.

Am I just out of luck on this? I can't use the "copy database" feature since I'm using Express. I can't get the actual files since the database is on a shared server. I know I'm not the only person with this issue; I see people asking the question but I don't see any answers.

Is there any way I can copy this database?

Thank you very very much,
- Andrew Clarke.

View 5 Replies View Related

User Can Only Login From A Specified Host

Jul 18, 2007

Hi



I'm trying to create a login (Sql Server 2005) that can only connect from a specified host. Im sure this is

possible but i cant seem to find the option anywhere.

eg. a login that can only connect from localhost or maybe an address range like 192.168.0.%.



Thanks

View 1 Replies View Related

Do Any ISP's Really Host SQL 2005 Express

Jul 30, 2006

Hi, I've been a SQL Server dba for about 10 years, so i know SQL quite well. I've recently started using VWD express, and as it says, its quick and easy to create a website, which I've done. It all works great on my local machine. I've just signed up with an isp and duly ftp'd the project files plus the mdf and ldf that lives in App_Data into their content area, and rather naively I expected it all to work. The pages come up fine until some database access is called for, then i get the seemingly infamous error:

... (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) ...

I've researched this for 2 solid days now, examined forums and posts, followed advice and enabled protocols and so on. Support at the isp in question does not really have a clue about databases and connections strings. Then I started looking closely at the words used by the isp's, none of the isp's explicitly say they support sql 2005 express. They do say SQL 2005, but not express. They do say VWD Express, but not SQL 2005 Express. So does anyone know what is/is not possible with regard to deployment of SQL 2005 express. Does anyone have experience of running SQL express on a production server, or a shared hosters machine? Its been out now for nearly a year I think, so hopefully someone has the answer.

Thanks if you can help! Charlie









View 8 Replies View Related

Connecting To SQL Server On A VPC Host

Jan 19, 2008

VPC Host: Vista 64Bit
VPC Guest: Win2K3 (32Bit)

VPC is configured to use the wireless card on the host.
Firewalls on both systems are completely disabled.
Machines can ping each other.
Both machines can access the Internet.
I can browse the SQL Reporting Services Web Site on the Host from the Guest.
Host SQL Install has remote connections enabled.
If I browse for Network server from teh connect dialog on teh Guest, it finds the Host.

Why can't I connect to the Databse Engine on the Host from the Guest?
I have tried both TCP/IP and Named Pipes and both show a connection failure. (Not a login failure)

If it matters, the Guest OS also has a SQL Database Engine running. But I don't know why that would stop me from connecting to a remote instance.

And suggestions would be appreciated.

Thanks.

J

View 1 Replies View Related

Works Locally But Not On Host

May 1, 2008



I am very confused. I've finally gotten everything to work the way I want on my pc, but when I ftp to the Internet (URL is hosted on GoDaddy), everything goes haywire. I had to create a new database on the host server, and when I use an aspx login, I get the following message:


The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.

I know what the connection string to the database is, but where do I enter that information? I'm obviously new at asp.net and sql, and I need major help.

Thanks. Linda

View 2 Replies View Related

&&<Host System.Messaging In CLR&&>

Dec 2, 2006

Hi All, i am trying to host the system.messaging.dll in SQL Server. I get the usual warnings about not being fully trusted. I am prepared for MS not supporting. But, when i execute my trigger (which writes to message queue), the trigger fails with an exception of 'That assembly does not allow partially trusted callers'. So. is there no way for me to write to MSMQ using triggers? Do i have to rethink my strategy?



imports System.Messaging

Dim msmq As MessageQueue = MessageQueue.Create(".TestQueue", False)

msmq.Send("Test")



Thanks for the help

View 5 Replies View Related

Aspnetdb On Host, Connection String

Aug 28, 2006

HiI am having trouble connecting to aspnetdb on the shared host. On my local server this is my connection string which works fine: <add name="MyLocalSqlServer" connectionString="Data Source=.SQLExpress;Integrated Security=SSPI;Initial Catalog=aspnetdb;User Instance=false"providerName="System.Data.SqlClient" />But, this doesn't work on the host (just putting  in host address):<add name="MyLocalSqlServer" connectionString="190.40....232,1444;Integrated Security=SSPI;Initial Catalog=aspnetdb_booksale;User Instance=false"providerName="System.Data.SqlClient" />,and I get the error :Login failed for user ''. The user is not associated with a trusted SQL Server connection.so I put in the user id and password that i used when I created the aspnetdb_booksale db<add name="MyLocalSqlServer" connectionString="Data Source=196....232,1444;Integrated Security=False;User ID=aspnetdbbooksale; password=amanda;Initial Catalog=aspnetdb_booksale;User Instance=false"providerName="System.Data.SqlClient" />and I get the error:The ConnectionString property has not been initialized. Any ideas for me?Amanda  

View 3 Replies View Related

Able To Connect Via Local Host But Not Server

Sep 14, 2006

I have a page that connects to SQL server. It works fine when running in local host but when I publish to the server, I get the following: An error has occurred while establishing a connection to the server.  When
connecting to SQL Server 2005, this failure may be caused by the fact that under
the default settings SQL Server does not allow remote connections. (provider:
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 
 Any ideas on where to start? Thanks,Mark

View 1 Replies View Related

Copying SqlServer Database From Web Host

Mar 14, 2007

Hi,
I have a hard time copying my db (or instance?) from a SQL Server 2000 db which resides at my web host. I have Sql Server 2005 Express and Sql Server Management Studio Express on my computer and, well, there is no "ftp-like" option so I don't have a clue about how to proceed. I've read many posts on the net on this matter but nothing seems to apply to this, in my mind, rather common, configuration.
I have receieved Excel docs that should be appended to tables in my db. I have successfully installed DTS (see http://mobiledeveloper.wordpress.com/ for details - it's really simple but takes two hours) so I have a wizard for the actual import from Excel. My plan is now to
1. download/detach/whatever my table/db/part of the web host's db and download it to my computer. Then
2. fill the tables with the data from Excel. And finally, to
3. upload/attach/whatever my local db or table to the web host again.
I'm sooo confused, please, please help me out here!
Pettrer

View 1 Replies View Related

Upload Sqlexpress DB To Remote Host

Apr 4, 2007

Hey I've been trying to upload a sql express database to my webserver with out much success :(
 When I upload it I get permission problems so I think anyway
 I've been reading around and it looks like i'm stuck with having to let the server create the database file again
 Is there anyway i can upload this file to the webserver and get it working 100%?

View 5 Replies View Related

Maintaining SQL Data On A Remote Host.

Oct 29, 2007

Hi,What is the preferred way to maintain SQL tables on a remote host?I am a newbie to building ASP.NET websites on a remote host.A stumbling point has been the maintenance of SQL tables on the remote host.I understand about doing complete backup and restores,but I am seeking a quicker way to maintain individual files.I would like to click and edit but instead am going through the following 30+ clicks.Is there a easier way?Thanks.
For example, what I do now to build a new data table for a hosted website.1) Design table 1a) Name 1b) Fields & Types
2) SQL Server Management Studio Express (assuming existing database) 2a) Select Database & Tables 2b) Add new table 2c) Add fields,  Key must be INT for ACCESS 2d) Save as (Name_Table)
3) MS Access  (requires ODBC to be setup first through the Windows control panel) 3a) Tables / New / Link / ODBC /Machine_Data_Source 3b) Pick table 3c) Edit data, as needed
4) To transfer data, first:Select the database in the VWD solution explorer, then right-click and select the new "Publish to Provider" 4a) Database Publishing Wizard   4b) Choose table to script a backup from 4c) Build script & Copy
5) Start Ipswitch FTP ( this step can be rplaced by 6e below) 5a) locate folder & sql script file and choose destination directory 5b) Transfer file
6) Login to remote host host (1and1) 6a) MS SQL Administration  6b) Admin (MyLittleTools Admin) 6c) Tools 6d) Quey Analyser 6e) Paste script (from step 4) 6f) Submit (Run) 6g) Verify table built
FYI: Script to build and populate the new table "Name_Table"Built by step 4c above, pasted into remote Hosts Query Analyzer by step 6e above.
/****** Object:  Table [dbo].[Name_Table]    Script Date: 10/28/2007 18:03:58 ******/IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Name_Table]') AND type in (N'U'))DROP TABLE [dbo].[Name_Table]GO/****** Object:  Table [dbo].[Name_Table]    Script Date: 10/28/2007 18:03:58 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOIF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Name_Table]') AND type in (N'U'))BEGINCREATE TABLE [dbo].[Name_Table]( [ID] [int] NOT NULL, [Name] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Address] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [City] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [State] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Zip] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Acsz] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Phone] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Fax] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_Name_Table_1] PRIMARY KEY CLUSTERED ( [ID] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  =
ON))ENDGOINSERT [dbo].[Name_Table] ([ID], [Name], [Address], [City], [State], [Zip], [Acsz], [Phone], [Fax]) VALUES (1, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL)INSERT [dbo].[Name_Table] ([ID], [Name], [Address], [City], [State], [Zip], [Acsz], [Phone], [Fax]) VALUES (2, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL)INSERT [dbo].[Name_Table] ([ID], [Name], [Address], [City], [State], [Zip], [Acsz], [Phone], [Fax]) VALUES (3, N'Third
name', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
 

View 1 Replies View Related

Issues On Changing Name Of Our SQL Server Host

Feb 18, 2002

Issues on Changing Name of our SQL Server Host
Michael G (m1g@hotmail.com)

We are going to rename the Server machine Host Name that our SQL2000
(named instance) Server now resides on.

* I am searching for all references in Operating System items, such as .cmd, .bat. ftp files referring to it (eg., sqlservNM)
* I am searching for all references in Operating System items, such
as ODBC, VB ADO, DOA and DSN-less connections that refer to it.
These references will be changed manually on the day of the change.

I am NOT so certain that I need to search for all SQL Server Objects referring to it, (eg., DTS packages and scheduled Jobs). Must these
objects be changed manually or will they be redirected somehow?

Anyone with any experience on this?

Thanks,
Michael

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved