Question of the Day

conectare OLAP de pe Windows 7

als — Tue, 04 Oct 2011 19:40:48 GMT

Salut,

Am o mica problema la un desktop pe care e instalat ca SO, Windows 7 pe 64 si Office 2010 tot pe 64. Problema e ca nu ma pot conecta la baza de date SQL prin OLAP. Imi apare urmatorul mesaj (pe care-l voi atasa printr-un print screen) :
"Initialization of the data source failed.
Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again , create a new data source to connect the database."

Sunt convins ca exista persoane care au mai intalnit aceeasi situatie...

Va multumesc anticipat.

datetime SQL vs Excel (why the difference?)

darius2 — Sun, 14 Mar 2010 20:48:33 GMT

select CAST(FLOOR(CAST(cast('2010-02-01' as datetime) AS FLOAT)) AS int) = 40208

40208 in Excel = 01/30/2010

SQL2005 Express nu se mai poate dezinstala/instala/modifica dupa SystemRestore

managerul — Thu, 23 Jul 2009 17:05:16 GMT

Salutare,

am un server care a avut brusc tot felul de probleme ( posibil ceva virusi ). Aveam un backup de SYstemState de o saptamana in urma dar nu am reusit sa-l pun, nu imi mergeau o gramada de servicii, si nu reuseam sa fac restore. Am pus o imgine de la sistem, doar ca era facuta de mai bine de 1 an. Am resaurat imaginea, am facut update la Windows, si apoi am pus System Stateul din ultima sapt. Totul a fost ok, AD merge ok, doar ca imaginea restaurata nu a avut si SQL 2005 Express Ed. si dupa ce am pus SystemState-ul, nu am mai putut dezisntala/modifica/ sau orice altceva cu SQL2005 Express. Au inceput tot felul de erori, cand am incercat sa fac ceva cu SQL-ul.

SQL-ul 2005 varianta Standard, era pe imagine si functioneaza fara probleme.

Am gasit ceva solutii pe internet, dar inca nu le-as incerca, inainte sa va intreb daca s-a intalnit cineva cu asa ceva, si are o solutie buna, testata.

Multumesc,

Dan

Remote Backup

florinmatinca — Mon, 15 Jun 2009 12:16:58 GMT

Salutare,

Ma gasesc in urmatoarea situatie : pe un server am SQL Server Express, iar pe un altul o versiune superioara de SQL Server.

M-ar interesa sa stiu daca este posibil sa creez un job pe al doilea server, care sa faca periodic un backup al bazei de date de pe primul server.

Este posibil ?

Multumesc.

Nume tabele?

nosferatu — Mon, 09 Feb 2009 19:12:40 GMT

Salut.
Am o intrebare.
In afara de cele cunoscute, respectiv cele enumerate de mine mai jos, ce nume de tabele mai pot fii:
user/s
admin/s
administrator
member/s
member_admin
user_admin

multumesc.

Are cineva idee?

AlexD — Thu, 30 Oct 2008 15:55:22 GMT

Salut,

are cineva idee de ce la executia query-ului

UPDATE Product SET UnitTechPrice=8.00 WHERE ProductID=499

folosind SQL Server Management Studio

apare eroarea:

Msg 544, Level 16, State 1, Procedure dbProdU, Line 15

Cannot insert explicit value for identity column in table 'Product' when IDENTITY_INSERT is set to OFF.

The statement has been terminated.

Precizare:

Am testat pe doua masini diferite, ambele cu SQL Server 2008 Standard Ed. Am restaurat aceeasi baza de date din acelasi fisier bak. Pe una eroarea de mai sus apare pe cealalta nu apare. Pare deci sa fie vorba de o setare la nivelul serverului si nu ceva legat de baza de date in sine.

Daca inainte de update adaug

SET IDENTITY_INSERT Product ON

functioneaza pe ambele.

Tabela Product contine o coloana ProductID int IDENTITY(1,1) NOT NULL care este si cheie primara.

Are cineva vre-o idee?

Multumesc

QOD 2006-10-10

ggciubuc — Tue, 10 Oct 2006 11:54:16 GMT

Let's say you uncheck the "User must change password at next login" (see QOD 2006-10-09 at http://sqlserver.ro/forums/thread/283.aspx )

and click on "OK" button. After following situation follow an error. Why and what should you do for that?

QOD 2006-10-12

ggciubuc — Thu, 12 Oct 2006 11:35:34 GMT

How can you see the last restore (NOT backup) date of your database ?

(At this kind of question in a day I answer in other day you answer, today is a day when you can answer)

QOD 70-431 2006-09-22 Objective: Installing and Configuring SQL Server 2005 - Verify prerequisites

xmldeveloper — Sat, 23 Sep 2006 10:16:07 GMT

You want to install SQL Server 2005 Standard Edition on a machine that has the following configuration:

CPU: Pentium III 600 Mhz

Memory: 256 MB

HDD: 80 GB (60GB free space).

You have to establish if this configuration satisifies the minimum hardware requirements and if not what component should be upgraded.

Place the mouse cursor HERE for the answer

Reference: http://msdn2.microsoft.com/en-us/library/ms143506.aspx

QOD 70-431 2006-09-21 Objective: Installing and Configuring SQL Server 2005 - Identify the external data source.

xmldeveloper — Thu, 21 Sep 2006 12:44:34 GMT

You want to create a stored procedure that will access a remote SQL Server named TestSrv.You add the TestSrv as a linked server using the following code:

USE master;
GO
EXEC sp_addlinkedserver 
   'TestSrv',
   N'SQL Server'
GO

You want to select data using the local stored procedure from the Sales.SalesOrderDetails table located in the remote database AdventureWorks.
How should you specify the table name ?

Place the mouse cursor HERE for the answer

Reference: http://msdn2.microsoft.com/en-us/library/ms190406.aspx

QOD 70-442 2006-09-16

xmldeveloper — Sat, 16 Sep 2006 08:19:54 GMT

Which T-SQL predicate allows you to search columns containing character-based data types for precise or fuzzy (less precise) matches to single words and phrases?

Place the mouse cursor HERE for the answer

QOD 70-431 2006-09-19 Objective Maintaining Databases - Manage Statistics

xmldeveloper — Tue, 19 Sep 2006 12:20:20 GMT

What statements allow you to manage statistics in SQL Server 2005 ?

Place the mouse cursor HERE for the answer

Reference: "Statistics Used by the Query Optimizer in Microsoft SQL Server 2005" http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx

QOD 70-431 2006-09-25 Objective: Implementing High Availability and Disaster Recovery - Manage database snapshots

xmldeveloper — Mon, 25 Sep 2006 18:23:37 GMT

On which SQL Server 2005 editions can you use database snapshots ?

Place the mouse cursor HERE for the answer

Reference: http://msdn2.microsoft.com/en-us/library/ms175158.aspx

QOD 70-431 2006-09-20 Objective: Maintaining Databases - Manage index fragmentation

xmldeveloper — Wed, 20 Sep 2006 08:04:56 GMT

What statement allows you to rebuild, reorganize, disable or enable an index in SQL Server 2005 ?

Place the mouse cursor HERE for the answer

Reference: http://msdn2.microsoft.com/en-us/library/ms188388.aspx

QOD 2006-10-09

ggciubuc — Mon, 09 Oct 2006 11:38:22 GMT

Click on OK button and you will have an error. Why?
(At this kind of question in a day I answer in other day you answer, today is a day when you'll answer)

QOD 70-431 2006-04-28

xmldeveloper — Fri, 28 Apr 2006 14:04:39 GMT

One of your users' connection is blocked by another one. What options do you have to get the session id of the blocking connection ?

Place the mouse cursor HERE for the answer

QOD 70-431 2006-04-17

xmldeveloper — Mon, 17 Apr 2006 19:18:49 GMT

You have created a view and you want to prevent that the base table or tables to be modified in a way that would affect the view definition.

What should you do ?

Place the mouse cursor HERE for the answer

Reference: CREATE VIEW (Transact-SQL)" http://msdn2.microsoft.com/en-us/library/ms187956(SQL.90).aspx

QOD 70-431 2006-04-14

xmldeveloper — Fri, 14 Apr 2006 10:11:57 GMT

What is the difference between the Lock:Deadlock event class and the Lock:Deadlock Chain event class ?

Place the mouse cursor HERE for the answer

Reference: "Lock:Deadlock Chain Event Class" http://msdn2.microsoft.com/en-US/library/ms189554(SQL.90).aspx

"Lock:Deadlock Event Class" http://msdn2.microsoft.com/en-US/library/ms181059(SQL.90).aspx

QOD 70-431 2006-04-13

xmldeveloper — Thu, 13 Apr 2006 13:15:30 GMT

You have created an HTTP Endpoint using the following code:

CREATE ENDPOINT my_endpoint

AS HTTP(

PATH = '/sql',

AUTHENTICATION = (INTEGRATED ),

PORTS = ( CLEAR ),

SITE = 'MYSERVER'

)

FOR SOAP (

WEBMETHOD 'GetUserList'

(name='MyDatabase.ApplicationSchema.GetUserList',

SCHEMA=STANDARD ),

WSDL = DEFAULT,

SCHEMA = STANDARD,

DATABASE = 'MyDatabase',

NAMESPACE = 'http://tempUri.org/'

);

However when you try to connect you obtain an error. What's the cause ?

Place the mouse cursor HERE for the answer

Reference: "CREATE ENDPOINT (Transact-SQL)"http://msdn2.microsoft.com/en-us/library/ms181591(SQL.90).aspx

QOD 70-431 2006-04-11

xmldeveloper — Tue, 11 Apr 2006 11:57:03 GMT

Which option of the bcp utility allows bulk copying data from a query ?

Place the mouse cursor HERE for the answer

Reference: "bcp Utility" http://msdn2.microsoft.com/en-us/library/ms162802(SQL.90).aspx

QOD 70-431 2006-04-10

xmldeveloper — Mon, 10 Apr 2006 12:48:59 GMT

Which feature of SQL Server 2005 allows measuring latency in transactional replication topologies ? The same feature allows validation of the connections between the Publisher, Distributor and Subscribers.

Place the mouse cursor HERE for the answer

Reference: "Measuring Latency and Validating Connections for Transactional Replication" http://msdn2.microsoft.com/en-US/library/ms151178(SQL.90).aspx

QOD 70-431 2006-04-08

xmldeveloper — Sat, 08 Apr 2006 09:26:54 GMT

Which Dynamic Management View can tell you which indexes are used ?

Place the mouse cursor HERE for the answer

QOD 70-431 2006-04-07

xmldeveloper — Fri, 07 Apr 2006 09:04:44 GMT

You have a FOR XML query using ELEMENTS directive. You query ignores columns having NULL value and you want to include them. What should you do ?

Place the mouse cursor HERE for the answer

QOD 70-431 2006-04-06

xmldeveloper — Thu, 06 Apr 2006 15:23:29 GMT

You have a SQL Server 2005 computer using TCP/IP with default settings. The server is protected by a firewall. You want to allow clients to connect to your SQL Server. What port should you open ?

Place the mouse cursor HERE for the answer

QOD 70-431 2006-03-20

xmldeveloper — Mon, 20 Mar 2006 13:11:08 GMT

What tool can be used to enable, disable, start, or stop the features, services, and remote connectivity of your SQL Server 2005 installations ?

Place the mouse cursor HERE for the answer