Friday, March 30, 2012
problem with sqlserver 2005 express
I have database with atached datafile. when I am using Select command from
created table, there is not case sensitive in the result. I mean I have in
the table the row with value "Disp1" in col1, and when I am selecting with
filter Where col1="disp1" , I amd getting this one row where value is
"Disp1".
I saw in server explorer window, that connection have parameter Case
Sensitive, which value is False, but it is desabled and I can't change.
How to solve this problem.
Thanks
Collation is an attribute of the column in the table. A database has a default collation which is
applied if you don't specify a collation in the CREATE TABLE statement. Also, if you want a query to
be resolved with a different collation than the data is stored with, you can use COLLATE keyword in
the query.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Vaidas" <Vaidas@.discussions.microsoft.com> wrote in message
news:8E0BF60C-1A43-49F3-A41B-E1E05E30BE23@.microsoft.com...
>I am using VS2005 with sql server 2005 express.
> I have database with atached datafile. when I am using Select command from
> created table, there is not case sensitive in the result. I mean I have in
> the table the row with value "Disp1" in col1, and when I am selecting with
> filter Where col1="disp1" , I amd getting this one row where value is
> "Disp1".
> I saw in server explorer window, that connection have parameter Case
> Sensitive, which value is False, but it is desabled and I can't change.
> How to solve this problem.
> Thanks
>
problem with sqlserver 2005 express
I have database with atached datafile. when I am using Select command from
created table, there is not case sensitive in the result. I mean I have in
the table the row with value "Disp1" in col1, and when I am selecting with
filter Where col1="disp1" , I amd getting this one row where value is
"Disp1".
I saw in server explorer window, that connection have parameter Case
Sensitive, which value is False, but it is desabled and I can't change.
How to solve this problem.
Thanks
Either change the collation of the column or specify the collation
explicitly in the WHERE clause. You should read about collations in the
documentation first so that you understand how they work and the
implications of mixed collations, the impact on indexing, etc.
Although this question isn't specific to the version in general you
should post questions about 2005 to the 2005 newsgroups only:
http://communities.microsoft.com/new...=sqlserver2005
David Portas
SQL Server MVP
problem with sqlserver 2005 express
I have database with atached datafile. when I am using Select command from
created table, there is not case sensitive in the result. I mean I have in
the table the row with value "Disp1" in col1, and when I am selecting with
filter Where col1="disp1" , I amd getting this one row where value is
"Disp1".
I saw in server explorer window, that connection have parameter Case
Sensitive, which value is False, but it is desabled and I can't change.
How to solve this problem.
ThanksCollation is an attribute of the column in the table. A database has a default collation which is
applied if you don't specify a collation in the CREATE TABLE statement. Also, if you want a query to
be resolved with a different collation than the data is stored with, you can use COLLATE keyword in
the query.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Vaidas" <Vaidas@.discussions.microsoft.com> wrote in message
news:8E0BF60C-1A43-49F3-A41B-E1E05E30BE23@.microsoft.com...
>I am using VS2005 with sql server 2005 express.
> I have database with atached datafile. when I am using Select command from
> created table, there is not case sensitive in the result. I mean I have in
> the table the row with value "Disp1" in col1, and when I am selecting with
> filter Where col1="disp1" , I amd getting this one row where value is
> "Disp1".
> I saw in server explorer window, that connection have parameter Case
> Sensitive, which value is False, but it is desabled and I can't change.
> How to solve this problem.
> Thanks
>
problem with sqlserver 2005 express
I have database with atached datafile. when I am using Select command from
created table, there is not case sensitive in the result. I mean I have in
the table the row with value "Disp1" in col1, and when I am selecting with
filter Where col1="disp1" , I amd getting this one row where value is
"Disp1".
I saw in server explorer window, that connection have parameter Case
Sensitive, which value is False, but it is desabled and I can't change.
How to solve this problem.
ThanksUsing a case-sensitive collation such as Latin1_General_CS_AS for col1 when you create your table, or for the "=" comparison in your query should solve your problem. CS stands for "case sensitive" and AS for "Accent Sensitive." See
Working With Collations (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/61cdbb6b-3ca1-4d73-938b-22e4f06f75ea.htm) in SQL Server 2005 books online.
Eric
problem with sqlserver 2005 express
I have database with atached datafile. when I am using Select command from
created table, there is not case sensitive in the result. I mean I have in
the table the row with value "Disp1" in col1, and when I am selecting with
filter Where col1="disp1" , I amd getting this one row where value is
"Disp1".
I saw in server explorer window, that connection have parameter Case
Sensitive, which value is False, but it is desabled and I can't change.
How to solve this problem.
ThanksEither change the collation of the column or specify the collation
explicitly in the WHERE clause. You should read about collations in the
documentation first so that you understand how they work and the
implications of mixed collations, the impact on indexing, etc.
Although this question isn't specific to the version in general you
should post questions about 2005 to the 2005 newsgroups only:
http://communities.microsoft.com/ne...p=sqlserver2005
David Portas
SQL Server MVP
--sql
Wednesday, March 28, 2012
Problem with SQL Server Managment Studio Express CTP
Hi, I have installed the product in subject but after installation if a click on program to use it, i have no result.
Someone can tell me how i can control why it no work?
The real problem is that it no give me an error code simply the program not start.?!?!?
Thank's for your attention.
By Fabrizio
I find...
When you downloaded the updated Management Studio Express, did you see it take some time to download it again, or did it start immediately? (If it starts immediately, you're running a cached copy of the Windows installer package for SSMSE.)
If you rename the "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell" registry key to "HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellX" using regedit, SSMSE should start. This should not affect the stand-alone Books Online at all.
After you rename the registry key and then start Management Studio Express, does the splash Screen say "SQL Server Management Studio Express Edition" or just "Management Studio Express"? The November 11 download says "Management Studio Express."
Problem with SQL Server Express database...
ERROR: Cannot open user default database. Login failed. Login failed for user 'ALINE\Doug's Account'.You are here: Home :Our Menu :Drinks
The database service is running and my connection tests worked out ok. What's next?
TIA,
Doug
This is turning out to be a nightmare...|||You need to give ALINE\Doug's Account logon permission to your database. Check out theCREATE LOGIN topic in Books Online.Problem with SQL Server 2005 Express Edition
This place is my final hope.
I'll start from the beginning: I have a Windows application developed in C#.
It uses a SQL Server 2005 Express Edition database to store data. Now I have
created a deployment of this app and database, and I try to install it on my
own machine. No problems, works without errors.
Now, I put this deployment project on the network and a user downloads it to
his Vista machine and runs the setup. When he starts the app he gets the
following error message:
"Login failed for user "MyUser". The user is not associated with a thrusted
server connection".
The connection string I use in my application is this:
Server=.\SQLEXPRESS;Database=MyDB;User ID=MyUser;Password=thissucks
Since I have no control over the Vista machine, I can't force him/her to
create a new account that is thrusted. All I want is to deploy my app and
database, without having to worry about authorization and stuff. If
possible, it should allow for ALL users to connect and use it.
I have already tried alot of the suggestions I've found, but lets start all
over so it will be right. What should I do to remove this error? How can I
deploy my database without having to think about authorization/security
stuff?
TIA
PZPreben,
You deployed your database and your code, correct? A SQL Server login is
not in the database, but is stored in the master database. Does your
deployment include the step to create the SQL Server login "MyUser"?
If not, then you will need to supply a script to do that. Such as (from the
BOL):
CREATE LOGIN MyUser WITH PASSWORD = '3KHJ6dhx(0xVYsdf'
Another possibility is that you have created the login, but the client's SQL
Server 2005 Express installation was set with Authentication Mode = Windows
Authentication Mode. If so, that installation is not willing to accept a
SQL Login and will need to be changed to Mixed Mode.
RLF
"Preben Zacho" <post@.zacho-web.dk> wrote in message
news:OKXT6f4lHHA.1776@.TK2MSFTNGP05.phx.gbl...
> Ok, I've read almost a million ng postings on this, still I can't solve
> it. This place is my final hope.
> I'll start from the beginning: I have a Windows application developed in
> C#. It uses a SQL Server 2005 Express Edition database to store data. Now
> I have created a deployment of this app and database, and I try to install
> it on my own machine. No problems, works without errors.
> Now, I put this deployment project on the network and a user downloads it
> to his Vista machine and runs the setup. When he starts the app he gets
> the following error message:
> "Login failed for user "MyUser". The user is not associated with a
> thrusted
> server connection".
> The connection string I use in my application is this:
> Server=.\SQLEXPRESS;Database=MyDB;User ID=MyUser;Password=thissucks
> Since I have no control over the Vista machine, I can't force him/her to
> create a new account that is thrusted. All I want is to deploy my app and
> database, without having to worry about authorization and stuff. If
> possible, it should allow for ALL users to connect and use it.
> I have already tried alot of the suggestions I've found, but lets start
> all over so it will be right. What should I do to remove this error? How
> can I deploy my database without having to think about
> authorization/security stuff?
> TIA
> PZ
>
>|||Since you are specifying the user name and password in the connection string
I assume you are using SQL Server authentication for your logins rather than
Windows authentication. One cause for that error is trying to use a SQL
Server login on a database server that is configured to only accept Windows
logins.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Preben Zacho" <post@.zacho-web.dk> wrote in message
news:OKXT6f4lHHA.1776@.TK2MSFTNGP05.phx.gbl...
> Ok, I've read almost a million ng postings on this, still I can't solve
> it. This place is my final hope.
> I'll start from the beginning: I have a Windows application developed in
> C#. It uses a SQL Server 2005 Express Edition database to store data. Now
> I have created a deployment of this app and database, and I try to install
> it on my own machine. No problems, works without errors.
> Now, I put this deployment project on the network and a user downloads it
> to his Vista machine and runs the setup. When he starts the app he gets
> the following error message:
> "Login failed for user "MyUser". The user is not associated with a
> thrusted
> server connection".
> The connection string I use in my application is this:
> Server=.\SQLEXPRESS;Database=MyDB;User ID=MyUser;Password=thissucks
> Since I have no control over the Vista machine, I can't force him/her to
> create a new account that is thrusted. All I want is to deploy my app and
> database, without having to worry about authorization and stuff. If
> possible, it should allow for ALL users to connect and use it.
> I have already tried alot of the suggestions I've found, but lets start
> all over so it will be right. What should I do to remove this error? How
> can I deploy my database without having to think about
> authorization/security stuff?
> TIA
> PZ
>
>|||Hi Russell
> If not, then you will need to supply a script to do that. Such as (from
> the BOL):
> CREATE LOGIN MyUser WITH PASSWORD = '3KHJ6dhx(0xVYsdf'
I think so. I have 2 scripts that comes with the deployment: The first one
creates the user MyUser in the server scope. The next one creates the
database itself (thats what I mean with "deploying" the database). Both
scripts run in sqlcmd without errors. I then check to see if I can run a SQL
statements by doing this:
sqlcmd -S .\SQLEXPRESS
1> select * from customer
2> go
The SQL statement is then executed without any problems, so the database
seems to have been created alright.
>Another possibility is that you have created the login, but the client's
>SQL Server 2005 Express installation was set with Authentication Mode =
>Windows Authentication Mode. If so, that installation is not willing to
>accept a SQL Login and will need to be changed to Mixed Mode.
How do I check this on the remote machine? Can I somehow change this using a
script?
/PZ
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:%23%230xS27lHHA.4868@.TK2MSFTNGP06.phx.gbl...
> Preben,
> You deployed your database and your code, correct? A SQL Server login is
> not in the database, but is stored in the master database. Does your
> deployment include the step to create the SQL Server login "MyUser"?
> If not, then you will need to supply a script to do that. Such as (from
> the BOL):
> CREATE LOGIN MyUser WITH PASSWORD = '3KHJ6dhx(0xVYsdf'
> Another possibility is that you have created the login, but the client's
> SQL Server 2005 Express installation was set with Authentication Mode =
> Windows Authentication Mode. If so, that installation is not willing to
> accept a SQL Login and will need to be changed to Mixed Mode.
> RLF
> "Preben Zacho" <post@.zacho-web.dk> wrote in message
> news:OKXT6f4lHHA.1776@.TK2MSFTNGP05.phx.gbl...
>|||Hi Roger
How can I determine this? And how do I change it if that is the case?
/PZ
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:1105D112-C515-42E4-924D-85184144DC2A@.microsoft.com...
> Since you are specifying the user name and password in the connection
> string I assume you are using SQL Server authentication for your logins
> rather than Windows authentication. One cause for that error is trying to
> use a SQL Server login on a database server that is configured to only
> accept Windows logins.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Preben Zacho" <post@.zacho-web.dk> wrote in message
> news:OKXT6f4lHHA.1776@.TK2MSFTNGP05.phx.gbl...
>|||Here are the instructions for changing it.
http://msdn2.microsoft.com/en-us/library/ms188670.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Preben Zacho" <post@.zacho-web.dk> wrote in message
news:%23F%23hPh$lHHA.4568@.TK2MSFTNGP02.phx.gbl...
> Hi Roger
> How can I determine this? And how do I change it if that is the case?
> /PZ
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:1105D112-C515-42E4-924D-85184144DC2A@.microsoft.com...
>|||Hi Roger
This is a prerequisit deployment, which means the SQL Server 2005 Express
Edition is downloaded and installed automatically during setup and before
tha application is installed. As far as I know, the SQL Server Management
Studio is not by default part of this installation (at least I can't find
it). And I don't want my users to download additional software to get this
working.
The strange thing is this: I can execute a select statement using the SQLCMD
tool without any problems. And from the Visual Studio 2005 I can go to the
Server Tools and connect to the database as well and query tables there,
also without errors. But my application come up with the "Login failed for
user "MyUser". The user is not associated with a thrusted server connection"
message all the time. I was wondering if my connection string should be
turned to Windows authentication instead, which it seems both SQLCMD and
Visual Studio is using (cause I don't have to login when doing that).
/PZ
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:06C7E2FB-B373-4066-972B-EC2FB00D292E@.microsoft.com...
> Here are the instructions for changing it.
> http://msdn2.microsoft.com/en-us/library/ms188670.aspx
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Preben Zacho" <post@.zacho-web.dk> wrote in message
> news:%23F%23hPh$lHHA.4568@.TK2MSFTNGP02.phx.gbl...
>|||Ok, so I got it to work now. I simply changed from SQL Authentication to
Windows Authentication and changed my connection string. Seems that the
deployment goes smoothly after all, since when installating the SQL Server
2005 as prerequisit, the installing user is created as a login user. I was
not awear of that.
The database itself is then created using a script call to SQLCMD and the
application can run without errors.
I can live with that, it makes the installation quite simple after all.
/PZ
"Preben Zacho" <post@.zacho-web.dk> wrote in message
news:OKXT6f4lHHA.1776@.TK2MSFTNGP05.phx.gbl...
> Ok, I've read almost a million ng postings on this, still I can't solve
> it. This place is my final hope.
> I'll start from the beginning: I have a Windows application developed in
> C#. It uses a SQL Server 2005 Express Edition database to store data. Now
> I have created a deployment of this app and database, and I try to install
> it on my own machine. No problems, works without errors.
> Now, I put this deployment project on the network and a user downloads it
> to his Vista machine and runs the setup. When he starts the app he gets
> the following error message:
> "Login failed for user "MyUser". The user is not associated with a
> thrusted
> server connection".
> The connection string I use in my application is this:
> Server=.\SQLEXPRESS;Database=MyDB;User ID=MyUser;Password=thissucks
> Since I have no control over the Vista machine, I can't force him/her to
> create a new account that is thrusted. All I want is to deploy my app and
> database, without having to worry about authorization and stuff. If
> possible, it should allow for ALL users to connect and use it.
> I have already tried alot of the suggestions I've found, but lets start
> all over so it will be right. What should I do to remove this error? How
> can I deploy my database without having to think about
> authorization/security stuff?
> TIA
> PZ
>
>
Problem with SQL Server 2005 Express
Hello,
I am programmer from Bulgaria and I am new in working with SQL server. I have a problem and want to discuss.
Imagine that there is software system working on Windows XP professional, SQL Server 2005 express database, programs (source code on Microsoft C/C++) that connect to SQL Server 2005 express via ODBC and around 30 users that working 24 hours a day.
For simplicity let imagine that in database have 2 main tables. In first table users add record. The program get value of certain field from that record and add that value to certain field in existing record in second table. (For example => imagine that in first table insert record for sell of some good /document of sell/ and in the second table contain all amount of sells of that good.)
Everything goes fine and working very well, but sometimes (3 or 4 times a day) the data of second table don’t add the value. The users get angry and say that they have not security in the data. And I don’t know what to do, because the program is the same, only database is changed before a month to SQL Server 2005 express (before there was Access database).
Every update/change in database stays with transactions.
Please help me to resolve that problem. Have someone the same problem? Or may be I must make some settings in database, or in transaction manager (MSDTC), or etc.?
Greetings to everybody!
hi,
you do not say how you propagate the update to the 2nd table...
is there a trigger on the very fist table or do you just execute 2 UPDATE STATEMENTS?
check your code to verify the 2 updates stay in the very same transaction as well..
regards
|||Hi Andrea,
The software system that I am talking about has strong rules to modify database and nobody else outside that software system don’t modify database.
And because the system is complex I give an example only with 2 tables. In fact there are several tables in which the system add different certain fields. Every updates/modify of the tables stay in the body of transaction.
transaction per 1 record:
1. begin transaction
2. many changes (insert, delete and update records) on related tables
3. commit transaction
When I put the system on the test with test data everything is ok. When the users start to input data and get the results (reports and etc.) in real work everything is ok.
The problem is that sometimes transactions don’t work. (If for some document transaction not working and after that the same document are input again with the same conditions into the system => everything is ok for second case, but for first case have document and amount is not added).
For example =>
- the specialist for deliver of goods inputs document for deliver of goods and show me printed stores document that system print, but that quantity don’t go to store and trader can’t sell
- or trader make selling of goods and show me printed invoice that the system print, but the quantity in the store don’t decrease and he don’t know what quantity of goods are in the sore.
- or in account department account clerk make payment to some invoice and show me input document into the system for payment, but the invoice stays unpaid.
- into the manufacture are the same cases – in the system have document for production, but sometimes quantity of the production not go to the store and traders cant sell.
And etc.
If there was single case I will think that it is error of specialist that input data into the system. But it is system that works on heavy conditions – many documents are input ant people with different occupation working together into one software system and make management decisions. Therefore I think inaccuracy like this is unallowable.
May be triggers will solve the problem, but some parts of the software system must be develop again. (Still more that this system worked very well with Access database)
I need more ideas.
Thank you and regards.
|||
hi,
I do think you probably have to check your application code, as it seems transactions got broken and not rolled back for the entire enlisted actions...
but it's very difficult in this scenario to point a finger somewhere..
regards...
|||Hi Andrea,
I check ones again all source code that include input execute actions into transactions. There I don’t find any problem. But I see that the transactions are in the body of thread. This is because to avoid decrease of speed when many users working at the same time (in my servers program).
So, I remove threads and let the transactions run on the main program. Now I am waiting for results of the real work.
/This will decrease speed of my servers program because until the program run execute actions from one user without threads (in main servers program) the other users will wait/
May be the problem is when the transactions run in the body of threads.
I hope that someone from Microsoft corp. will check the situation – many transactions in the body of many threads – is there some problems?
Regards!
sql
Problem with SQL Server 2005 Express
Hello,
I am programmer from Bulgaria and I am new in working with SQL server. I have a problem and want to discuss.
Imagine that there is software system working on Windows XP professional, SQL Server 2005 express database, programs (source code on Microsoft C/C++) that connect to SQL Server 2005 express via ODBC and around 30 users that working 24 hours a day.
For simplicity let imagine that in database have 2 main tables. In first table users add record. The program get value of certain field from that record and add that value to certain field in existing record in second table. (For example => imagine that in first table insert record for sell of some good /document of sell/ and in the second table contain all amount of sells of that good.)
Everything goes fine and working very well, but sometimes (3 or 4 times a day) the data of second table don’t add the value. The users get angry and say that they have not security in the data. And I don’t know what to do, because the program is the same, only database is changed before a month to SQL Server 2005 express (before there was Access database).
Every update/change in database stays with transactions.
Please help me to resolve that problem. Have someone the same problem? Or may be I must make some settings in database, or in transaction manager (MSDTC), or etc.?
Greetings to everybody!
hi,
you do not say how you propagate the update to the 2nd table...
is there a trigger on the very fist table or do you just execute 2 UPDATE STATEMENTS?
check your code to verify the 2 updates stay in the very same transaction as well..
regards
|||Hi Andrea,
The software system that I am talking about has strong rules to modify database and nobody else outside that software system don’t modify database.
And because the system is complex I give an example only with 2 tables. In fact there are several tables in which the system add different certain fields. Every updates/modify of the tables stay in the body of transaction.
transaction per 1 record:
1. begin transaction
2. many changes (insert, delete and update records) on related tables
3. commit transaction
When I put the system on the test with test data everything is ok. When the users start to input data and get the results (reports and etc.) in real work everything is ok.
The problem is that sometimes transactions don’t work. (If for some document transaction not working and after that the same document are input again with the same conditions into the system => everything is ok for second case, but for first case have document and amount is not added).
For example =>
- the specialist for deliver of goods inputs document for deliver of goods and show me printed stores document that system print, but that quantity don’t go to store and trader can’t sell
- or trader make selling of goods and show me printed invoice that the system print, but the quantity in the store don’t decrease and he don’t know what quantity of goods are in the sore.
- or in account department account clerk make payment to some invoice and show me input document into the system for payment, but the invoice stays unpaid.
- into the manufacture are the same cases – in the system have document for production, but sometimes quantity of the production not go to the store and traders cant sell.
And etc.
If there was single case I will think that it is error of specialist that input data into the system. But it is system that works on heavy conditions – many documents are input ant people with different occupation working together into one software system and make management decisions. Therefore I think inaccuracy like this is unallowable.
May be triggers will solve the problem, but some parts of the software system must be develop again. (Still more that this system worked very well with Access database)
I need more ideas.
Thank you and regards.
|||
hi,
I do think you probably have to check your application code, as it seems transactions got broken and not rolled back for the entire enlisted actions...
but it's very difficult in this scenario to point a finger somewhere..
regards...
|||Hi Andrea,
I check ones again all source code that include input execute actions into transactions. There I don’t find any problem. But I see that the transactions are in the body of thread. This is because to avoid decrease of speed when many users working at the same time (in my servers program).
So, I remove threads and let the transactions run on the main program. Now I am waiting for results of the real work.
/This will decrease speed of my servers program because until the program run execute actions from one user without threads (in main servers program) the other users will wait/
May be the problem is when the transactions run in the body of threads.
I hope that someone from Microsoft corp. will check the situation – many transactions in the body of many threads – is there some problems?
Regards!
Wednesday, March 21, 2012
Problem with ServiceBroker
I use 2 SQL Server: 1 – SQL Server 2005 Enterprise on Windows Server 2003 (Itanium) and SQL Server Express on Windows XP Professional (Pentium).
I send the message from enterprise to express the message (at once I shall tell, that sending of the message in the opposite direction gives the same result) and I process the message on express. At first sight like all is correct. Messages I receive all, I read also all of them are correct. But further there are two strange things for me.
In the table sys.conversation_endpoints there is a record (one, irrespective of how many messages in one conversation) with “state=CD”. I read that they should be deleted after 30 minutes, but they did not. Using command … WITH CLEANUP helps but in a parallel way in Service Broker Profiler I observe occurrence of a mistake which occurs after closing dialogue.
I am disturbed with this mistake and the most important is that I not understand why it arises.
| EXPRESS | ||
| Event Class | EventSubClass | TextData |
| Broker:Message Classify | 1 - Local | |
| Broker:Conversation Group | 1 - Create | |
| Broker:Conversation | 12 - Dialog Created | STARTED_INBOUND |
| Broker:Conversation | 6 - Received Sequenced Message | CONVERSING |
| Broker:Remote Message Acknowledgement | 3 - Message with Acknowledgement Received | |
| Broker:Conversation | 6 - Received Sequenced Message | CONVERSING |
| Broker:Remote Message Acknowledgement | 3 - Message with Acknowledgement Received | |
| Broker:Conversation | 7 - Received END CONVERSATION | DISCONNECTED_INBOUND |
| Broker:Remote Message Acknowledgement | 3 - Message with Acknowledgement Received | |
| Broker:Activation | 1 - Start | |
| Broker:Message Classify | 2 - Remote | |
| Broker:Remote Message Acknowledgement | 2 - Acknowledgement Sent | |
| Broker:Conversation | 2 - END CONVERSATION | CLOSED |
| Broker:Conversation Group | ||
| Broker:Activation | 2 - Ended | |
| Broker:Connection | 4 - Closing | An error occurred while receiving data: '64(error not found)'. |
| Broker:Connection | 5 - Closed | |
| Enterprise | ||
| Event Class | EventSubClass | TextData |
| Broker:Conversation Group | 1 - Create | |
| Broker:Conversation | 11 - BEGIN DIALOG | STARTED_OUTBOUND |
| Broker:Conversation | 1 - SEND Message | CONVERSING |
| Broker:Message Classify | 2 - Remote | |
| Broker:Conversation | 1 - SEND Message | CONVERSING |
| Broker:Message Classify | 2 - Remote | |
| Broker:Conversation | 1 - SEND Message | CONVERSING |
| Broker:Message Classify | 2 - Remote | |
| Broker:Conversation | 2 - END CONVERSATION | DISCONNECTED_OUTBOUND |
| Broker:Conversation Group | 2 - Drop | |
| Broker:Message Classify | 2 - Remote | |
| Broker:Message Classify | 2 - Remote | |
| Broker:Remote Message Acknowledgement | 1 - Message with Acknowledgement Sent | |
| Broker:Remote Message Acknowledgement | 1 - Message with Acknowledgement Sent | |
| Broker:Remote Message Acknowledgement | 1 - Message with Acknowledgement Sent | |
| Broker:Message Classify | 1 - Local | |
| Broker:Conversation | 10 - Received END CONVERSATION Ack | CLOSED |
| Broker:Remote Message Acknowledgement | 4 - Acknowledgement Received | |
| Broker:Connection | 4 - Closing | |
| Broker:Connection | 5 - Closed | |
Yours faithfully,
From what I understand, you are doing a BEGIN DIALOG, followed by two SENDs and then END DIALOG, all from the initiator side (the enterprise instance).
The target side (express) is just passively receiving the messages, reacting with an END CONVERSATION itself when the it receives the END CONVERSATION message from the initiator.
In general, this pattern of BEGIN DIALOG/SEND/END (aka 'fire and forget') is not advisable. If the messages cannot be delivered (e.g. the target denies access to the service), the initiator never knows about this, since he already ended the conversation. My recomendation is to have the target end the dialog first, after receiving the two messages, and the initiator END CONVERSATION on it's turn as a reaction of receiving the end dialog message from target. Another side effect of this pattern of messages (when target never sends any message back) is that the target endpoint doesn't get deleted, and that is the problem you're seeing. This is a known issue and will be addressed in a next release.
If you're asking about the reason for the 'An error occurred while receiving data: '64(error not found)', this is simply because the connection between the two machines is timing out due to innactivity. One side will time out first (the enterprise in this case) and close the connection, the other side simply reports the fact that the connection was closed by the peer.
HTH,
~ Remus
Tuesday, March 20, 2012
problem with Server Management Studio Express and diagrames
so I have had a database in Sql Server 2000, in my DB i have made database diagrams.
now I have installed on other PC(where does't install sql 2000) Sql Server Management Studio Express where I have opened my db , bat db diagrams does't work.
what can I do? how can I solve this problem?
enyone can explain me?
thanks.
Management Studio can't open SQL 2000 diagrams, if you click on the diagrams branch of the tree it should ask if you want to install diagram support, once this is done you can create new diagrams.|||ok, bat when I opend diagrams branch of the tree, it doesn't ask if I want or not to install diagram|||hi,
usually you have to first import the database to the new SQL Server 2005 instance (as you already did)..
then modify the compatibility level to 90 via the SSMSE, database properties (options tab), and finally set the database owner to a valid principal, again SSMSE, database properties (files tab, "owner" peroperty )...
then you should be able to access database diagrams..
regards
Monday, March 12, 2012
Problem with sample databases
I have installed SQL Express 2005 together with VS 2005. After a while I found out that the sample databases (Northwind and Pubs) were missing, so I installed them. According to the 'Readme', which comes with the installation I could choose between attaching the db to the Server or running a SQL script.
Neither works. I've read this link about remote connections (http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx). My development machine is just a local single computer and I still get this error message:
'An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact under the default settings SQL Server does not allow remote connections.'
I' ve opened TCP/IP and Named Pipes and I get the same result when trying to connect from the Server Explorer in VS.
Thanks for your help.
Hey,
SQL Server 2005 doesn't install with the sample databases anymore; I am having training on it, and that is what I just found out. Also, to setup remote connections, you can do so in the SQL Server Surface Area Configuration.
Brian
|||Hey,
TCP/IP and Named Pipes are only selectable if you allow remote connections in the SQL Server Surface Area Configuration.
RTFT.
Anybody else coming up with an idea?
Problem with restoring an SQL 2K backup on to SQL 2005
"System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:\Program Files\Avidian Technologies\Prophet\avidian.mdf'. (Microsoft.SqlServer.Express.Smo)"
I'm not sure what is going on becuase I have no issues installing the backup on my XP Pro machine that has SQL Express 2005 Dev edition. So what I did was restore the backup on to SQL Express 2005 on my dev machine and backup again. Unfortunately when I took the newly created backup and tried again to restore the database on to my window server 2003 machine it failed again. Exact same message was displayed.
Any suggestions or help would be greatful.
Thanks,
Rodney
Rodney, here is a thread on the engine forum regarding this issue. It looks like they solved it. Can you read through it and see if it works for you?
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=169145&SiteID=1
Thanks,
Sam Lester (MSFT)
Monday, February 20, 2012
Problem with performance after leaving SQL Server Express idle for some time
Hi, everyone!
I have this strange problem... After every time my application leaves sql-server idle (doesn't send anything, doesn't retrieve anything) next command to sql-server processes really long.
I've also noticed this bug/feature/misconfiguration even if I open a DB in Management Studio...
Please, could someone tell me, is there any timer that "puts a DB to sleep" if no one is using it for some time? Can I change the way server behaves in this situation?
I saw this problem once long ago when we had to shovel coal into our PC's to make them run.
In our case, the database server was on a dedicated PC. Someone had installed a graphics-intensive screen-saver. Evertime the screen-saver kicked in performance dropped.
Another possibility: Opening a DB connection takes a long time. You may be timing out and getting kicked out of the server.
|||Thanks for the reply.
Well, that's not screen saver, definitely. I had this problem both on local machine (obviously when screen saver is not running :) ) and on a remote server, but I know for sure what is going on there too.
And as I understood the second possible reason you're saying server kicks me out, but I've set the timeout to pretty big number (before I did that, I actually was kicked out all the time), but now I don't get connection-not-opened exception or anything else like that.
Everything works pretty smooth all the time (like ASP.NET page loads fast, fast postbacks, management studio works fine) until I leave server alone for some time. After that this damn lag happens (for one time, like it's reconnecting to DB or smth like that) and everything works fine again.
Maybe it's not the database but asp.net.
When all sessions end or time out, your application is shut down. See if the Application_End event is raised.
|||No, i don't think so... First of all, I used the same app with MSDE 2000 and didn't have this issue. Second, I see this issue not only when using my asp.net app, but also WinForms app, and even Management Studio (as I think I mentioned in the first post).