Hi

I have a SQL server 2005 environment. When i try to run a query (select) it gives me an error. Error message is: server: Msg8134, Level 16,State 1,Line 1 Divide by Zero error encountered.

Please help me.

I want to get the total number of records retained without DUPLICATE ones in my database. IS this correct?

I want to do  business intelligence and data mining in SQL Server 2007. I am looking for learning resources. I 'm not a fresher. I 'm a bit familiar with databases.can you help me to get it done?

I want to export a report to excel by the database i have. It's based on SQL. It gets exported but when I open it shows me letters unrecognizable. What causes this?

Hi,

I am a system administrator of a SQL Server 2005 which uses windows authentication mode.our company using custom developed application running queries against that DB.user complain that custom application stops responding.

I tried to connect to that server by using SQL Server management studio but its not responding.

Please help.

Hi there,

I know a very little on SQL severs. Could you please clarify me a little bit on that ?

Thanks.

Hi ,

We have a database on DB-01 that is running an instance SQL server 2005.

Recently we faced a power outage and it forces to restart the DB-01 which now fails to start SQL server.

How can we restart it.

Please help.

Hi guys,

When trying to connect Change Lister to SQL server using the Microsoft Dynamic server, I get the following error message.

What should I do? Please help me.

Thanks.

Error:

The Microsoft Dynamics NAV Server cannot connect the Change

Listener to SQL Server because of the following error: Cannot 

open database "Demo Database NAV (6-0)" requested by the 

login. The login failed. 

While working with a client on a new VDI design and accomplishment an issue popped up which is associated with some of the configuration items in View 4.5 with Microsoft SQL Server 2008. The problem occurred in the configuration of the view proceedings database. On trying to include the SQL Server 2008 database to the View Admin Console the computer kept creating the same error message, although all the data was right and the database was already there on the server. I have included a screenshot of the error, and the text it contained, below:

Hi All,

I managed full installation of my server from scratch and did it in this order:

• Windows server 2008
• Active directory with DNS
• SQL server (all services running as administrator)
• IIS
• Master Data Service (MDS)

As MDS was completely installed the configuration manager was also in progress. I faced the error as follows:

“An unexpected error occurred: Some or all identity references could not be translated.”