Can't clean buffer cache

Hi,

My problem is that I cannot completely clean buffer cache on SQL Server 2005 version 9.00.2047.00 (probably SP1).

Right after I run DBCC DROPCLEANBUFFERS in the context of my database (this is development server, and so far I am only the one who is working with a particular database), I run a script that quetries sys.dm_os_buffer_descriptors view also from the context of my database to make sure that the buffer cache is really clean. However it shows large number of entries totalling 42 MB.

I ran both DBCC an the script in the past too, and it always showed nothing in the results, that means that buffers were really clean. The reason why I am running this is for benchmarking of existing and new application.

Does anybody have any idea, suggestions, how to troubleshoot this issue ? I already closed all connections to this database, but rebooting the server is not an option since other people are also working on it.

Thanks

BoL (link) does suggest issuing a CHECKPOINT before the DBCC DROPCLEANBUFFERS, have you tried that?|||

Hi Mark

Moffs suggestion is correct, you will need to run the CHECKPOINT command.

Checkpoint all the databases that you want to have buffers to cold and then run the dbcc command.

I don't think you can get rid of all the buffers from the sysdatabases.

Could you please post the output of the following command once you have completed the checkpoint and dbcc.

Code Snippet

select distinct db_name(database_id) from sys.dm_os_buffer_descriptors

Jag

Cant Add new connection in SQL SERVER EXPRESS

Hi,

I am relatively new to this. I have installed VB 2005 and that has installed a version of SQL Server 2005 Express on my local development machine. I am using VB to develop some demo sites and i can create DB's in the App_Data file and they work when I test and run then by pressing Ctrl + F5.

However i have some demo tutorials that require Northwind and Pubs to do them. So i have installed Northwind and Pubs using the cms prompt and the InstNwnd.sql install. They said everything has been installed fine.

This is where the problem starts. I open new connection in VB, or asses for that matter and try to open my local server machine (just my desktop running WindowsXP pro), Which is called Optiplex. Sometimes i get the optiplex appear in the dropdown that asks for your to choose a server and other times it doesnt. Eevn if the machine appears it doesnt let me chose Pubs or northwind from the second drop down.

I think i must have SQexpress running on the machined named Optiplex because i have the SQL server configuartion manger on it. That tells me i am running SQL Server(SQLEXPRESS) and SQL Server Browser both switched on and running. By the way i have set my SQL manager to run as Local service.

One thing that i consider strange is that when i have had SQLServer Express running on other machines normally there was a little icon running in the right hand corner of the the task bar.

Does anyone know what is going on with my mchine and have i got the SQL server setup correctly?

Just one last piece of additionally information is that i have a folder called C:\SQL Server 2000 Sample Databases which is where the MDF files are located.

Thanks a million Sanson

Hi Sanson,

Could you give me some more details? Which database will the appliation connect to? SQL Server 2005 Express or SQL Server 2000 ? You mentioned that you have a folder called C:\SQL Server 200 Sample Database which is where the MDF files located, Have these MDF files (Northwind and Pubs) be attached to SQL Server by using Management Satudio? If not,pls follow the steps below:

1. Copy your .mdf file and .ldf(if exists) to another folder.
2. Right click on Databases, and select Attach from the popup menu.
3. In the Attach Databases dialog box,click Add button and select the .mdf file.
4. Click OK to finish, and the database will be atached to your database list in Management Studio.

Thanks.

|||

Thanks for your help.

What had happened was i hadnt installed SQL Management Studio. Once i did everything got sorted out and they were in there.

However i still cant use the upsizing wizard in Access to upsize a database to SQL. I always get a connect error.

Now however i get a the name of my server come up in the dropdown box, which is somethong i suppose.

sql

Can't access SqlServer 2005 using JDBC

Hi;

I can access SqlServer 2000 fine, but not SqlServer 2005. My client is on Windows XP and SqlServer 2005 (dev version) is on Windows 2003. When I run I get:

Error: net.windward.datasource.DataSourceException: JdbcDataSource could not ope
n jdbc:sqlserver://T1-Databases;databaseName=AdventureWorks;integratedSecurity=t
rue;
net.windward.datasource.DataSourceException: net.windward.datasource.DataSourceE
xception: JdbcDataSource could not open jdbc:sqlserver://T1-Databases;databaseNa
me=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more
Exception in thread "main" net.windward.datasource.DataSourceException: net.wind
ward.datasource.DataSourceException: JdbcDataSource could not open jdbc:sqlserve
r://T1-Databases;databaseName=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more

Any ideas?

thanks - dave

Are you using Microsoft SQL Server 2005 JDBC Driver version 1.1?

What platform (OS and version) does your JDBC client run on?

|||

I have similar error:

java.lang.NoClassDefFoundError
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)

I do have the JDBC driver version 1.1.

Cocoon 2.0

Tomcat 4.x

|||

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true

It appears as though it has something to do with integratedSecurity. I think the connection string is case sensitive, you did spell it IntegratedSecurity="True" right? The exception thrown seems to be targetted to integratedSecurity specifically. Also, are you authenticating in mixed mode or windows only? Did you configure the server on install correctly to be able to authenticate the kind of connection you are trying to make?

Hope we can figure this one out together,

John

|||

Have you tried enabling the TCP/IP Protocol through the SQL Server Configuration Manager? I seem to recall it being turned off by default in SQL 2005. Enable it and restart the SQL Service.

Good luck,

-Tom

|||You can run SQL Profiler to check if your application is indeed trying to establish a connection or not.|||It looks like you are using the 1.0 dirver which did not support integrated auth property.sql

Can't access SqlServer 2005 using JDBC

Hi;

I can access SqlServer 2000 fine, but not SqlServer 2005. My client is on Windows XP and SqlServer 2005 (dev version) is on Windows 2003. When I run I get:

Error: net.windward.datasource.DataSourceException: JdbcDataSource could not ope
n jdbc:sqlserver://T1-Databases;databaseName=AdventureWorks;integratedSecurity=t
rue;
net.windward.datasource.DataSourceException: net.windward.datasource.DataSourceE
xception: JdbcDataSource could not open jdbc:sqlserver://T1-Databases;databaseNa
me=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more
Exception in thread "main" net.windward.datasource.DataSourceException: net.wind
ward.datasource.DataSourceException: JdbcDataSource could not open jdbc:sqlserve
r://T1-Databases;databaseName=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more

Any ideas?

thanks - dave

Are you using Microsoft SQL Server 2005 JDBC Driver version 1.1?

What platform (OS and version) does your JDBC client run on?

|||

I have similar error:

java.lang.NoClassDefFoundError
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)

I do have the JDBC driver version 1.1.

Cocoon 2.0

Tomcat 4.x

|||

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true

It appears as though it has something to do with integratedSecurity. I think the connection string is case sensitive, you did spell it IntegratedSecurity="True" right? The exception thrown seems to be targetted to integratedSecurity specifically. Also, are you authenticating in mixed mode or windows only? Did you configure the server on install correctly to be able to authenticate the kind of connection you are trying to make?

Hope we can figure this one out together,

John

|||

Have you tried enabling the TCP/IP Protocol through the SQL Server Configuration Manager? I seem to recall it being turned off by default in SQL 2005. Enable it and restart the SQL Service.

Good luck,

-Tom

|||You can run SQL Profiler to check if your application is indeed trying to establish a connection or not.|||It looks like you are using the 1.0 dirver which did not support integrated auth property.

Can't access SqlServer 2005 using JDBC

Hi;

I can access SqlServer 2000 fine, but not SqlServer 2005. My client is on Windows XP and SqlServer 2005 (dev version) is on Windows 2003. When I run I get:

Error: net.windward.datasource.DataSourceException: JdbcDataSource could not ope
n jdbc:sqlserver://T1-Databases;databaseName=AdventureWorks;integratedSecurity=t
rue;
net.windward.datasource.DataSourceException: net.windward.datasource.DataSourceE
xception: JdbcDataSource could not open jdbc:sqlserver://T1-Databases;databaseNa
me=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more
Exception in thread "main" net.windward.datasource.DataSourceException: net.wind
ward.datasource.DataSourceException: JdbcDataSource could not open jdbc:sqlserve
r://T1-Databases;databaseName=AdventureWorks;integratedSecurity=true;
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1030)
at net.windward.xmlreport.RunReport.main(RunReport.java:165)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(U
nknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Sour
ce)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at net.windward.datasource.jdbc.JdbcDataSource.<init>(JdbcDataSource.jav
a:1024)
... 1 more

Any ideas?

thanks - dave

Are you using Microsoft SQL Server 2005 JDBC Driver version 1.1?

What platform (OS and version) does your JDBC client run on?

|||

I have similar error:

java.lang.NoClassDefFoundError
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)

I do have the JDBC driver version 1.1.

Cocoon 2.0

Tomcat 4.x

|||

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSe
curity property value:true

It appears as though it has something to do with integratedSecurity. I think the connection string is case sensitive, you did spell it IntegratedSecurity="True" right? The exception thrown seems to be targetted to integratedSecurity specifically. Also, are you authenticating in mixed mode or windows only? Did you configure the server on install correctly to be able to authenticate the kind of connection you are trying to make?

Hope we can figure this one out together,

John

|||

Have you tried enabling the TCP/IP Protocol through the SQL Server Configuration Manager? I seem to recall it being turned off by default in SQL 2005. Enable it and restart the SQL Service.

Good luck,

-Tom

|||You can run SQL Profiler to check if your application is indeed trying to establish a connection or not.|||It looks like you are using the 1.0 dirver which did not support integrated auth property.

Cant access Northwind database

I'm using XP Pro and I have the Developer's version of SQL Server installed. I downloaded SQLXML 3.0 and created a virtual directory named nwind.

I then entered the following on my IE browser:

http://<IIServer>/nwind?sql=SELECT FirstName, LastName FROM Employees FOR XML AUTO&root=root

the result is:
"The page cannot be displayed..."

I'd appreciate any help.

Thanks,
Pathttp://<IIServer>/nwind?sql=SELECT FirstName, LastName FROM Employees FOR XML AUTO&root=root

Is that a typo, or are you trying to pass a variable to a directory? when you say /nwind?sql='foo' then you should get page cannot be displayed, right? Don't you have to say /nwind/default.asp?sql='foo' ??

or will the virtual directory/IIS understand what you mean?sql

cannot update

Hi
we moved from 2000 to 2003 (version 9)
I do Open Table to see all rows
when I try to change a value say 2 to 3 in int field it pops up dialog and
say
like driver error string or binary data will be truncated
but it is an integer field and the values are like 2 and 3!
is it isolation level related perhaps
what setting is it
we just installed it so it must be default
Sincerely
GSL
Hi
"info@.sites4agents.com" wrote:

> Hi
> we moved from 2000 to 2003 (version 9)
> I do Open Table to see all rows
> when I try to change a value say 2 to 3 in int field it pops up dialog and
> say
> like driver error string or binary data will be truncated
> but it is an integer field and the values are like 2 and 3!
> is it isolation level related perhaps
> what setting is it
> we just installed it so it must be default
> Sincerely
> GSL
This should not be an issue under normal circumstances. Have you service
packed your version of SQL 2005? Are you trying this on a client or the
server itself?
Are there any triggers on the table?
John
|||John
Thanks
No SPs as far as I know (how will I know?)
the table does have text column but then in sql2000 it was updatable
manually
No triggers
I do it on the server
also! when I do it in Query like regular update statement it works!
(so maybe it forces good habits nevertheless I am curious why it happens)
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:25EACFD4-9897-4D6E-AEA6-E7936186542A@.microsoft.com...
> Hi
> "info@.sites4agents.com" wrote:
>
> This should not be an issue under normal circumstances. Have you service
> packed your version of SQL 2005? Are you trying this on a client or the
> server itself?
> Are there any triggers on the table?
> John
>
|||Hi
"info@.sites4agents.com" wrote:

> John
> Thanks
> No SPs as far as I know (how will I know?)
Select @.@.VERSION will give you the version number also SELECT
SERVERPROPTERY('ProductLevel ') will tell if a service pack has been applied
or is still at the original release (RTM). See
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html for more.

> the table does have text column but then in sql2000 it was updatable
> manually
> No triggers
> I do it on the server
> also! when I do it in Query like regular update statement it works!
> (so maybe it forces good habits nevertheless I am curious why it happens)
The error message you have seems to be a SQL Server error message, if you
have the error number it would be useful. You could post DDL and example data
http://www.aspfaq.com/etiquette.asp?id=5006 to help others re-create this.
Open table in Enterprise Manager was always quirky therefore it is not
something a lot of people will use in SQL 2005 because of that.
John

cannot update

Hi
we moved from 2000 to 2003 (version 9)
I do Open Table to see all rows
when I try to change a value say 2 to 3 in int field it pops up dialog and
say
like driver error string or binary data will be truncated
but it is an integer field and the values are like 2 and 3!
is it isolation level related perhaps
what setting is it
we just installed it so it must be default
Sincerely
GSLHi
"info@.sites4agents.com" wrote:

> Hi
> we moved from 2000 to 2003 (version 9)
> I do Open Table to see all rows
> when I try to change a value say 2 to 3 in int field it pops up dialog and
> say
> like driver error string or binary data will be truncated
> but it is an integer field and the values are like 2 and 3!
> is it isolation level related perhaps
> what setting is it
> we just installed it so it must be default
> Sincerely
> GSL
This should not be an issue under normal circumstances. Have you service
packed your version of SQL 2005? Are you trying this on a client or the
server itself?
Are there any triggers on the table?
John|||John
Thanks
No SPs as far as I know (how will I know?)
the table does have text column but then in sql2000 it was updatable
manually
No triggers
I do it on the server
also! when I do it in Query like regular update statement it works!
(so maybe it forces good habits nevertheless I am curious why it happens)
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:25EACFD4-9897-4D6E-AEA6-E7936186542A@.microsoft.com...
> Hi
> "info@.sites4agents.com" wrote:
>
> This should not be an issue under normal circumstances. Have you service
> packed your version of SQL 2005? Are you trying this on a client or the
> server itself?
> Are there any triggers on the table?
> John
>|||Hi
"info@.sites4agents.com" wrote:

> John
> Thanks
> No SPs as far as I know (how will I know?)
Select @.@.VERSION will give you the version number also SELECT
SERVERPROPTERY('ProductLevel ') will tell if a service pack has been applied
or is still at the original release (RTM). See
http://sqlserver2000.databases.aspf...-m-running.html for more.

> the table does have text column but then in sql2000 it was updatable
> manually
> No triggers
> I do it on the server
> also! when I do it in Query like regular update statement it works!
> (so maybe it forces good habits nevertheless I am curious why it happens)
The error message you have seems to be a SQL Server error message, if you
have the error number it would be useful. You could post DDL and example dat
a
http://www.aspfaq.com/etiquette.asp?id=5006 to help others re-create this.
Open table in Enterprise Manager was always quirky therefore it is not
something a lot of people will use in SQL 2005 because of that.
John

cannot update

Hi
we moved from 2000 to 2003 (version 9)
I do Open Table to see all rows
when I try to change a value say 2 to 3 in int field it pops up dialog and
say
like driver error string or binary data will be truncated
but it is an integer field and the values are like 2 and 3!
is it isolation level related perhaps
what setting is it
we just installed it so it must be default
Sincerely
GSLHi
"info@.sites4agents.com" wrote:
> Hi
> we moved from 2000 to 2003 (version 9)
> I do Open Table to see all rows
> when I try to change a value say 2 to 3 in int field it pops up dialog and
> say
> like driver error string or binary data will be truncated
> but it is an integer field and the values are like 2 and 3!
> is it isolation level related perhaps
> what setting is it
> we just installed it so it must be default
> Sincerely
> GSL
This should not be an issue under normal circumstances. Have you service
packed your version of SQL 2005? Are you trying this on a client or the
server itself?
Are there any triggers on the table?
John|||John
Thanks
No SPs as far as I know (how will I know?)
the table does have text column but then in sql2000 it was updatable
manually
No triggers
I do it on the server
also! when I do it in Query like regular update statement it works!
(so maybe it forces good habits nevertheless I am curious why it happens)
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:25EACFD4-9897-4D6E-AEA6-E7936186542A@.microsoft.com...
> Hi
> "info@.sites4agents.com" wrote:
>> Hi
>> we moved from 2000 to 2003 (version 9)
>> I do Open Table to see all rows
>> when I try to change a value say 2 to 3 in int field it pops up dialog
>> and
>> say
>> like driver error string or binary data will be truncated
>> but it is an integer field and the values are like 2 and 3!
>> is it isolation level related perhaps
>> what setting is it
>> we just installed it so it must be default
>> Sincerely
>> GSL
> This should not be an issue under normal circumstances. Have you service
> packed your version of SQL 2005? Are you trying this on a client or the
> server itself?
> Are there any triggers on the table?
> John
>|||Hi
"info@.sites4agents.com" wrote:
> John
> Thanks
> No SPs as far as I know (how will I know?)
Select @.@.VERSION will give you the version number also SELECT
SERVERPROPTERY('ProductLevel ') will tell if a service pack has been applied
or is still at the original release (RTM). See
http://sqlserver2000.databases.aspfaq.com/how-do-i-know-which-version-of-sql-server-i-m-running.html for more.
> the table does have text column but then in sql2000 it was updatable
> manually
> No triggers
> I do it on the server
> also! when I do it in Query like regular update statement it works!
> (so maybe it forces good habits nevertheless I am curious why it happens)
The error message you have seems to be a SQL Server error message, if you
have the error number it would be useful. You could post DDL and example data
http://www.aspfaq.com/etiquette.asp?id=5006 to help others re-create this.
Open table in Enterprise Manager was always quirky therefore it is not
something a lot of people will use in SQL 2005 because of that.
John

Cannot start SQL Server 2005 management express studio CTP?

I downloaded it from the link in
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
--
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:
> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
> >I downloaded it from the link in
> > http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> > version.
> > And it cannot be run on two machines. Both installed VS 2003.
>
>|||No. SQL Express is RTM. SSME is CTP.
--
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
>> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
>> --
>> William Stacey [MVP]
>> "nick" <nick@.discussions.microsoft.com> wrote in message
>> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>> >I downloaded it from the link in
>> > http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
>> > version.
>> > And it cannot be run on two machines. Both installed VS 2003.
>>

Cannot start SQL Server 2005 management express studio CTP?

I downloaded it from the link in
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.
http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.
|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:

> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>
>
|||No. SQL Express is RTM. SSME is CTP.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...[vbcol=seagreen]
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:

Cannot start SQL Server 2005 management express studio CTP?

I downloaded it from the link in
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:

> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>
>|||No. SQL Express is RTM. SSME is CTP.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...[vbcol=seagreen]
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
>

cannot start or verify that SQL 2005 is running

Hi,

I am new to sql 2005.

I have installed a trial version of 2005 enterprise edition.

After installing I went to Management Studio. I noticed that the server name

dropdown menu was blank so I tried to browse. No server names appear under local

or network servers. I then went to configuration manager and noticed that

although client protocols are listed under SQL client native config,

SQL server 2005 services and sql server 2005 network config are both blank. Is SQL

installed correctly? I hope this is enough info to illicit a helpful response.

Thank You.

Problem solved. I went to add remove apps and clicked change

on Microsoft SQL Server 2005 button. I am not sure what Microsoft

SQL Server Native Client is so I didn't mess with it. I saw that no instances

were listed under SQL Server 2005 instances so I clicked away until I had

added an instance - MSSQLSERVER. I am going to be using .net 2.0 framework

objects to connect to SQL so I am not sure if I messed up by Not installing in

mixed mode. Any advice on the mixed mode issue would be appreciated.

|||If you have no need for mixed mode, then don't install it. It kind of sounds like you don't so no worries.

Cannot start agent...

Hi there.
I am getting the following error when trying to start the Sqlserver agent
(on a version 7 db):
SQLServerAgent could not be started (reason: Unable to connect to server;
SQLServerAgent cannot start).
I have connect to the server using the NT windows authentication (which is
what is used to start the agent) and I connect 100%.
Does anyone have any ideas?
Any help will be appreciated.
Thanks
ClintThe SQL Server MUST be running and a domain controller must be available...
SQL Agent MUST also connect to SQL with a SQL login which has ADMINISTRATIVE
SQL privelege..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it community
of SQL Server professionals.
www.sqlpass.org
"Tiger Woods" <clintonn@.meb.co.za> wrote in message
news:3f2f5fa6$0$227@.hades.is.co.za...
> Hi there.
> I am getting the following error when trying to start the Sqlserver agent
> (on a version 7 db):
> SQLServerAgent could not be started (reason: Unable to connect to server;
> SQLServerAgent cannot start).
> I have connect to the server using the NT windows authentication (which is
> what is used to start the agent) and I connect 100%.
> Does anyone have any ideas?
> Any help will be appreciated.
> Thanks
> Clint
>|||Clint,
Here is a link to an article by Richard Waymire on 7.0 security
http://tinyurl.com/j24t . It discusses security issues related to SQL Agent
The following Troubleshooting guide for SS2000 may also be of interest:
http://tinyurl.com/j249
Russell Fields
"Tiger Woods" <clintonn@.meb.co.za> wrote in message
news:3f2f5fa6$0$227@.hades.is.co.za...
> Hi there.
> I am getting the following error when trying to start the Sqlserver agent
> (on a version 7 db):
> SQLServerAgent could not be started (reason: Unable to connect to server;
> SQLServerAgent cannot start).
> I have connect to the server using the NT windows authentication (which is
> what is used to start the agent) and I connect 100%.
> Does anyone have any ideas?
> Any help will be appreciated.
> Thanks
> Clint
>

Cannot specify 'dimension' for: Maintenance plan remove files older than

OS: Windows Server 2003 Standard Edition. MSDE 2000.

SQL Server Enterprise Manager Version 8.0.

The Maintenance Plan Wizard will not allow me to specify a value for the 'Remove Files...' I can enter a number but there is nothing in the drop down e.g. 3 'DAYS' perhaps?

Create then plan and then edit - yields the same result.

Any ideas on why there is no 'dimension' for Remove Files Older than ?

Appreciate any tips, ideas, etc.

Thank.s

Anybody have issues trying to specify a dimension for 'Remove Files...' either during Maintenance Wizard (create) or afterwards - edit properties?

The drop down - where you would expect a list of values like: day, week, month - is completely blank?

|||

I'm experiencing the exact same problem with my MSDE database. I cannot specify anything as to days, weeks, etc. It also will take other information, such as scheduling, directory, extension name, and actually create the jobs correctly, but then when you go back to the Maintenance Plan, you find the information has disappeared. If you try to modify any other aspect of the plan, you get an error, because this information is now missing. This is the only MSDE db I have, all the rest are standard or enterprise and work normally from the same Enterprise Manager.

I have not found any explanation or work-around for this problem.

Cannot specify 'dimension' for: Maintenance plan remove files older than

OS: Windows Server 2003 Standard Edition. MSDE 2000.

SQL Server Enterprise Manager Version 8.0.

The Maintenance Plan Wizard will not allow me to specify a value for the 'Remove Files...' I can enter a number but there is nothing in the drop down e.g. 3 'DAYS' perhaps?

Create then plan and then edit - yields the same result.

Any ideas on why there is no 'dimension' for Remove Files Older than ?

Appreciate any tips, ideas, etc.

Thank.s

Anybody have issues trying to specify a dimension for 'Remove Files...' either during Maintenance Wizard (create) or afterwards - edit properties?

The drop down - where you would expect a list of values like: day, week, month - is completely blank?

|||

I'm experiencing the exact same problem with my MSDE database. I cannot specify anything as to days, weeks, etc. It also will take other information, such as scheduling, directory, extension name, and actually create the jobs correctly, but then when you go back to the Maintenance Plan, you find the information has disappeared. If you try to modify any other aspect of the plan, you get an error, because this information is now missing. This is the only MSDE db I have, all the rest are standard or enterprise and work normally from the same Enterprise Manager.

I have not found any explanation or work-around for this problem.

Cannot Shrink log file

Database version 2000 SP 4

Database size : 100 GB , Transaction Log 200: GB , Recovery mode: Simple

I am trying to shrink the transaction log and every time I go to options, it gives me a bigger size to shrink to than the existing log size on the EM. There was replication setup on this database and i removed all the articles and restarted Sql server and the server itself as well.

The database backup works fine.

Please let me know how to fix this issue.

thanks,

Mark.

Hi,

http://sqlserver2000.databases.aspfaq.com/how-do-i-reclaim-space-in-sql-server.html

HTh, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Cannot see SQL Server 2005 from SQL Server 2k EM

I am running SQL Server 2k version 8.00 on one pc (A) on a lan,
and SQL Server 2005 Developer Edition version 9.0 on another (B).
I can see the 2k server on A from Management Studio on B
but I can't see the 2005 server from Enterprise Manager on A.
Is this a limitation or have I just done something wrong?
(I previously tried using SQL Express on B and got the same result
so I uninstalled that and installed Developer Edition instead).
Thanks in advance.
Peter CroftSQL Server 2000 Enterprise Manager cannot work with SQL Server 2005. It
doesn't understand SQL Server 2005 features like XML data types, etc. You
can connect to SQL Server 2005 using SQL Server 2000 Query Analyzer, or you
can use Management Studio to connect to both versions.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter Croft" <peter_croft@.textandvideo.co.uk> wrote in message
news:OXBbLXcgHHA.4980@.TK2MSFTNGP02.phx.gbl...
>I am running SQL Server 2k version 8.00 on one pc (A) on a lan,
> and SQL Server 2005 Developer Edition version 9.0 on another (B).
> I can see the 2k server on A from Management Studio on B
> but I can't see the 2005 server from Enterprise Manager on A.
> Is this a limitation or have I just done something wrong?
> (I previously tried using SQL Express on B and got the same result
> so I uninstalled that and installed Developer Edition instead).
> Thanks in advance.
> Peter Croft
>

Cannot see SQL Express 2005 from SQL Server 2k

I am running SQL Server 2k version 8.00 on one pc (A) on a lan, and SQL
Express 2005 version 9.0
on another (B). I can see the 2k server on A from Management Studio Express
on B but not the other way round.
Is this a limitation or have I just done something wrong?
Thanks in advance.
Peter CroftIIRC SQL Server Express' tools are limited in functionality. I just tried it
here in the lab and I can't connect to any external servers.
Ah, why not just plop down the $39.95 and get the Developer Edition. Its
tools are unlimited.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Peter Croft" <peter_croft@.textandvideo.co.uk> wrote in message
news:%23AJdQuHeHHA.2188@.TK2MSFTNGP04.phx.gbl...
>I am running SQL Server 2k version 8.00 on one pc (A) on a lan, and SQL
>Express 2005 version 9.0
> on another (B). I can see the 2k server on A from Management Studio
> Express on B but not the other way round.
> Is this a limitation or have I just done something wrong?
> Thanks in advance.
> Peter Croft
>|||Thank you, I guess I'll do that. What surprises me is that I can see "out"
but not "in".
Peter
"William (Bill) Vaughn" <billvaRemoveThis@.betav.com> wrote in message
news:uHRaexIeHHA.4996@.TK2MSFTNGP03.phx.gbl...
> IIRC SQL Server Express' tools are limited in functionality. I just tried
> it here in the lab and I can't connect to any external servers.
> Ah, why not just plop down the $39.95 and get the Developer Edition. Its
> tools are unlimited.
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ----
---
> "Peter Croft" <peter_croft@.textandvideo.co.uk> wrote in message
> news:%23AJdQuHeHHA.2188@.TK2MSFTNGP04.phx.gbl...
>