Error when transferring data from local database to hosted database

Hi,

I tried to tranfers some database tables from my local SQL Server 2000 database to a hosted database (SQL Server 2005) MSSQL Management Studio 2005. I did the same job successfully before also from my local MSSQL2000 to another hosted MSSQL2005 database. However, this time I encounter the following problem (in red below).

I opened a ticket for support from my service provider but they seemed to have no idea. Therefore, I must seek for help on this forum. Could anyone please give me some advice? Thank you very much in advance.

Regards,
Kenny

Messages
* ERROR : errorCode=-1073548784 description=Executing the query "CREATE TABLE [islandwidecatering.com.sg].[dbo].[Affiliates] (
[AffiliateId] int NOT NULL,
[VendorId] int,
[StartDate] datetime,
[EndDate] datetime,
[CPC] float NOT NULL,
[Clicks] int NOT NULL,
[CPA] float NOT NULL,
[Acquisitions] int NOT NULL
)
" failed with the following error: "Could not allocate space for object 'sys.syscolpars'.'clst' in database 'islandwidecatering.com.sg' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider)

It seems there is no available space for the new table. You can try to configure the databse to auto growth, or delete useless data to free space.

Error when connecting remote SQL SERVER

Hi..

I have been assigned to make a database in some remote machine.The machine has MSSQL 2005.I need to connect to that remote machine's sql server via my pc using my SQL Management express.I do have that computer's IP address(say,123.456.789.000),and the username and password.But when i try to connect to the server ,I get the following error:

Cannot connect to 123.456.789.000\sqlexpress

An error has occured while establishing a connection to the server.When connecting to SQL server 2005,this failure may be caused by the fact that unser the default settings SQL server does not allow remote connections,(provider: SQL Network Interfaces,error:26-Error Locating Server/Instance specified)(Microsoft SQL Server)

I am a new programmer and dont know much.But i guess the problem is not in my server but in that server to which i am trying to connect.I guess that server has some instance created or it does not allow remote connections.But i am not sure.Is it so?Or is anything wrong in my server.Any ideas?IF you put these errors into a search engine you should get a series of answers.
Anyhows...check this out.
I faced this issue , found out that I was under the Vista client category.

cheers

Error when attempt to link to exchange

hello,
I try to add exchange server as linked server in mssql on SBS2003.
I use sp_addlinkedserver :
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders
Now when trying to run a query or listing tables in EM I always get the
following error:
Error 7304: A new session on OLE DB-Provider
'exoledb.DataSource.1' could not be created.
OLE DB-Errortrace [OLE/DB Provider 'exoledb.DataSource.1'
IDBCreateSession::CreateSession returned 0x80150804].
Is there anybody out there who could help me;-)
regards
reinhold
1. Have you tried using a UDL connection to connect to the SQL server?
2. Please refer to 287534 PRB: ExOLEDB Provider Cannot Access or Create
Items Remotely http://support.microsoft.com/?id=287534 which explains some
more information.
thanks,
Vikram
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||Thanks Vikram,
I've resolved the problem in the meanwhile.
It was related to casesensitivity. When indicating path to webstorage via
"file://.." path must be casesensitive as it seems.
thanks
reinhold
"Vikram Jayaram [MS]" <vikramj@.online.microsoft.com> wrote in message
news:aAS$ZhobEHA.2880@.cpmsftngxa06.phx.gbl...
> 1. Have you tried using a UDL connection to connect to the SQL server?
> 2. Please refer to 287534 PRB: ExOLEDB Provider Cannot Access or Create
> Items Remotely http://support.microsoft.com/?id=287534 which explains some
> more information.
> thanks,
> Vikram
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>

Error when attempt to link to exchange

hello,
I try to add exchange server as linked server in mssql on SBS2003.
I use sp_addlinkedserver :
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders
Now when trying to run a query or listing tables in EM I always get the
following error:
Error 7304: A new session on OLE DB-Provider
'exoledb.DataSource.1' could not be created.
OLE DB-Errortrace [OLE/DB Provider 'exoledb.DataSource.1'
IDBCreateSession::CreateSession returned 0x80150804].
Is there anybody out there who could help me;-)
regards
reinhold1. Have you tried using a UDL connection to connect to the SQL server?
2. Please refer to 287534 PRB: ExOLEDB Provider Cannot Access or Create
Items Remotely http://support.microsoft.com/?id=287534 which explains some
more information.
thanks,
Vikram
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||Thanks Vikram,
I've resolved the problem in the meanwhile.
It was related to casesensitivity. When indicating path to webstorage via
"file://.." path must be casesensitive as it seems.
thanks
reinhold
"Vikram Jayaram [MS]" <vikramj@.online.microsoft.com> wrote in message
news:aAS$ZhobEHA.2880@.cpmsftngxa06.phx.gbl...
> 1. Have you tried using a UDL connection to connect to the SQL server?
> 2. Please refer to 287534 PRB: ExOLEDB Provider Cannot Access or Create
> Items Remotely http://support.microsoft.com/?id=287534 which explains some
> more information.
> thanks,
> Vikram
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>

Error when attempt to link to exchange

hello,
I try to add exchange server as linked server in mssql on SBS2003.
I use sp_addlinkedserver :
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders
Now when trying to run a query or listing tables in EM I always get the
following error:
Error 7304: A new session on OLE DB-Provider
'exoledb.DataSource.1' could not be created.
OLE DB-Errortrace [OLE/DB Provider 'exoledb.DataSource.1'
IDBCreateSession::CreateSession returned 0x80150804].
Is there anybody out there who could help me;-)
regards
reinhold1. Have you tried using a UDL connection to connect to the SQL server?
2. Please refer to 287534 PRB: ExOLEDB Provider Cannot Access or Create
Items Remotely http://support.microsoft.com/?id=287534 which explains some
more information.
thanks,
Vikram
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||Thanks Vikram,
I've resolved the problem in the meanwhile.
It was related to casesensitivity. When indicating path to webstorage via
"file://.." path must be casesensitive as it seems.
thanks
reinhold
"Vikram Jayaram [MS]" <vikramj@.online.microsoft.com> wrote in message
news:aAS$ZhobEHA.2880@.cpmsftngxa06.phx.gbl...
> 1. Have you tried using a UDL connection to connect to the SQL server?
> 2. Please refer to 287534 PRB: ExOLEDB Provider Cannot Access or Create
> Items Remotely http://support.microsoft.com/?id=287534 which explains some
> more information.
> thanks,
> Vikram
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>

Error starting the SQL service after renaming one of the log files..

Is there anyone out there who can help me ? Please ? ?
The log file for one of the MSSQL 2000 databases ha grown really big.
(15 GB)
After setting a limit on the size to grow, the log file date did not
modifie.
After a few weaks I stopped the SQL service, and renamed the log file.
When I was trying to start the SQL again, it would not start. Even
not when I gave the log file back its old name.
Is there any way to restart / restore the SQL service / database
without a backup ? ?
Regards,
ØivindWhen you try to start the service, what message do you get?
"oeej" <oeej@.netpower.no> wrote in message
news:ca674822.0309071518.24feabb9@.posting.google.com...
> Is there anyone out there who can help me ? Please ? ?
> The log file for one of the MSSQL 2000 databases ha grown really big.
> (15 GB)
> After setting a limit on the size to grow, the log file date did not
> modifie.
> After a few weaks I stopped the SQL service, and renamed the log file.
> When I was trying to start the SQL again, it would not start. Even
> not when I gave the log file back its old name.
> Is there any way to restart / restore the SQL service / database
> without a backup ? ?
> Regards,
> Øivind|||If the error messages are correct... simply
Restore database model with recovery
Restore database axdb with recovery
the error messages say you have started a recovery that was not completed..
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"oeej" <oeej@.netpower.no> wrote in message
news:ca674822.0309071518.24feabb9@.posting.google.com...
> Is there anyone out there who can help me ? Please ? ?
> The log file for one of the MSSQL 2000 databases ha grown really big.
> (15 GB)
> After setting a limit on the size to grow, the log file date did not
> modifie.
> After a few weaks I stopped the SQL service, and renamed the log file.
> When I was trying to start the SQL again, it would not start. Even
> not when I gave the log file back its old name.
> Is there any way to restart / restore the SQL service / database
> without a backup ? ?
> Regards,
> Øivind