Recently I was working on copying a database containing UK Postcodes and their associated geo-location data to one more SQL 2008 server.

The chart restricted a listing of all UK Postcodes along with their longitude and latitude and a Geo Location column that was based on the new SQL 2008 Data Type Geography.

On trying to use the Import/Export wizard to copy the data I had to do the Review Data Type Mapping page and was faced with the error message as follows:

Found 1 unknown column type conversion(s) you are only allowed to save the package.

What am I missing? Please help.

Hi, I keep getting this error when I try to save an Incident. 

This comes up every time I click on “Save”, whether I did update any field or not.

Though I don’t think it’s a BR, I’d appreciate if you can give me an easy way to disable all BR’s so I can be sure it’s not one.  I’m thinking that SDE is trying to write a row that contains a sequence that is already in the _SMDBA_._TELDETAI_ table. Then again, I’m not quite sure.  Hope you can help.

Error:

VBScript:BMC Service Desk Express

I used the Configure Distribution Wizard in my MS SQL Server 2005 to setup its distributor.

However, I end up with this error box. How to get rid of this and what is the possible fix?

Thanks.

Detach database failed for Server 'Instance Name'. (Microsoft.SqlServer.Smo)

Additional information:

An exception occurred while executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.ConnectionInfo)

Cannot execute 'sp_updatestats' because the database is in read-only access mode.

What are stored procedures in sql server 2008? How does it work?

I am having problem with MS SQL Server 2012 RC0 and Master Data Services.

When starting the Master Data Configuration Manager, the error below appeared.

Any workaround with this issue that may help will be appreciated.

Thank you.

Confirm Prerequisites

Windows PowerShell

Version 2.0

Internet Information Services

Before creating an MDS web application, you must correct the following errors:

Internet Information Services (IIS) is not configured on this server.

Hello everyone!

I am facing problem while trying to create pool backend with OCS.

Normally, I found this error "Pool backend discovery failed" but it also remained the same after reinstalling the Backwards compatibility.

I am using the SQL Express 2005 SP3.My database is in the local server while everything seems to be ok but failed to work.

Need a suggestion. Thanks.

Error:

An error occurred during the pool backend detection:

Failed to export pool backend configuration database settings.

Unable to get back the configuration database version..

Hello.

Currently I am using SQL Server Database 2008 and I want to create a linked server and make a connection with Microsoft Access database named Nwind.mdb.  I have issued a command in the SQL server Management Studio, like this:

execute sp_addlinkedserver 'North','OLE DB Provider for Jet',
'Microsoft.Jet.OLEDB.4.0','d:sql_serverNwind.mdb'

The command was completes successfully.

At this time, I wished to make a query on the customer table in access database and issue the following command:

select * from North…customers

I got the following error message after clicking the execute button:

Msg 7308, Level 16, State 1, Line 1

Hello,

Hi
For the preparation on SQLBits 9 conference, I have passed a number of times on making virtual environments to manifest Microsoft business intelligence goods. While I want to form a service application and alternative for Power Pivot I am facing a problem continuously according with the text “Error. Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’.”
Give me a solution please. Thanks a lot.

Error

Error

I am getting error during installation of Mysql server. It always comes to the 3rd steps and stops.