Hi,

I want some details on ENTERPRISE database:

1. How many people can work in this kind of database?

2. Does it use both LANs and WANs?

3. Is it only limited to a city or does it run all over the world?

4. How does it differ from PERSONAL database and GROUPWORK database systems?

5. Is it more efficient than other databases?

I own a small business office and deal a lot with SQL servers and exchange servers. I get the following error when I try to use Microsoft Visual Studio 2005 Service Pack 1 design tools to open a database connection with Microsoft SQL Server 2008.

Microsoft Visual Studio

This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.

Hi there, I am a designer and I’d like to create a relational database which has a life cycle of many stages.  I understand that the life cycle of relational database is the cycle of changes and development.

Could anyone explain me that several stages of the life cycle so that I could design a good relational database which has some certain problems in that field.

Hello to all dbms experts,

I have an issue regarding usage of Interbase. I got a complaint from one of our users that he got an error message, whenever two of them are accessing the same record stored in the database. See the full view of the error below.

There was an unexpected error in the property page:

The transfer syntax is not supported by the RPC server.

(0x800706C2)

Please close the property page and try again.

Hi,

I have faced a strange problem and I cannot solve it. I have an ASP.net application and I have made a setup of the Informix .NET provider.

– When I run my Application with F5 in debug mode, everything works fine, but the same application with the same unchanged mode and on the same machine does not work on IIS7.

– When I run it on IIS7, the connection to the database opens fine, and after executing the IFXDataReader I receive a null value, already the same code, same machine, and same databases! What is the reason behind this?

Thanks in advance.

Hello everybody,

I need your help. I have one table called big _strings, and I created it using the following code:

Create table big_strings (Field_name text)

Then I wrote the following SQL Query:

Select subset (field_name, 1, 3) from big_strings;

But I get an error:

Error: Blobs are not allowed in this expression

Is there another way to select one part of a string in text field?

Thanks.

I have Microsoft Visual Studio 2010 Ultimate installed on Windows Server 2008 (x86 & x64) with Service Pack 2, 1GB RAM, 30GB of HD space, DirectX 9 capable video card running at 1024 x 768 .

While I was trying to debug a stored procedure, I got the following error message

There is no source code available for the current location

I tried logging in as a Sysadmin but it comes up with the same error. I tried performing `Allow SQL/CLR debugging` and restarted MS visual studio but the error persists. Could not find much in the web and this error is quite annoying ….

I have SQL server 2005 installed on my Win XP SP 2 machine. When I try to do a modification on my DataBase, it throws up an error message.

“A bad Database error has occurred “in SQL server.

Upgraded my XP machine to latest SP 3, but the error does come back. It is a fresh installation of SQL and I do not have any previous version installed. Not sure if anyone can help me with this error.

Recently I purchased a new Dell Laptop pre-installed with Windows 7. After finding out that all editions of SQL Server 2005 SP3 and SQL Server 2008 SP1 are supported on Windows 7, I purchased SQL server 2005( SP3) and installed it on my laptop. When I try to open up Visual Studio 2008 and connect to SQL Server database, I get an error message:

Unable to add data connection.
Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

Hello,