Database

Eddy Vluggen25-Jun-12 0:45

Eddy Vluggen

25-Jun-12 0:45

Can't be done; the Administrator of the local computer is considered to be the owner of his/her data.

Alternatively, you might consider another database, or hosting your server on a different machine than the users'.

Bastard Programmer from Hell Suspicious | :suss:

Kujtim Hyseni25-Jun-12 1:13

25-Jun-12 1:13

Can you give any details (how to consider another database)?

Eddy Vluggen25-Jun-12 1:17

Eddy Vluggen

25-Jun-12 1:17

Kujtim Hyseni wrote:
Can you give any details (how to consider another database)?

A comparison on databases can be found here[^]. Both MySQL and Oracle provide free alternatives that may fit your requirements.

Bastard Programmer from Hell Suspicious | :suss:

Kujtim Hyseni25-Jun-12 1:20

25-Jun-12 1:20

You didn't provided solution, that is just an article of capabilities. I need short and precise guide. By the way, I don't use MySQL nor Oracle.

Eddy Vluggen25-Jun-12 1:31

Eddy Vluggen

25-Jun-12 1:31

Kujtim Hyseni wrote:
You didn't provided solution, that is just an article of capabilities.

I don't have to provide a solution. I'm not at work, this 'advice' is being given in my own spare time. I could be doing something productive, like the dishes, but I had chosen to answer this question. Might benefit someone, and I'm sure the dishes do not mind waiting Smile | :)

Kujtim Hyseni wrote:
I need short and precise guide.

You already have - it's called the documentation[^]. Right on the first lines, it states short and precise;

txt

There are two possible modes: Windows Authentication mode and mixed mode.

Kujtim Hyseni wrote:
By the way, I don't use MySQL nor Oracle.

They were provided as alternative solutions to your problem.

I'm not going to provide any further pointers, as doing the dishes seems like a more important task suddenly.

Bastard Programmer from Hell Suspicious | :suss:

Jörgen Andersson25-Jun-12 6:22

Jörgen Andersson

25-Jun-12 6:22

Doing dishes is definitely underrated. Big Grin | :-D

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

jschell25-Jun-12 10:15

How To Convert Sql Query Result Into Report

25-Jun-12 10:15

Why don't you just limit access?

The database server should be on a secured box anyways and logins to that box should be limited to only a few people in the organization.

All other access to the database are via login credentials.

thakrerakesh22-Jun-12 22:28

thakrerakesh

22-Jun-12 22:28

Hi,

I have to convert Sql Query Result Into Report like crystal report or pdf format.

Suppose I run query

select EmpName, EmpDepartment from MasterDepartment.

EmpName EmpDepartment

Rakesh IT

Shirish IT

Shalu HR

This way I want to print in PDF file

Re: How To Convert Sql Query Result Into Report

Richard MacCutchan22-Jun-12 22:39

Richard MacCutchan

22-Jun-12 22:39

thakrerakesh wrote:
This way I want to print in PDF file

Then you need to use some library to produce the PDF output; take a look at iTextSharp[^].

speaking as ...

NOLOCK Applicable to All Tables

vvashishta21-Jun-12 20:05

vvashishta

21-Jun-12 20:05

if i apply a NOLOCK on one table in a Stored Procedure then will it be applicable to all other tables consumed in that Stored Procedure too automatically

- Happy Coding -
Vishal Vashishta

Re: NOLOCK Applicable to All Tables

Corporal Agarn22-Jun-12 2:04

Corporal Agarn

22-Jun-12 2:04

No.

Re: NOLOCK Applicable to All Tables

vvashishta25-Jun-12 20:31

vvashishta

25-Jun-12 20:31

Ok ... but can you make me clear little bit more about the NOLOCK concept,any article you want to refer.?

- Happy Coding -
Vishal Vashishta

Re: NOLOCK Applicable to All Tables

Corporal Agarn3-Jul-12 7:26

Corporal Agarn

3-Jul-12 7:26

Sorry to take so long to get back with you but I was on vacation.
Take a look at:

SQL

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED --avoids deadlock

Since NOLOCK is a 'hint' it is only for the one command.

How to get a static result from a table?

daiwuju21-Jun-12 5:10

daiwuju

21-Jun-12 5:10

I have a table in SQL Server 2008 like this:
EventID UserID State
1 0987 A
2 0987 A
3 0987 B
4 0956 A
5 0987 A
6 0019 A
7 0019 B
8 1289 B
9 1289 B
10 0019 A

I want to get some results from this table in such form:
UserID StateCount_of_A StateCount_of_B
0987 3 1
0019 2 1
1289 0 2
0956 1 0

I have try a few days, but I could get a disappointed result for ony one UserID. My result likes this one, for example with UserID 0987:
StateCount_of_A 3
StateCount_of_B 1

Thanks for anyone who could give me some tip.

David Mujica21-Jun-12 5:34

David Mujica

21-Jun-12 5:34

Try ...

Select EventID,(select count(*) from <myeventtable> E2 where E1.EventID = E2.EventID) As Count_of_A, (select count(*) from <myeventtable> E3 where E1.EventID = E3.EventID) As Count_of_B,
from <myeventtable> E1

Remeber to Vote. Cool | :cool:

Mycroft Holmes22-Jun-12 13:14

Mycroft Holmes

22-Jun-12 13:14

You seemed to have picked up a stalker or someone objects to the unformatted code or you are getting a reaction to your sig!

Never underestimate the power of human stupidity
RAH

Luc Pattyn21-Jun-12 5:39

Luc Pattyn

21-Jun-12 5:39

I haven't tried this, however my first try would look like this:

SELECT DISTINCT UserID, StateCount_of_A, StateCount_of_B FROM tablename AS T1
LEFT JOIN (SELECT UserID, COUNT(*) AS StateCount_of_A FROM tablename AS TA WHERE State='A') ON TA.UserID = T1.UserID
LEFT JOIN (SELECT UserID, COUNT(*) AS StateCount_of_B FROM tablename AS TB WHERE State='B') ON TB.UserID = T1.UserID
ORDER BY UserID

(Actually I would try a subset of it with a single state first, then expand for the exact requirements).

The fundamental trick is to use the same table more than once, and give each "instance" a different name using the AS keyword.

And then one might have to throw in a couple of COALESCE functions to replace null counts by zeroes.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Cannot Register New Server in SQL Server 2008

PIEBALDconsult21-Jun-12 6:32

PIEBALDconsult

21-Jun-12 6:32

SELECT UserId
,SUM(StateA) StateCount_of_A
,SUM(StateB)  StateCount_of_B
FROM (
  SELECT UserId
  ,CASE WHEN [State]='A' THEN 1 ELSE 0 END StateA
  ,CASE WHEN [State]='B' THEN 1 ELSE 0 END StateB
  FROM Junk
) T
GROUP BY UserID

Kujtim Hyseni21-Jun-12 2:31

21-Jun-12 2:31

Hello,

I cannot register new server in SQL Server 2008. I can save it but cannot start all the items (Start, Stop, ...) under Service Control menu appear disabled.

jschell22-Jun-12 13:24

22-Jun-12 13:24

Kujtim Hyseni wrote:
I cannot register new server in SQL Server 2008

What does that mean exactly?

Are you saying that you INSTALLED sql server and start is not enabled in the windows services control panel applet?

Kujtim Hyseni23-Jun-12 1:02

23-Jun-12 1:02

No, my 'base' or don't know how to call it server works fine and I am connecting to it as usual via 'Microsoft SQL Server Management Studio'. But when I enter to 'Microsoft SQL Server Management Studio' and try to register new server i.e. from the menu I choose from menu 'Register...' then appears the form 'New Server Registration' I cannot save this new server but cannot start it.

jschell24-Jun-12 12:17

24-Jun-12 12:17

When you went to the register dialog did you hit 'test'?

If you did and it worked then can you log into the other box and start and stop the server from there? (Presumably you are using windows authentication.)

Kujtim Hyseni24-Jun-12 22:45

24-Jun-12 22:45

Yes I hit 'test' but I got the following message:

-------------------
Testing the registered server failed. Verify the server name, login credntials, and database, and then click Test again.

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: Named Pipes Provider, error: 40- Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

Yes I am using Windows authentication (in fact I can login via 'sa' also).

jschell25-Jun-12 9:34

25-Jun-12 9:34

Kujtim Hyseni wrote:
Yes I hit 'test' but I got the following message:

So of course that is why you cannot now interact with it.

Kujtim Hyseni25-Jun-12 10:35