Sql Server 2005 Managment Studio Crashes Randomly

Sdf File Edited In SQL Server Managment Studio Crashes My Pocket Pc Application.
I have a sql server ce db file that I use in my pocket pc application. It seems to be working until I try to edit my .sdf file in SQL Server (2005) Managment Studio. After this I cannot open modified file in my application.
 
I receive native exception error when I call Open method for Connection object:
ExceptionCode: 0xc0000005
ExceptionAddress: 0x03f8aaac
Reading: 0x00000010
 
When I edit .sdf file in another pc it's all working.
 
My config is:
windows vista business
.net compact framework 2.0 sp2
sql server 2005
sql server 2005 compact edition
sql server 2005 compact edition server tools
sql server 2005 compact edition tools for visual studio 2005
 
Best regards
 
 
 
 

View Replies !

---

SQL Server 2005 Managment Studio Newbie: Can't See Stored Procedure
I just created a stored procedure in SQL Server 2005 management studio.  I went to my db and expanded the programmability folder then right clicked the stored procedures folder and created a stored procedure.  I saved the procedure as sp_getDistance in the default folder SQL managment studio picked.  Now when I went back to that stored procedure folder I did not see my stored procedure sp_getDistance, all that was there was the system stored procedure folder.  Did I save the stored procedure in the wrong place, or what did I do wrong.  I can't find the procedure anywhere, its just sitting in my My DocumentsSQL Server Management StudioProjectssp_getDistance.sql folder. Thanks,Kyle Spitzer 

View Replies !

---

SQL Server Managment Studio Express 2005 Import/Export Wizard
I've created a new database and restored the database from a backup. I'm wanting to import raw data from an excel spreadsheet into the tables of the new database.

When I right click on the database, and hover over tasks the import/ export data menu options are not in the menu.The menu items ends at 'Generate Scripts'.

I'm connected on a local instance to a registered server.

Can anyone advise?

View Replies !

---

Excel 2007 DataMining Add-in Database On SQL Server 2005 Destroyed By Using SQL Server Managment Studio?
Hello,

 

i have made some Data Mining Model  Examples in Excel 2007 (not temporarily!). They where there after leaving an re-opening Excel. I have used them several times. Then I want to look, if I can see them also via SQL Server Managment Studio in the Analysis Services. There where nothing in the DMAddInDB in Analysis Services.

And after this, in Excel my DataMining Models have disappeared and all Models i have made since this disappeared also.

 

Perhaps I have destroyed the database. But will this happen every time? Can I share Data Mining Models I have made with Excel with Projects in SQL Server Analysis Services?

 

Thanks

Berenice

View Replies !

---

Visual Studio 2005 Crashes During Report Deployment
Has anybody ever had VS2005 sometimes crash when deploying reports?  It only happens once and awhile, but it is annoying.  I was hoping this would go away with service pack 1, but it didn't.

Another problem that I thought would be fixed is when you try to close VS2005 after working on reports and it states "Cannot close because an active modal is active" occasionally.

BJ

View Replies !

---

Sql Server Managment Studio Express Question
Is there any known issue where SQL Server Management Studio Express CTP just fails to start without an error?

View Replies !

---

Vista, Varbinary(max) And SQL Server Managment Studio
I'm running into an issue that only occurs on Vista machines against a SQL Server 2005.  We have a table with a varbinary(MAX) column in which we store a csv/xls/xml file.  When I perform a 'select * from my_table' within Management Studio the column data returned is sporadic...some rows are filled out and some are not.  When performed on an XP machine all of the data is returned (every row's column is filled out).  Is this a known issue?  I tried searching for it but didn't find anything.
 
Thanks,
Nellie

View Replies !

---

SQL Server Managment Studio Repeated Logins
 

Presumably an easy question but every time I open a query file the SSMS requires me to login.  Very frustrating.  Cannot find a configuration option, properties attribute or other to turn this off.  Can anyone adivse how I can set up SMSS to require a login at the beginning of the session and then not again for each saved query I open?
 
Thanks.

View Replies !

---

Connecting My VB Database To SQL Server Managment Studio?
hi

i have created a sql database in visual studio pro and now i would like to connect to that database in SQL server managamenet studio.  so when i start SQL server i connect to the same instance as my database (wich is .SQLEXPRESS)  but i can't find my database in the object explorer?

View Replies !

---

Creating A New Database With Sql Server Managment Studio Express
I have SQL Server 2005 installed with Sql Server Management Studio Express and when I open up the Management Studio program and try to create a new Database Engine I am getting the below errors:
Create failed for Database 'rufnek'.  (Microsoft.SqlServer.Express.Smo)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

View Replies !

---

How To Write Database Scripts Using Sql Server Managment Studio
Hello All,
My boss told me that we can write migration scripts to database using Sql server management studio. can someone guide me or point to a website which explains in detail how to do this please. i want to learn this. or even a tutorial also would be great. i am interested in writing or executing scripts by using sql server management studio( in sql server 2005). i think its called sql enterprise manager in sql server 2000.
Thanks a lot.

View Replies !

---

SQL Server Managment Studio Showing Menus Multiple Times
 

My SQL Server Managment Studio has started showing 4 file Menus, 4 Edit Menus, 4 Windows, etc...  Also, I have 4 "New Query", 4 "Connect" buttons. 
 
Has any one seen this?  Is there some setting that got messed up?

View Replies !

---

Telnet Connection Works, Sql Cmd Connection Works, SQL Server Managment Studio 2005 Does Not
I'm having a strange problem with this but I know (and admit) that the problem is on my PC and nowhere else. My firewall was causing a problem because I was unable to PING the database server, switching this off gets a successful PING immediately. The most useful utility to date is running netstat -an in the command window. This illustrates all the connections that are live and ports that are being listed to. I can establish a connection both by running

 

telnet sql5.hostinguk.net 1433 and

sqlcmd -S sql5.hostinguk.net -U username -P password

 

See below:

 

Active Connections

Proto Local Address Foreign Address State

TCP 0.0.0.0:25 0.0.0.0:0 LISTENING

TCP 0.0.0.0:80 0.0.0.0:0 LISTENING

TCP 0.0.0.0:135 0.0.0.0:0 LISTENING

TCP 0.0.0.0:443 0.0.0.0:0 LISTENING

TCP 0.0.0.0:445 0.0.0.0:0 LISTENING

TCP 0.0.0.0:1026 0.0.0.0:0 LISTENING

TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING

TCP 81.105.102.47:1134 217.194.210.169:1433 ESTABLISHED

TCP 81.105.102.47:1135 217.194.210.169:1433 ESTABLISHED

TCP 127.0.0.1:1031 0.0.0.0:0 LISTENING

TCP 127.0.0.1:5354 0.0.0.0:0 LISTENING

TCP 127.0.0.1:51114 0.0.0.0:0 LISTENING

TCP 127.0.0.1:51201 0.0.0.0:0 LISTENING

TCP 127.0.0.1:51202 0.0.0.0:0 LISTENING

TCP 127.0.0.1:51203 0.0.0.0:0 LISTENING

TCP 127.0.0.1:51204 0.0.0.0:0 LISTENING

TCP 127.0.0.1:51206 0.0.0.0:0 LISTENING

UDP 0.0.0.0:445 *:*

UDP 0.0.0.0:500 *:*

UDP 0.0.0.0:1025 *:*

UDP 0.0.0.0:1030 *:*

UDP 0.0.0.0:3456 *:*

UDP 0.0.0.0:4500 *:*

UDP 81.105.102.47:123 *:*

UDP 81.105.102.47:1900 *:*

UDP 81.105.102.47:5353 *:*

UDP 127.0.0.1:123 *:*

UDP 127.0.0.1:1086 *:*

UDP 127.0.0.1:1900 *:*

 Both these utilities show as establishing a connection in netstat so I am able to connect the database server every time, this worked throughout yesterday and has continued this morning.

The problem is when I attempt to use SQL Server Management Studio. When I attempt to connect to tcp:sql5.hostinguk.net, 1433 nothing shows in netstat at all. There is an option to encrypt the connection in the connection properties tab in management studio, when I enable this I do get an entry in netstat -an, see below:

 

TCP 81.105.102.47:1138 217.194.210.169:1433 TIME_WAIT

TCP 81.105.102.47:1139 217.194.210.169:1433 TIME_WAIT

TCP 81.105.102.47:1140 217.194.210.169:1433 TIME_WAIT

 

Amost as if it's trying the different ports but you get this time_wait thing. The error message is more meaningful and hopefull because I get:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (.Net SqlClient Data Provider)

I would expect this as the DNS has not been advised to encrypt the conection.

This is much better than the : Login failed for user 'COX10289'. (.Net SqlClient Data Provider) that I get, irrespective of whether I enter a password or not.


This is on a XP machine trying to connect to the remote webhosting company via the internet.

I can ping the server

 I have enabled shared memory and tcp/ip in protocols, named pipes and via are disabled

I do not have any aliases set up

No I do not force encryption

 I wonder if you have any further suggestions to this problem?

 

View Replies !

---

Testing A Stored Procedure With Output Params In SQL Server Managment Studio
I have an SP like this (edited for brevity):

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[TESTING_SP]
@Username MediumText,
@Password MediumText,
@UserKey int OUTPUT,
@RoleKey int OUTPUT,
@UserGroupKey int OUTPUT,

AS

BEGIN

SELECT
@UserKey = UserKey
FROM UserProfile
WHERE Username = @UserName
AND [Password] = @Password
END

I want to execute this sp in Managment Studio (MS) and see what is being returned but I'm getting this error:

Msg 201, Level 16, State 4, Procedure TESTING_SP, Line 0
Procedure 'TESTING_SP' expects parameter '@UserKey', which was not supplied.

How do I set up the output parameters and then select the values in MS for testing purposes?

Thanks a ton for helping a noob.

View Replies !

---

Server Management Studio Crashes On Create Index
 

Hi
 
I'm trying to use a udt in a table creation, and everything works as expected, right until the moment where I rightclick on [Indexes] to create a new index.
 
Then I get this error:
 
TITLE: Microsoft SQL Server Management Studio
------------------------------
Cannot show requested dialog.
------------------------------
ADDITIONAL INFORMATION:
Cannot show requested dialog. (SqlMgmt)
------------------------------
Object reference not set to an instance of an object. (SqlManagerUI)
------------------------------
BUTTONS:
OK
------------------------------


This is the script I use to create the table:
 

exec sp_executeSql N'CREATE SCHEMA [TestSchema] AUTHORIZATION [dbo]'

GO

CREATE TYPE [TestSchema].[type_TestType]

FROM uniqueidentifier ;

GO

Create table [TestSchema].[Periode3]

(

Periode3_UID uniqueidentifier NOT NULL ROWGUIDCOL,

rowVersion timestamp NULL,

owner uniqueidentifier not null,

validFrom datetime

NOT NULL CONSTRAINT

DF_Periode_modified3 DEFAULT getdate()

);

Alter table [TestSchema].[Periode3]

add PeriodeType [TestSchema].[type_TestType];
 
now if I replace the 2 last lines with:
 

Alter table [TestSchema].[Periode3]

add PeriodeType uniqueidentifier;

 
everything works as expected.
 
Where did I go wrong ?
 
regards
Jens Chr

View Replies !

---

Managment Studio
Hi

I received the trial 2005 Enterprise edition software to give 2005 a shot. Everything installed fine but no Managment Studio to interface with it. All the documentation I read (like this http://msdn2.microsoft.com/en-us/library/ms174173.aspx ) just expects the software to be there.

I can't find it as a download. Does anyone know what the deal is?

Thanks

View Replies !

---

Promblem With Log In Managment Studio
hi

Until now I was using SQLServer Express edition and whenever I wanted to log in Management Studio In the Server Name section I used to wirte MyComputernameSQLExpress

but now I'm going to use Enterprise edition

what should I write in the Server Name section to log in Management studio??

 

View Replies !

---

Can Not Find Managment Studio
Trying out vista here...
 
So I installed standard edition of sql server x64 and sp2.
 
I can only find configuration tools in "All Programs/Microsoft SQL Server 2005/Configuration Tools/4 applications", I give all rights etc to my user, but where is managment studio..?
 
 

View Replies !

---

Promlem With Loging In Managment Studio
hi

I'm going to use Enterprise edition

when I want to log in Managment Studio I face a window asking me for Server Name in addition to Server Type and authentication mode.

what should I write in Server Name section.I know the format is:

ComputerNameInstance Name

but what should I write in Instance Name??

thanks

View Replies !

---

How To Setup Linked Servers With SQL Managment Studio
Hi Everyone,
I am using SQL Server 2005 with SQL Management Studio.
What I am trying to do is move tables and stored procedures from one database on one server to another database which is on a different server. Essentially, I am trying to move tables and stored procedures from a database on my local computer to a database on our staging server I was told the best way to do this would be to use a linked server. I have been trying to set one up using managment studio but right clicking on server-object and choosing 'new ---> Linked Server' but I have not been able to successfully create the connection.
Can anyone out there explain me to me how to setup the linked server using SQL 2005 Management Studio?
Thanks! 
 

View Replies !

---

How To Connect To Database In SQL Sever Managment Studio
hi
 i have created a .aspx page and a sql database in visual studio ,, my question is how can i connect that  database in SQL Server Managment Studio?

View Replies !

---

Modifying Triggers In Managment Studio Express
I have a database with an update trigger, which shows up under the Triggers object in the database tree.  When I modify the item and try to save it it prompts me for a disk location to save the query.   I then reopen the item on the db tree, and it shows the old code.  What am I doing wrong?

Mike

View Replies !

---

Studio Managment Can't Finish The Installation In Indows Vista Business
I tried to install

SQLServer2005_SSMSEE  in my notebook with vista business and nearly the end of installation the process is cancelled by an error.
its necessary install some application before? SQL Server Express is installed by default in the notebook.
 
thaks a lot and excuse for my bad english (bettr more for me is SPANISH)

View Replies !

---

SQL Server Express 2005 Managment Console Not Logging In
Hi all,

 

We have a machine with SQL Server 2005 Express installed and we use to have no problems connecting to this using the management studio using Windows Authentication. Since yesterday when we open the management studio and press connect using Windows authentication, the logon dialog remains active but does not disappear. In the backgroung I can see the name of the instance on the machine and after a few seconds it goes to green, to show its connected but I can't do anything without cancelling the logon. If I cancel the logon, it sets it is not connected to any server, if i try to launch the instance from the registered servers, with the green connected symbol it hangs.

 

I have left the logon dialog overnight (14 hours) and it still did not disappear. I am looking at any patches that may have been installed but none since the end of May...does anyone else have a similar problem?

View Replies !

---

Management Studio Crashes
I can open a single connection to the database engine successfully but if I try to open another connection ('New Query' or 'query with current connection') Management Studio just goes away without any errors.

I am utilizing a remote desktop connection to the server but if I open a connection from my desktop through Management Studio I can establish multiple connections (database engine, query, etc...) with no problems. There are no errors in the sql logs, event viewer or windows log.

Has anyone seen this? Any suggestions would be appreciated.

View Replies !

---

Visual Studio Crashes While Generating Report Model
Wasted a lot of time figuring out the possible cause of this. I was working in connected mode (with VSS), and when it tried to create a Report Model (after doing all its validations/checks), it had to check-out the project file, which is normal. But before doing so, it tries to check-out the .dsv file as well (data source view file from which report model is being generated). While attempting this, the visual studio crashes.
I could never guess that this could be an issue. All the time I was trying to figure out if there was anything wrong with the data in my tables.
So, for me, a simple solution worked - check-out the .dsv file before you start creating data model. I hope this may save time for others...

View Replies !

---

Visual Studio Crashes When Editing Data Flow Task
I used an evaluation version till last week.

Was working fine so I decided to buy a Standard License.

Installed during the weekend, I had many problems till I decided to reinstall completely Windows. I have installed SP1

Everything worked fine then, ONLY not one of my SSIS packages still works; I get following error when editing the data flow task

The thread 'Win32 Thread' (0x7e8) has exited with code 0 (0x0).

Unhandled exception at 0x54fc5e89 in devenv.exe: 0xC0000005: Access violation reading location 0x00000000.

Please help, this is a disaster otherwise

 

 

 

View Replies !

---

Frustrating Visual Studio Crashes When Adding Script Step
I have two similar packages that are both experiencing this issue.
 
I need to add a script step to generate an incrementing id for the packages.
 
Once I add the script step, and then save the package, next time I open the package I get a "Microsoft Visual Studio has encountered a problem and needs to close" error which kills off Visual Studio.
 
The error signature is:
EventType: clr20r3
P1: devenv.exe
P2: 8.0.50727.762
P3: 45716759
P4: microsoft.sqlserver.txscript
P5: 9.0.242.0
P6: 443f5ab8
P7: 67
P8: d
P9: bbp0yyyc15o2dbouwcacz2m0bodqkotn
 
If I move the error window to one side, delete the whole Script step, and save the Package, then I can reopen the package again without the error occurring.
 
Here is the actual code in my script step (in case its of any assistance...)
(I have retyped it from a printout, so it may not be 100%. DOCID is supposed to increment from 1. DREF1 is a system-unique id, that takes up from where the last batch left off, and is a string prefixed by "MP")
 



Code Snippet
 
Imports System
Imports System.Data
Imports System.math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dta.Runtime.Wrapper
 
Public Class ScriptMain

Inherits UserComponent
Dim ndx as Int32 = 0
 
Public Overrides Sub Input0_ProcessInputRow(Byval Row as Input0Buffer)

'
' Add your code here
'
Dim dref as String
 
ndx = ndx + 1
Row.DOCID = ndx
 
dref = "MP" + Ctype(ndx + Variables.MPIDOrig, String)
Row.DREF1 = dref
End Sub
 
Protected Overrides Sub finalize()

Variables.MPID = ndx + Variables.MPIDOrig
MyBase.Finalize()
End Sub
End Class
 
 


 
 

View Replies !

---

Business Intelligence Studio Crashes At The Point Of Completing Production Of A Model
Is there some memory limit on the size of models that can be successfully created as when I try to generate a model on a specific database I get the horrible Windows exception error in Visual Studio and it restarts leaving me without a model.

 

I have .99Gb of Ram, but a colleague has 1.99Gb of Ram and he appears to be able to generate the model successfully.

 

I can create models against older versions of the database successfully.

 

Surely there must be a friendlier way of trapping for insufficient memory problems rather than virtually completing a model and then robbing me of the model????

 

 

View Replies !

---

SQL Server 2005 Connection Crashes With Multiple User Clicking Same Link.
Hi,
I just developed a ASP.NET website with SQL Server 2005 as database. I am having connection crash problem when multiple user click on same link to fetch data from the database. If users click on different links or there is few seconds of time gap between the data access, then it works fine. But the connections crash problem only occurs when 2 or more users click same link at same time.
I am using the following kind of Datalayers to access the data from database:
public static ContentInformation GetContentForUpdate(int ContentId)
{
ContentInformation result = new ContentInformation(); ;
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.Connection = Connection;
command.CommandText = "Content_GetContentForUpdate1";
SqlParameter parameter = new SqlParameter("@ContentId", SqlDbType.Int);
parameter.Direction = ParameterDirection.Input;
parameter.Value = ContentId;
command.Parameters.Add(parameter);
try
{
command.Connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow);

if (reader.Read())
{
// read the data
}
reader.Close();
}
catch (SqlException ex)
{
Trace.TraceError(ex.Message);
throw ex;
}
finally
{
command.Connection.Close();
}
return result;
}
I would be really grateful if someone can help me out with this problem. Waiting for the soonest reply. Thanks.

View Replies !

---

SQL Server 2005 SP2 X64 Crashes...LazyWriter: Warning, No Free Buffers Found.
While waiting for the fax of instructions to contact MS Support, I thought I would post here (tried several times and no fax...)

 

We get this message in the log file and then all hell breaks loose until it resets memory.   The SQL Service continues working but nobody can connect for about 5 minutes and then is seems to reset itself.  This has happened three times over the past two weeks.  Only one time it did create the SQLDUMP files but all three occurences have practically the same entries. 

 

We are running SQL Server 2005 x64 SP2 under Windows 2003 x64 SP1.  We have 4GB RAM and SQL is configured to use 2GB of it.  We have a large number of databases (about 400) on this one instance that experiences this problem.  The server itself is not under a tremendous load.  All of the databases were recently upgraded from SQL 2000 SP4 32 bit instance.  The first occurence happened just days after the migration. 

 

 

----- Log Entries -----

 

 LazyWriter: warning, no free buffers found.

 

2007-06-14 14:15:56.18 spid3s     
Memory Manager
 VM Reserved = 4415288 KB
 VM Committed = 4398048 KB
 AWE Allocated = 0 KB
 Reserved Memory = 1024 KB
 Reserved Memory In Use = 0 KB

2007-06-14 14:15:56.18 spid3s     
Memory node Id = 0
 VM Reserved = 4409528 KB
 VM Committed = 4392376 KB
 AWE Allocated = 0 KB
 SinglePage Allocator = 1951840 KB
 MultiPage Allocator = 81680 KB

2007-06-14 14:15:56.18 spid3s     
MEMORYCLERK_SQLGENERAL (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 39264 KB
 MultiPage Allocator = 21944 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SQLBUFFERPOOL (Total)
 VM Reserved = 4214784 KB
 VM Committed = 4198400 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 0 KB
 MultiPage Allocator = 8 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SQLQUERYEXEC (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 264 KB
 MultiPage Allocator = 104 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SQLOPTIMIZER (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 26816 KB
 MultiPage Allocator = 96 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SQLUTILITIES (Total)
 VM Reserved = 120 KB
 VM Committed = 120 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 4728 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SQLSTORENG (Total)
 VM Reserved = 96768 KB
 VM Committed = 96768 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 62192 KB
 MultiPage Allocator = 27624 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SQLCONNECTIONPOOL (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 4392 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SQLCLR (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 8 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SQLSERVICEBROKER (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 624 KB
 MultiPage Allocator = 320 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SQLHTTP (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 8 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SNI (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 568 KB
 MultiPage Allocator = 16 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_FULLTEXT (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 16 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SQLXP (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 16 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_BHF (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 336 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SQLQERESERVATIONS (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 8192 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_HOST (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 24 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SOSNODE (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 42376 KB
 MultiPage Allocator = 27392 KB

2007-06-14 14:15:56.20 spid3s     
MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 48 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_OBJCP (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 352016 KB
 MultiPage Allocator = 432 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_SQLCP (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 953192 KB
 MultiPage Allocator = 3088 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_PHDR (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 308728 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_XPROC (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 56 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_TEMPTABLES (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 128 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_NOTIF (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 16 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_VIEWDEFINITIONS (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 16 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_XMLDBTYPE (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 8 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_XMLDBELEMENT (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 8 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_XMLDBATTRIBUTE (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 8 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_STACKFRAMES (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 0 KB
 MultiPage Allocator = 8 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_BROKERTBLACS (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 96 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_BROKERKEK (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 8 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_BROKERDSH (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 8 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_BROKERUSERCERTLOOKUP (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 8 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_BROKERRSB (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 8 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_BROKERREADONLY (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 32 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_BROKERTO (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 8 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_EVENTS (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 16 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
CACHESTORE_SYSTEMROWSET (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 43744 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
USERSTORE_SCHEMAMGR (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 30632 KB
 MultiPage Allocator = 16 KB

2007-06-14 14:15:56.20 spid3s     
USERSTORE_DBMETADATA (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 39856 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
USERSTORE_TOKENPERM (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 14536 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
USERSTORE_OBJPERM (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 14904 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
USERSTORE_SXC (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 936 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
OBJECTSTORE_LBSS (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 64 KB
 MultiPage Allocator = 400 KB

2007-06-14 14:15:56.20 spid3s     
OBJECTSTORE_SNI_PACKET (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 6584 KB
 MultiPage Allocator = 48 KB

2007-06-14 14:15:56.20 spid3s     
OBJECTSTORE_SERVICE_BROKER (Total)
 VM Reserved = 0 KB
 VM Committed = 0 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 272 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.20 spid3s     
OBJECTSTORE_LOCK_MANAGER (Total)
 VM Reserved = 8192 KB
 VM Committed = 8192 KB
 AWE Allocated = 0 KB
 SM Reserved = 0 KB
 SM Committed = 0 KB
 SinglePage Allocator = 4232 KB
 MultiPage Allocator = 0 KB

2007-06-14 14:15:56.21 spid3s      Buffer Distribution:  Stolen=22764 Free=0 Cached=221235
  Database (clean)=268686 Database (dirty)=3406
  I/O=0, Latched=5

2007-06-14 14:15:56.21 spid3s      Buffer Counts:  Committed=516096 Target=523990 Hashed=272097
  Internal Reservation=104798 External Reservation=1022
  Stolen Potential=252769
   Min Free=128 Visible=523990
   Available Paging File=4634734592
2007-06-14 14:15:56.21 spid3s      Procedure Cache:  TotalProcs=11768 TotalPages=202189 InUsePages=950

2007-06-14 14:15:56.21 spid3s      Process physical/virtual memory pressure: 0/0 System physical memory pressure: 0

2007-06-14 14:15:56.23 spid3s      Global Memory Objects:
  Resource= 2880
  Locks= 532
  SE Schema Mgr= 3653
  SQLCache= 1622
  Replication= 3
  ServerGlobal= 49
  XPGlobal= 2
  Xact= 165
  SETLS= 4
  DatasetMemObjs= 8
  SubpDescPmos= 4
  SortTables= 2

2007-06-14 14:15:56.23 spid3s      Query Memory Objects:  Grants=8 Waiting=0 Maximum=226034 Available=225010 Limit=226048

2007-06-14 14:15:56.23 spid3s      Query Memory Objects:  Next Request=0 Waiting For=0 Cost=0 Timeout=0 Wait Time=0 Last Target=237945

2007-06-14 14:15:56.23 spid3s      Small Query Memory Objects:  Grants=0 Waiting=0 Maximum=11895 Available=11895 Limit=11895

2007-06-14 14:15:56.24 spid3s     
Optimization Queue
 Overall Memory = 3440517120 Target Memory = 1485357056 Last Notification = GROW Timeout = 6 Early Termination Factor = 5
2007-06-14 14:15:56.24 spid3s     
Small Gateway
 Configured Units = 16 Available Units = 16 Acquires = 0
 Waiters = 0 Threshold Factor = 380000 Threshold = 380000
2007-06-14 14:15:56.24 spid3s     
Medium Gateway
 Configured Units = 4 Available Units = 4 Acquires = 0
 Waiters = 0 Threshold Factor = 12 Threshold = -1
2007-06-14 14:15:56.24 spid3s     
Big Gateway
 Configured Units = 1 Available Units = 1 Acquires = 0
 Waiters = 0 Threshold Factor = 8 Threshold = -1
2007-06-14 14:15:56.24 spid3s     
MEMORYBROKER_FOR_CACHE
 Allocations = 221239
 Rate = 0
 Target Allocations = 379816
 Future Allocations = 0
 Last Notification = GROW

2007-06-14 14:15:56.24 spid3s     
MEMORYBROKER_FOR_STEAL
 Allocations = 22741
 Rate = 0
 Target Allocations = 181318
 Future Allocations = 0
 Last Notification = GROW

2007-06-14 14:15:56.24 spid3s     
MEMORYBROKER_FOR_RESERVE
 Allocations = 1024
 Rate = 0
 Target Allocations = 253810
 Future Allocations = 95233
 Last Notification = GROW

2007-06-14 14:39:56.82 Server      Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 148160 KB. Approx CPU Used: kernel 125 ms, user 62 ms, Interval: 65000.
2007-06-14 14:40:56.84 Server      Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 218536 KB. Approx CPU Used: kernel 328 ms, user 93 ms, Interval: 125046.
2007-06-14 14:41:56.84 Server      Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 288960 KB. Approx CPU Used: kernel 515 ms, user 125 ms, Interval: 185046.
2007-06-14 14:42:56.84 Server      Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 366008 KB. Approx CPU Used: kernel 718 ms, user 171 ms, Interval: 245046.
2007-06-14 14:43:56.84 Server      Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 435992 KB. Approx CPU Used: kernel 968 ms, user 296 ms, Interval: 305046.
2007-06-14 14:44:56.84 Server      Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 505160 KB. Approx CPU Used: kernel 1203 ms, user 390 ms, Interval: 365046.
2007-06-14 14:45:56.84 Server      Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 572488 KB. Approx CPU Used: kernel 1468 ms, user 468 ms, Interval: 425046.
2007-06-14 14:46:56.84 Server      Resource Monitor (0x1180) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 639056 KB. Approx CPU Used: kernel 1703 ms, user 500 ms, Interval: 485046.

View Replies !

---

SQL Server 2005 Connection Crashes With Multiple User Clicking Same Link.
 

Hi,
I just developed a ASP.NET website with SQL Server 2005 as database. I am having connection crash problem when multiple user click on same link to fetch data from the database. If users click on different links or there is few seconds of time gap between the data access, then it works fine. But the connections crash problem only occurs when 2 or more users click same link at same time.
 
I am using the following kind of Datalayers to access the data from database:
 

public static ContentInformation GetContentForUpdate(int ContentId)

{

ContentInformation result = new ContentInformation(); ;

SqlCommand command = new SqlCommand();

command.CommandType = CommandType.StoredProcedure;

command.Connection = Connection;

command.CommandText = "Content_GetContentForUpdate1";

SqlParameter parameter = new SqlParameter("@ContentId", SqlDbType.Int);

parameter.Direction = ParameterDirection.Input;

parameter.Value = ContentId;

command.Parameters.Add(parameter);

try

{

command.Connection.Open();

SqlDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow);



if (reader.Read())

{

// read the data
}

reader.Close();

}

catch (SqlException ex)

{

Trace.TraceError(ex.Message);

throw ex;

}

finally

{

command.Connection.Close();

}

return result;

}

 
I would be really grateful if someone can help me out with this problem. Waiting for the soonest reply. Thanks.

View Replies !

---

SQL Server 2005 - Studio Express Vs. Visual Studio 2005 Install
I'm very confused.  I installed Visual Studio 2005 and thought I understood that SQL Server 2005 came with it, but it appears that it's SQL Server 2005 - Express.  Can anyone tell me what I need to do in order to get Data Transformation Services loaded or the equivalent of DTS in SQL Express? 
 
 

View Replies !

---

Merge Join Crashes Visual Studio With Win32 Exception For Client Tools Installations Only
I have a package that includes a Merge Join.  It runs fine on a machine with SQL Developer installed and also on a server with SQL Enterprise.  However on multiple machines with SQL Enterprise client tools installed, it crashes Visual Studio.

All environments are SQL Server 2005 SP1.  On one of the SQL Enterprise client tools machines, I have completely uninstalled SQL and VS, deleted their Program Files remmants and reinstalled with the same result.  The machine have been used reliably for several months for fulltime SSIS development and testing without any issues.  If the Merge Join object is deleted from that package, it can be run without error.  Merge Joins have been used successfully in other packages.

The error message caught by the VS JIT debugger is:

An unhandled win32 exception occurred in devenv.exe [756].

Sometimes the number at the end is 1220.

The crash occurs immediately after the Information message appears in the output window for "DTS.Pipeline Validation phase is beginning".  Data Viewer windows have already been loaded.  Removing them from the package does not avoid the crash.

I'm kinda stuck - this looks like a bug in Visual Studio?

Anyone out there seen this? I'd appreciate some help.

 Thanks - Mike

 

View Replies !

---

Problem Wiht &"Managment Studio Express&"
Hello,

I download and install SQL Server Express release version.(Install successfully)
Then I install the new tool "Management Studio Express", and I use it to connect to an instance SQL Server to manage a database.(Install successfully)

Then I close the Management Studio Express. And I install books on line on my computer. (Install successfully)

After i want to open one more time the tool Management Studio BUT ANYTHING. If I uninstall books online and then try again to open Management tool it pass.

What is the problem with new tool??

Why when i install books online I cannot open again Management Studio??

thanks

good night

View Replies !

---

MS Visual Studio 2005 Vs SQL Server Business Intelligence Development Studio
I recently installed the Evaluation Edition of SQL Server 2005 x64 and it appears that MS Visual Studio 2005 is installed in stead of SQL Server Business Intelligence Development Studio.  When I choose new project the only template available is "Blank Solution".  How do I get all the templates (i.e. Analysis Server Project, Integration Services Project, Report Model Project, Report Server Wizard project, etc.)? 

Or would it be better to uninstall MS Visual Studio 2005 and attempt to reinstall BIDS?

 

 

View Replies !

---

Visual Studio 2005 Standard And SQL Server Management Studio?
I am new to visual studio and I am still not sure of all its components and features.

I installed visual studio 2005 standard edition but cannot find SQL Server Management Studio?

I guess this must be because it is not included with Visual studio 2005 standard. Is it included with VS 2005 professional?

I want to add pictures of products to my shopping site using an SQL database and I’ve been told that SQL Server Management studio is required as it is a graphical tool.

How would I go about obtaining the SQL server management studio. There seems to be different versions of SQL server that it is confusing to know which one to purchase.

Will the SQL server 2005 version that comes with Visual studio standard be sufficient for me now right? I want to create a shopping site with hundreds, perhaps even thousands of products. I want to use an SQL server 2005 database. The database will include ‘dynamically generated’ product images if that is the correct terminology.

My goodness, it seems I still have so much to learn.

Thanks

View Replies !

---

Can I Install Visual Studio 2008 Without The SQL Server 2005 Express And Use Instead My SQL Server 2005 Developer Edition?
(1) I have already installed of SQL Server 2005 Developer Edition first.

(1) Can I install visual studio 2008 without the 2005 express edition of SQL server? Will be any  problems because I don't have express edition of SQL server? Do I need to install the express edition of SQL server as well?

(3) How to use SQL Server 2005 Developer Edition instance on visual studio 2008?

View Replies !

---

SQL Server 2005 Developer's Version Installation Problem -- No SQL Server 2005 Studio Manager Gets Installed.
I installed Visual Studio 2005 Professional then after that was installed and running, I tried to install the the SQL Server 2005 Developer's Edition which installed but I do not get the SQL Server 2005 Studio Manager.  I have remove and reinstalled but it never gets installed. Any ideas?

Chuck

View Replies !

---

Help: 64 Bit Sqlserver 2005 EE Crashes Using DB2OLEDB
 

EXEC sp_addlinkedserver
@server = 'XXXX', -- linked server name
@srvproduct = 'Microsoft OLE DB Provider for DB2',
@provider='DB2OLEDB',
@datasrc='XXXX',  -- As/400 machine name
@provstr='User ID=UUUU;Initial Catalog=XXXX;Default Isolation Level=NC;Mode=Read;Network Address=X.X.X.X;Package Collection=QGPL;DBMS Platform=DB2/AS400;Connection Pooling=True'
GO

EXEC sp_addlinkedsrvlogin 'XXX',false,'sqluser', 'as400user', 'as400password'
GO

SELECT * FROM OPENQUERY(XXXX,'SELECT count(*) FROM PRODDTA.F0911')

Works great and returns result in less than 1 second

SELECT * FROM OPENQUERY(XXXX,'SELECT * FROM PRODDTA.F4111 WHERE ILUKID = 4160460')

Does not return anything and crash sql server.

Any help much appreciated.

 

 

View Replies !

---

Calculated Field Crashes Vs 2005 Sp1 ?
Hi!

when I'm trying something litle bit more complex thing than string manipulation in calculated field ex: =RunningValue(Fields!SALES.Value, Sum)


It just crashes visual studio when trying to run the report?! I think this could state as a bug in RS?

View Replies !

---

SQL Server 2000 Randomly Slow
Hello there,

I'm using a SQL Server 2000 with a dozen of databases. The databases are rather small (all sizes together sum up to 10 GB).

The entire server gets extremelly slow from time to time (lasting a few days when it happens and suddently coming back to normality).  A profiler trace doesn't show anything strange (besides a lot of SQL Agent entries).

I pretty much tried to isolate every single application that makes use of the databases in that server and see if it was the cause of the problem, but I couldn't find any correlation.

I know the computer where this server runs is quite fragmented. Is there anyway I could get to know if this is the cause of my performance issues?

I don't know if this happens, but once the server simply went down for some 3 hours, and I wasn't able to bring it up in anyway. It eventually started working again by itself. The only thing I did in the meantime was to run DBCC CHECKDB a few times, always getting the response "No error found on the database".


Any hint on that?

View Replies !

---

Sql Server 2000 Randomly Slowing Down
Hello there,

I have a SQL Server 2000 with a dozen of databases. The databases are rather small (all sum up to 10 GB).

The entire server gets extremelly slow from time to time (lasting a few days when it happens and suddently coming back to normality).  A profiler trace doesn't show anything strange (besides a lot of SQL Agent entries).

I pretty much tried to isolate every single application that makes use of the databases in that server and see if it was the cause of the problem, but I couldn't find any correlation.

I know the computer where this server runs is quite fragmented. Is there any way I could make sure this is the cause of my performance issues?

I don't know if this might help, but once the server simply went down for some 3 hours, and I wasn't able to bring it up in any way. It eventually started working again by itself. The only thing I did in the meantime was to run DBCC CHECKDB a few times, always getting the response "No errors found on the database".


Any hint on that?

View Replies !

---

SQL Server Managment And Attachment!!!!!!!!!!!!!
I installed the SQL Server Managment for SQL Server 2005 express edition, and i tried to attach data located in "C:Documents and SettingsCipherMy DocumentsVisual Studio 2005WebSitesWebSite2App_Data", the problem is the browser window doesnt want to expand anything inside "C:Documents and SettingsCipher", what should i do, is the only solution 4 me to put all data in Sql folder?! 

View Replies !

---

Failed SQL 2005 SP1 Installations (Hotifx.exe Crashes)
i just don't kown was happening... please help!....

thanks!
11/06/2007 21:44:25.532 ================================================================================
11/06/2007 21:44:25.548 Hotfix package launched
11/06/2007 21:46:07.532 Attempting to install instance: SQL Server Native Client
11/06/2007 21:46:07.532 Attempting to install target: BTS-108
11/06/2007 21:46:07.548 Attempting to install file: sqlncli.msi
11/06/2007 21:46:07.673 Attempting to install file: \BTS-108c$4afc0bb080422f7b54a29ff48HotFixSqlncliFilessqlncli.msi
11/06/2007 21:46:07.688 Creating MSI install log file at: C:WINDOWSHotfixRedist9LogsRedist9_Hotfix_KB913090_sqlncli.msi.log
11/06/2007 21:46:07.719 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
11/06/2007 21:46:07.735 Failed to read registry key: Debug
11/06/2007 21:46:07.938 MSP returned 0: The installed software already has a higher version update applied.
Product version detected is 9.00.3042.00 while the update version is: 9.00.2047.00.
11/06/2007 21:46:07.954 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
11/06/2007 21:46:07.969 Failed to read registry key: Debug
11/06/2007 21:46:07.985 Successfully installed file: \BTS-108c$4afc0bb080422f7b54a29ff48HotFixSqlncliFilessqlncli.msi
11/06/2007 21:46:08.001 Successfully installed target: BTS-108
11/06/2007 21:46:08.016 Successfully installed instance: SQL Server Native Client
11/06/2007 21:46:08.048
11/06/2007 21:46:08.048 Product Status Summary:
11/06/2007 21:46:08.079   Product: SQL Server Native Client
11/06/2007 21:46:08.094     SQL Server Native Client (RTM )        - Success
11/06/2007 21:46:08.110
11/06/2007 21:46:08.126   Product: Setup Support Files
11/06/2007 21:46:08.141     Setup Support Files (RTM )        - Not Applied
11/06/2007 21:46:08.157
11/06/2007 21:46:08.173   Product: Database Services
11/06/2007 21:46:08.188     Database Services (RTM 1406 ENU)        - Not Applied
11/06/2007 21:46:08.204     Reporting Services (RTM 1406 ENU)        - Not Applied
11/06/2007 21:46:08.219
11/06/2007 21:46:08.235   Product: Database Services
11/06/2007 21:46:08.266     Database Services (SP2 3042 ENU)        - NA
11/06/2007 21:46:08.282       Details: This update requires service pack 0,1. The service pack for product instance SQLEXPRESS is 2. Download the update for service pack 2.
11/06/2007 21:46:08.313
11/06/2007 21:46:08.329   Product: Notification Services
11/06/2007 21:46:08.344     Notification Services (RTM 1406 ENU)        - Not Applied
11/06/2007 21:46:08.376
11/06/2007 21:46:08.391   Product: Integration Services
11/06/2007 21:46:08.438     Integration Services (RTM 1399 ENU)        - Not Applied
11/06/2007 21:46:08.469
11/06/2007 21:46:08.485   Product: Client Components
11/06/2007 21:46:08.501     Client Components (RTM 1406 ENU)        - Not Applied
11/06/2007 21:46:08.516
11/06/2007 21:46:08.532   Product: MSXML 6.0 Parser
11/06/2007 21:46:08.563     MSXML 6.0 Parser (RTM )        - Not Applied
11/06/2007 21:46:08.579
11/06/2007 21:46:08.610   Product: SQLXML4
11/06/2007 21:46:08.626     SQLXML4 (RTM )        - Not Applied
11/06/2007 21:46:08.641
11/06/2007 21:46:08.657   Product: Backward Compatibility
11/06/2007 21:46:08.688     Backward Compatibility (RTM )        - Not Applied
11/06/2007 21:46:08.704
11/06/2007 21:46:08.735   Product: Microsoft SQL Server VSS Writer
11/06/2007 21:46:08.751     Microsoft SQL Server VSS Writer (RTM )        - Not Applied
11/06/2007 21:46:08.766

View Replies !

---

Failed SQL 2005 SP1 Installations (Hotifx.exe Crashes)
I am seeing repeated failures installing SP1 database services with crashes in hotfix.exe being reported and the following appearing in log files:

Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.
Property(S): UpgradeInstruction = Connect to SQL instance ZENO as sysadmin
Launch SQL statement USE master
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstallsysdbupg.sql
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstallDbEngine_hotfix_install.sql
Launch script file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
epl_hotfix_install.sql
Stop service MSSQLSERVER
MSI (s) (38:80) [09:35:35:246]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 1 for SQL Server Database Services 2005 ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.log.

This is happening on a Windows 2003 SP1 system.

Any ideas?

View Replies !

---

MS -SQL Server 2000 -connection Closes Randomly
Hi,We have some console application which runs in background with thefollowing logical flow :Main(){loop (1..n){CreateThread(Function1)}}Function1(){Open SQLConnection;Loop Till No Data Found{Fetch N Records;For Each of N Records{Begin Transaction;Do DB Activity on the current record (Update);If Last operation Failed{DB Rollback;break;}If CommitFrequency reached{DB Commit;}}}Close SQLConnection;}After successfully executing some random number of records, theconnection object is abruptly closing (In the line marked RED). It isgiving "Connection Closed" exception on ExecuteQuery() call. Sometimesit is giving "Reader is already closed" while doing any Get()operation on the SQLReader object.We are usingVS.Net 1.0 with SP4SQLServer 2000(no SPs)1) We are making a direct call to SQL server from the App Layer andnotusing COM+ .. to maintain transactions. Transactions are maintainedpurely by the Conn transaction Object.2) We have not specified any TimeOut property in the ConnectionString.(Anyway also tried giving a huge value just for testing).Is there any default timeout that is there in MS SQL and if yes how tooffset it?ThanksRings

View Replies !

---

ReportServer 2005 Print Dialog Crashes Windows...
I'm a developer at a medium-sized installation using ReportServer 2005. There's a problem that occurs for some users and not others. After the ReportServer 2005 report has been generated, the user clicks the Print icon. The print dialog comes up; when they click the OK button on the Print dialog, the screen goes black and their machine reboots.

 

We've then gone to install the latest Microsoft updates on their machine, to no avail.

 

After the reboot, they can print from, e.g., Microsoft Word or other applications, but they crash the OS when they print from the ReportServer 2005 report.

 

I know the first time you print from ReportServer, it installs some software on your machine. I don't know if the problem is related to this.

 

Any ideas would be appreciated.

 

Charlie

View Replies !

---

How To Apply SQL Server 2005 Express SP1 To The Version Of SQL Server 2005 Express Which Installs With Visual Studio 2005?
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.

How can apply SQL Server 2005 Express SP1 to update this existing instance?

Currently, if I run this query:

SELECT @@version

I get the following:

Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)   Oct 14 2005 00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

After applying SP1, I should get 9.00.2047.00.


Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:

http://msdn.microsoft.com/vstudio/express/sql/download/


Thank you,

Bashman

View Replies !

---

How To Randomly Select Records From Sql Server 2000 To ASP.NET(vb Language)
Hai friends,,
  I have a table name "Student"
it contain 2 fields no ,name
no      name
1        Raja
2        Larsen
3        Ravi
4        Ankit
5        Eban
my questions  is I have a webform random.aspx
whenever any user open a webform random.aspx
it should display anyone of name  in a random order..... CODING:-
Dim cn As New System.Data.sqlclient.SqlConnectionDim rd As sqlDataReader
cn.ConnectionString = "Persist Security Info=False;User ID=sa;Initial Catalog=master;password=david;"
cn.Open()Dim cmd1 As New SqlCommand("select no,name from Student", cn)  ' how i can chage to random order....
rd = cmd1.ExecuteReader
rd.Read()
Response.Write(rd(0) & "." & rd(1))
rd.Close()
thank u..
Ambrose...
 
 

View Replies !

---

Access Data Base To SQL Server Managment
Hi all,

I have a data base made in MS access and i wanted to know if it is possible to import it into MS SQL server management. If it is possible could somebody write an example, from which i can learn how do i do that?

Thank you for your time and help
Best regards,
BoSCHoW.

bOSTJAN

View Replies !

---

Merge Replication - SQL Server 2005, Windows Vista And MSVisual Studio 2005
Hello everybody!

I hope that someone could help me.

I have a problem when i start sincronyzing with the emulator of MSVS2005 to SQL2005 in Windows Vista. I have the same program in the emulator, but sincronyzing with windows XP Pro and no problem...

 

I configure the connection to use the IUSR.

 

The source code that i use:

 

repl.InternetUrl = @"http://laptop/SQLMobileIIS/sqlcesa30.dll";

repl.Publisher = @"laptop";

repl.PublisherDatabase = @"database";

repl.PublisherSecurityMode = SecurityType.NTAuthentication;

repl.Publication = @"Pubdatabase";

repl.Subscriber = @"SQLMobile";

repl.SubscriberConnectionString = @"Data Source='" + nomeFicheiroBD + "';Password='3409'";

 

The error that returns is:

 

"Failure to connect to SQLServer with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect"

 

Does anybody knows what i can do?

HELP I NEED SOMEBODY  TO HELP!

Thanks!

View Replies !

---