While trying to make a gathered index or a table that doesn’t consist of clustered index,

I encountered an alert coming from SQL Server Management Studio stating that “Saving Changes is not permitted.

The changes you have made require the following tables to be dropped and re-created.

You have either made changes to a table that can’t be re-created or enables the option prevent saving changes that require the table to be re-created.” Clicking on the Cancel button will just open another alert from SSMS.

How can I handle this?

Save

Hi everybody.

I'm having issues with my SQL Sever, it suddenly stopped working. I'm really surprised since I haven't used it for months now, I also haven't changed any of the settings since the last time I used it. When I try to run my SQL Server I get the next message: "Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. For more information review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3417."

I have posted a screenshot of the error I got while I am applying a local administrator account to set up XenDesktop. I run the installation on a Win 2008 R2 Enterprise machine. I have yet to connect the server to a domain. I have an SQL Server 2008 R2 located on the exterior of the domain, and I would be keen on using that server for the XenDesktop Database.

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

Hello,

My database works very well on my hard disk. But whenever I try to run it on the server, I get the following error:

'ActiveX Component Can't Create Object'

Here's the code that activates the error:

Set appWord = GetObject("Word.Application")

Need some suggestions for this error. I am not able to make any updates there.

Thanks a lot.

Hi

 I am using Windows XP Professional with Microsoft Works 6.0. Two times I have seen one of my databases (Saved as "name.wdb") disappeared and renamed WK38XXXX and WK381298 "file" as an alternative as a works database (WDB).

When I am going to "open with" Microsoft Works it opens and lets me to save again as a WDB file. But I am afraid that I am heading for mislay my database. I get no warning or notice about this occurrence.

Need to know about its reason and how to avoid it?

Thanks in advance.

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..

Hi guys. I run SQL Server 2011 or also called as Denali CTP 1. Just today, I encountered an error when attempting to connect to SQL Server 2011 through SSMS.

The error is posted below.

Cannot connect to KodyazDenali
Additional information
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct, and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server)

I have a SQL Server Integration Services project which I needed to convert to SSIS 2012 RC0 and always failed with the error posted below. This project is configured with FTP Task and one of it is the FTP Server Port. It is set to 36360.

How can I get rid of the error?

Microsoft Visual Studio

There were errors while loading the package.

See the Error List for details.