Does SQL server 2005 places a few VARBINARY(MAX) values on a single page if
the length of those values are let's say 2KB?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200512/1Hi Alex
Varbinary(max) data will actually be placed in the data row itself if there
is room.
You can set the table property to store all large objects out of the row,
and then varbinary(max) is treated just like image.
Image columns from the same table CAN share space on the same pages for
greater storage space efficiency.
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Alex via SQLMonster.com" <no@.spam.pls> wrote in message
news:589565dfa15f3@.uwe...
> Does SQL server 2005 places a few VARBINARY(MAX) values on a single page
> if
> the length of those values are let's say 2KB?
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200512/1
>|||Thanks a lot for your response.
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200512/1
Showing posts with label message. Show all posts
Showing posts with label message. Show all posts
Tuesday, March 27, 2012
A data source instance has not been supplied for the data source
Hi Guys,
I have create a report and it works in development mode. But when I call this report from aspx page it give me above error message. Please let me know how can I setup datasource of this report at runtime. Below is my code
Regards
ReportParameter[] rptPara = new ReportParameter[1];
rptPara[0] = new ReportParameter("rDate", WebDateChooser1.Text, false);
ReportViewer1.LocalReport.ReportPath = @."C:Business\RPT585.rdl";
ReportViewer1.LocalReport.SetParameters(rptPara);
ReportViewer1.LocalReport.Refresh();
Please anybody could let me guide here....
|||This is how you can provide DataSource information to report at runtime.
Example:
ObjectDataSource objAdventureWorks = new ObjectDataSource("MyData", "GetDataAddress");
objAdventureWorks.ID = "Adventureworks";
this.Controls.Add(objAdventureWorks);
this.ReportViewer.LocalReport.DataSources.Add(new ReportDataSource("AdventureWorks2000", "Adventureworks"));
|||I have added the datasource of my report but still keep getting this error message. Please let me guide how to fix this error. adn how to set data source instance. Below is my code
ReportParameter[] rptPara = new ReportParameter[1];
rptPara[0] = new ReportParameter("rDate", WebDateChooser1.Text, false);
ReportViewer1.LocalReport.ReportPath = @."C:\business\RPT528.rdl";
ReportViewer1.LocalReport.SetParameters(rptPara);
ReportViewer1.LocalReport.DataSources.Add(new ReportDataSource("dsCustomers"));
ReportViewer1.LocalReport.Refresh();
|||http://blogs.msdn.com/bimusings/archive/2005/07/01/434659.aspx
I think this article should answer your question. I was experiencing the same error and Russell's work-around fixed it.
TF
A curious error message, local temp vs. global temp tables?!?!?
Hi all,
Looking at BOL for temp tables help, I discover that a local temp table (I want to only have life within my stored proc) SHOULD be visible to all (child) stored procs called by the papa stored proc.
However, the following code works just peachy when I use a GLOBAL temp table (i.e., ##MyTempTbl) but fails when I use a local temp table (i.e., #MyTempTable). Through trial and error, and careful weeding efforts, I know that the error I get on the local version is coming from the xp_sendmail call. The error I get is: ODBC error 208 (42S02) Invalid object name '#MyTempTbl'.
Here is the code that works:SET NOCOUNT ON
CREATE TABLE ##MyTempTbl (SeqNo int identity, MyWords varchar(1000))
INSERT ##MyTempTbl values ('Put your long message here.')
INSERT ##MyTempTbl values ('Put your second long message here.')
INSERT ##MyTempTbl values ('put your really, really LONG message (yeah, every guy says his message is the longest...whatever!')
DECLARE @.cmd varchar(256)
DECLARE @.LargestEventSize int
DECLARE @.Width int, @.Msg varchar(128)
SELECT @.LargestEventSize = Max(Len(MyWords))
FROM ##MyTempTbl
SET @.cmd = 'SELECT Cast(MyWords AS varchar(' +
CONVERT(varchar(5), @.LargestEventSize) +
')) FROM ##MyTempTbl order by SeqNo'
SET @.Width = @.LargestEventSize + 1
SET @.Msg = 'Here is the junk you asked about' + CHAR(13) + '---------'
EXECUTE Master.dbo.xp_sendmail
'YoMama@.WhoKnows.com',
@.query = @.cmd,
@.no_header= 'TRUE',
@.width = @.Width,
@.dbuse = 'MyDB',
@.subject='none of your darn business',
@.message= @.Msg
DROP TABLE ##MyTempTbl
The only thing I change to make it fail is the table name, change it from ##MyTempTbl to #MyTempTbl, and it dashes the email hopes of the stored procedure upon the jagged rocks of electronic despair.
Any insight anyone? Or is BOL just full of...well..."stuff"?I would still like to hear if anyone knows anything different, but while looking into Des' sendmail problem, I found this lil' tidbit in BOL for xp_sendmail If query is specified, xp_sendmail logs in to SQL Server as a client and executes the specified query. SQL Mail makes a separate connection to SQL Server; it does not share the same connection as the original client connection issuing xp_sendmail. I suspect the "separate connection to SQL Server" is the issue here?!?!?! Hmmmm...perhaps the local temp table can be seen by child processes called by the proc that creates the table EXCEPT in xp_sendmail, etc.|||You hit the problem right on the head... xp_sendmail does execute the query in a different context, meaning that it can't see local variables, settings, or temp tables. You can think of it almost as though xp_sendmail were cranking up OSQL.EXE to execute your query (that isn't what actually happens, but it is logically pretty close).
-PatP
Looking at BOL for temp tables help, I discover that a local temp table (I want to only have life within my stored proc) SHOULD be visible to all (child) stored procs called by the papa stored proc.
However, the following code works just peachy when I use a GLOBAL temp table (i.e., ##MyTempTbl) but fails when I use a local temp table (i.e., #MyTempTable). Through trial and error, and careful weeding efforts, I know that the error I get on the local version is coming from the xp_sendmail call. The error I get is: ODBC error 208 (42S02) Invalid object name '#MyTempTbl'.
Here is the code that works:SET NOCOUNT ON
CREATE TABLE ##MyTempTbl (SeqNo int identity, MyWords varchar(1000))
INSERT ##MyTempTbl values ('Put your long message here.')
INSERT ##MyTempTbl values ('Put your second long message here.')
INSERT ##MyTempTbl values ('put your really, really LONG message (yeah, every guy says his message is the longest...whatever!')
DECLARE @.cmd varchar(256)
DECLARE @.LargestEventSize int
DECLARE @.Width int, @.Msg varchar(128)
SELECT @.LargestEventSize = Max(Len(MyWords))
FROM ##MyTempTbl
SET @.cmd = 'SELECT Cast(MyWords AS varchar(' +
CONVERT(varchar(5), @.LargestEventSize) +
')) FROM ##MyTempTbl order by SeqNo'
SET @.Width = @.LargestEventSize + 1
SET @.Msg = 'Here is the junk you asked about' + CHAR(13) + '---------'
EXECUTE Master.dbo.xp_sendmail
'YoMama@.WhoKnows.com',
@.query = @.cmd,
@.no_header= 'TRUE',
@.width = @.Width,
@.dbuse = 'MyDB',
@.subject='none of your darn business',
@.message= @.Msg
DROP TABLE ##MyTempTbl
The only thing I change to make it fail is the table name, change it from ##MyTempTbl to #MyTempTbl, and it dashes the email hopes of the stored procedure upon the jagged rocks of electronic despair.
Any insight anyone? Or is BOL just full of...well..."stuff"?I would still like to hear if anyone knows anything different, but while looking into Des' sendmail problem, I found this lil' tidbit in BOL for xp_sendmail If query is specified, xp_sendmail logs in to SQL Server as a client and executes the specified query. SQL Mail makes a separate connection to SQL Server; it does not share the same connection as the original client connection issuing xp_sendmail. I suspect the "separate connection to SQL Server" is the issue here?!?!?! Hmmmm...perhaps the local temp table can be seen by child processes called by the proc that creates the table EXCEPT in xp_sendmail, etc.|||You hit the problem right on the head... xp_sendmail does execute the query in a different context, meaning that it can't see local variables, settings, or temp tables. You can think of it almost as though xp_sendmail were cranking up OSQL.EXE to execute your query (that isn't what actually happens, but it is logically pretty close).
-PatP
Thursday, March 22, 2012
A connection could not be made to the Report Server
When I try to deploy a report, I received the message "A connection could not
be made to the Report Server"
Someone knows the solution?Have you double checked the targetserverlURL property in the project
properties?
Mike G.
"Alicia" <Alicia@.discussions.microsoft.com> wrote in message
news:9A9811F4-0D0D-42CC-8090-13914199953F@.microsoft.com...
> When I try to deploy a report, I received the message "A connection could
> not
> be made to the Report Server"
> Someone knows the solution?
be made to the Report Server"
Someone knows the solution?Have you double checked the targetserverlURL property in the project
properties?
Mike G.
"Alicia" <Alicia@.discussions.microsoft.com> wrote in message
news:9A9811F4-0D0D-42CC-8090-13914199953F@.microsoft.com...
> When I try to deploy a report, I received the message "A connection could
> not
> be made to the Report Server"
> Someone knows the solution?
A Connection could not be established to <server>
Hi, I received this message today when I tried to log on to my SQL Server:
**********************
A connection could not be established to <server>
Reason: SQL Server does not exist or Access denied
ConnectionOpen(Connect())..
Please verify SQL Server is running and check your SQL Registration properties**********************
My SQL server wasn't running, however I am not able to start it (right click->start doesn't work).
Any thoughts?
thanksGo to LOG subdirectory and open ERRORLOG file with your favorite text editor. Check event log (Application) for reasons of service startup failure.|||check that your service account hasnt changed it's password;
one simple way to do this is to set the sqlserver service account to local and try to start it if it works your service account is not permissioned or more than likely the password has been changed.
if this is the case. dont forget your sqlserveragent acct as well.
reply back if you are using a local system account
**********************
A connection could not be established to <server>
Reason: SQL Server does not exist or Access denied
ConnectionOpen(Connect())..
Please verify SQL Server is running and check your SQL Registration properties**********************
My SQL server wasn't running, however I am not able to start it (right click->start doesn't work).
Any thoughts?
thanksGo to LOG subdirectory and open ERRORLOG file with your favorite text editor. Check event log (Application) for reasons of service startup failure.|||check that your service account hasnt changed it's password;
one simple way to do this is to set the sqlserver service account to local and try to start it if it works your service account is not permissioned or more than likely the password has been changed.
if this is the case. dont forget your sqlserveragent acct as well.
reply back if you are using a local system account
Sunday, March 11, 2012
8.5 Formula error at runtime
Hi
My client is getting the following error message
Error in formula <check>.
'If not IsNull({@.sApplicant2}) Then
'
A number, currency amount, boolean or string is expected here.
The error box is entitled 'Print Engine Error'
This is from a compiled 8.5 executable I created for him.
It runs fine on my machine and on the server I posted it up on for him.
We checked his schema.ini, his text driver and the exe and they are the same as what I have. I copied over the data files he generated that were used for the report and they work on my machine.
This error looks more like a development type error.
I would have expected this type of error to morel iley occur if I did a print preview during design time or tried to compile in the design environment.
I have a failry simple formula parameter called check in a sub report that seems correct and as I said the report runs fine on my machine.
Anybody have any ideas on what the problem might be and where to look?
Much obliged
Paulwhat data type {@.sApplicant2} is?|||Hi
{@.sApplicant2} is a formula.
So, I don't use a Dim statement or other declaration statement for it.
I haven't specified its datatype, so I suppose it is the default datatype, whatever that may be.
The fields I use with it to set its value are strings.
Pretty much everything on the report is a string, except for some simple date fields not referenced by any formulas.
There are no numerical calculations being performed in the report.
Thanks
Paul
My client is getting the following error message
Error in formula <check>.
'If not IsNull({@.sApplicant2}) Then
'
A number, currency amount, boolean or string is expected here.
The error box is entitled 'Print Engine Error'
This is from a compiled 8.5 executable I created for him.
It runs fine on my machine and on the server I posted it up on for him.
We checked his schema.ini, his text driver and the exe and they are the same as what I have. I copied over the data files he generated that were used for the report and they work on my machine.
This error looks more like a development type error.
I would have expected this type of error to morel iley occur if I did a print preview during design time or tried to compile in the design environment.
I have a failry simple formula parameter called check in a sub report that seems correct and as I said the report runs fine on my machine.
Anybody have any ideas on what the problem might be and where to look?
Much obliged
Paulwhat data type {@.sApplicant2} is?|||Hi
{@.sApplicant2} is a formula.
So, I don't use a Dim statement or other declaration statement for it.
I haven't specified its datatype, so I suppose it is the default datatype, whatever that may be.
The fields I use with it to set its value are strings.
Pretty much everything on the report is a string, except for some simple date fields not referenced by any formulas.
There are no numerical calculations being performed in the report.
Thanks
Paul
7619 error message when you run a full text query that contains certain Turkish character
I receive a 7619 error message when I run a full text query that
contains certain Turkish character strings on an instance of SQL Server
2000 that is running on a Windows 2000-based computer. How can I solve
this problem?
The parser is interpreting these characters as noise or noise words. Which
word breaker are you using? I am assuming you are using the neutral word
breaker.
If this is the case the problem could be in your code page setting in the
web page. You should set the session.codepage to match the lcid for Turkish.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ismail H. AYDIN" <dicisay@.hotmail.com> wrote in message
news:1117203863.089340.322710@.g49g2000cwa.googlegr oups.com...
>I receive a 7619 error message when I run a full text query that
> contains certain Turkish character strings on an instance of SQL Server
> 2000 that is running on a Windows 2000-based computer. How can I solve
> this problem?
>
|||I am running the query from SQL Query Analyzer and then error occurs.
Not from asp.net or asp page. The noise word is 'Ak'. And the other
noise charactes are '', '', ''.
*** Sent via Developersdex http://www.codecomments.com ***
contains certain Turkish character strings on an instance of SQL Server
2000 that is running on a Windows 2000-based computer. How can I solve
this problem?
The parser is interpreting these characters as noise or noise words. Which
word breaker are you using? I am assuming you are using the neutral word
breaker.
If this is the case the problem could be in your code page setting in the
web page. You should set the session.codepage to match the lcid for Turkish.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Ismail H. AYDIN" <dicisay@.hotmail.com> wrote in message
news:1117203863.089340.322710@.g49g2000cwa.googlegr oups.com...
>I receive a 7619 error message when I run a full text query that
> contains certain Turkish character strings on an instance of SQL Server
> 2000 that is running on a Windows 2000-based computer. How can I solve
> this problem?
>
|||I am running the query from SQL Query Analyzer and then error occurs.
Not from asp.net or asp page. The noise word is 'Ak'. And the other
noise charactes are '', '', ''.
*** Sent via Developersdex http://www.codecomments.com ***
Thursday, March 8, 2012
7.0 difficulties CONNECTING the server once it is loaded
first time using community:
I loaded 7.0 last night but when I tried to connect i
could not. error message:
unable to connect to server \\16UDJ
OBDC: Msg 0, level 16, State 1
[Microsoft][OBDC sql service driver]timeout expired
DOES ANYONE KNOW WHAT WOULD CAUSE THIS.
I AM USING SQL ON MY LOCAL LAPTOP ONLYI am running windows 98 but office 2000
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
I loaded 7.0 last night but when I tried to connect i
could not. error message:
unable to connect to server \\16UDJ
OBDC: Msg 0, level 16, State 1
[Microsoft][OBDC sql service driver]timeout expired
DOES ANYONE KNOW WHAT WOULD CAUSE THIS.
I AM USING SQL ON MY LOCAL LAPTOP ONLYI am running windows 98 but office 2000
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Saturday, February 25, 2012
64bit and performance counters
Does anyone know if the hotfix mentioned in KB article 812915
[FIX: "Performance Monitor Shared Memory Setup Failed: -1" Error Message
When You Start SQL Server]
is the same for 64bit as for 32bit, my first guess is no - but I have to
ask.
We just installed 64bit SQL Server 2 weeks ago and now the performace
counters are gone and the above "-1" message shows up in the SQL Server
errolog. This looks exactly like the same problem we encountered with 32
bit.
Thanks,
FrankmHi Frankm,
From your descriptions, I understood that you would like to the fix in
KB:812915 will be possible for your performance counter issue. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know:)
Based on my knowledge, it will be suitable for your 64bit SQL Server as you
could find the following information in the KB
----
The information in this article applies to:
Microsoft SQL Server 2000 (all editions) SP3
----
You could contact PSS as KB told to ask for a hotfix :) If the hotfix
doesn't resolve your issue, your issue may be not share the same root cause
as fixed in KB: 812915. In this way, I will be glad to continue our
troubleshooting until it is resolved :)
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Are you sure that the Hotfix will work for 64bit?
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:YhgxzlmWEHA.3484@.cpmsftngxa10.phx.gbl...
> Hi Frankm,
> From your descriptions, I understood that you would like to the fix in
> KB:812915 will be possible for your performance counter issue. Have I
> understood you? If there is anything I misunderstood, please feel free to
> let me know:)
> Based on my knowledge, it will be suitable for your 64bit SQL Server as
you
> could find the following information in the KB
> ----
> The information in this article applies to:
> Microsoft SQL Server 2000 (all editions) SP3
> ----
> You could contact PSS as KB told to ask for a hotfix :) If the hotfix
> doesn't resolve your issue, your issue may be not share the same root
cause
> as fixed in KB: 812915. In this way, I will be glad to continue our
> troubleshooting until it is resolved :)
>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi frankm,
I am sure that hotfix will work for 64bit SQL Server :)
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Thank you - I will attempt to apply the patch.
Thank you again ...
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:XE7dHSYXEHA.308@.cpmsftngxa10.phx.gbl...
> Hi frankm,
> I am sure that hotfix will work for 64bit SQL Server :)
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Frankm,
Thanks for your prompt updates!
You could post back the result after applying the patches to Re-Open this
thread if the patch doesn't work for you. In this case, you issue might be
another root causes that has no relationship with KB: 812915 and it is
highly appreciated if you could create a new thread so that we could
troubleshooting this issue for you :)
Anyway, thanks for using MSDN Newsgroup! We are here to be of assistance
whenever you have problems!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
[FIX: "Performance Monitor Shared Memory Setup Failed: -1" Error Message
When You Start SQL Server]
is the same for 64bit as for 32bit, my first guess is no - but I have to
ask.
We just installed 64bit SQL Server 2 weeks ago and now the performace
counters are gone and the above "-1" message shows up in the SQL Server
errolog. This looks exactly like the same problem we encountered with 32
bit.
Thanks,
FrankmHi Frankm,
From your descriptions, I understood that you would like to the fix in
KB:812915 will be possible for your performance counter issue. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know:)
Based on my knowledge, it will be suitable for your 64bit SQL Server as you
could find the following information in the KB
----
The information in this article applies to:
Microsoft SQL Server 2000 (all editions) SP3
----
You could contact PSS as KB told to ask for a hotfix :) If the hotfix
doesn't resolve your issue, your issue may be not share the same root cause
as fixed in KB: 812915. In this way, I will be glad to continue our
troubleshooting until it is resolved :)
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Are you sure that the Hotfix will work for 64bit?
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:YhgxzlmWEHA.3484@.cpmsftngxa10.phx.gbl...
> Hi Frankm,
> From your descriptions, I understood that you would like to the fix in
> KB:812915 will be possible for your performance counter issue. Have I
> understood you? If there is anything I misunderstood, please feel free to
> let me know:)
> Based on my knowledge, it will be suitable for your 64bit SQL Server as
you
> could find the following information in the KB
> ----
> The information in this article applies to:
> Microsoft SQL Server 2000 (all editions) SP3
> ----
> You could contact PSS as KB told to ask for a hotfix :) If the hotfix
> doesn't resolve your issue, your issue may be not share the same root
cause
> as fixed in KB: 812915. In this way, I will be glad to continue our
> troubleshooting until it is resolved :)
>
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi frankm,
I am sure that hotfix will work for 64bit SQL Server :)
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Thank you - I will attempt to apply the patch.
Thank you again ...
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:XE7dHSYXEHA.308@.cpmsftngxa10.phx.gbl...
> Hi frankm,
> I am sure that hotfix will work for 64bit SQL Server :)
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Frankm,
Thanks for your prompt updates!
You could post back the result after applying the patches to Re-Open this
thread if the patch doesn't work for you. In this case, you issue might be
another root causes that has no relationship with KB: 812915 and it is
highly appreciated if you could create a new thread so that we could
troubleshooting this issue for you :)
Anyway, thanks for using MSDN Newsgroup! We are here to be of assistance
whenever you have problems!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Thursday, February 16, 2012
5041. MODIFY FILE failed. File '%.*ls' does not exist.
I am trying to change the file growth of a database file by 10% and I get an error message.
Microsoft SQL-DMO (ODBC SQL-STATE 42000)
Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
All I know is that it is an error of severity 16.
Can you post the SQL command you executed?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kostas Kourtides" <Kostas Kourtides@.discussions.microsoft.com> wrote in message
news:1E944558-4968-4249-AC6B-9B9FCF87AB25@.microsoft.com...
> I am trying to change the file growth of a database file by 10% and I get an error message.
> Microsoft SQL-DMO (ODBC SQL-STATE 42000)
> Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
> All I know is that it is an error of severity 16.
|||The issue has been solved by changing the names of the filenames.
Thanks for the interest.
"Tibor Karaszi" wrote:
> Can you post the SQL command you executed?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Kostas Kourtides" <Kostas Kourtides@.discussions.microsoft.com> wrote in message
> news:1E944558-4968-4249-AC6B-9B9FCF87AB25@.microsoft.com...
>
>
Microsoft SQL-DMO (ODBC SQL-STATE 42000)
Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
All I know is that it is an error of severity 16.
Can you post the SQL command you executed?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kostas Kourtides" <Kostas Kourtides@.discussions.microsoft.com> wrote in message
news:1E944558-4968-4249-AC6B-9B9FCF87AB25@.microsoft.com...
> I am trying to change the file growth of a database file by 10% and I get an error message.
> Microsoft SQL-DMO (ODBC SQL-STATE 42000)
> Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
> All I know is that it is an error of severity 16.
|||The issue has been solved by changing the names of the filenames.
Thanks for the interest.
"Tibor Karaszi" wrote:
> Can you post the SQL command you executed?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Kostas Kourtides" <Kostas Kourtides@.discussions.microsoft.com> wrote in message
> news:1E944558-4968-4249-AC6B-9B9FCF87AB25@.microsoft.com...
>
>
5041. MODIFY FILE failed. File '%.*ls' does not exist.
I am trying to change the file growth of a database file by 10% and I get an error message.
Microsoft SQL-DMO (ODBC SQL-STATE 42000)
Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
All I know is that it is an error of severity 16.Can you post the SQL command you executed?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kostas Kourtides" <Kostas Kourtides@.discussions.microsoft.com> wrote in message
news:1E944558-4968-4249-AC6B-9B9FCF87AB25@.microsoft.com...
> I am trying to change the file growth of a database file by 10% and I get an error message.
> Microsoft SQL-DMO (ODBC SQL-STATE 42000)
> Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
> All I know is that it is an error of severity 16.|||The issue has been solved by changing the names of the filenames.
Thanks for the interest.
"Tibor Karaszi" wrote:
> Can you post the SQL command you executed?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Kostas Kourtides" <Kostas Kourtides@.discussions.microsoft.com> wrote in message
> news:1E944558-4968-4249-AC6B-9B9FCF87AB25@.microsoft.com...
> > I am trying to change the file growth of a database file by 10% and I get an error message.
> >
> > Microsoft SQL-DMO (ODBC SQL-STATE 42000)
> >
> > Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
> >
> > All I know is that it is an error of severity 16.
>
>
Microsoft SQL-DMO (ODBC SQL-STATE 42000)
Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
All I know is that it is an error of severity 16.Can you post the SQL command you executed?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kostas Kourtides" <Kostas Kourtides@.discussions.microsoft.com> wrote in message
news:1E944558-4968-4249-AC6B-9B9FCF87AB25@.microsoft.com...
> I am trying to change the file growth of a database file by 10% and I get an error message.
> Microsoft SQL-DMO (ODBC SQL-STATE 42000)
> Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
> All I know is that it is an error of severity 16.|||The issue has been solved by changing the names of the filenames.
Thanks for the interest.
"Tibor Karaszi" wrote:
> Can you post the SQL command you executed?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Kostas Kourtides" <Kostas Kourtides@.discussions.microsoft.com> wrote in message
> news:1E944558-4968-4249-AC6B-9B9FCF87AB25@.microsoft.com...
> > I am trying to change the file growth of a database file by 10% and I get an error message.
> >
> > Microsoft SQL-DMO (ODBC SQL-STATE 42000)
> >
> > Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
> >
> > All I know is that it is an error of severity 16.
>
>
5041. MODIFY FILE failed. File '%.*ls' does not exist.
I am trying to change the file growth of a database file by 10% and I get an
error message.
Microsoft SQL-DMO (ODBC SQL-STATE 42000)
Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
All I know is that it is an error of severity 16.Can you post the SQL command you executed?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kostas Kourtides" <Kostas Kourtides@.discussions.microsoft.com> wrote in mes
sage
news:1E944558-4968-4249-AC6B-9B9FCF87AB25@.microsoft.com...
> I am trying to change the file growth of a database file by 10% and I get
an error message.
> Microsoft SQL-DMO (ODBC SQL-STATE 42000)
> Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
> All I know is that it is an error of severity 16.|||The issue has been solved by changing the names of the filenames.
Thanks for the interest.
"Tibor Karaszi" wrote:
> Can you post the SQL command you executed?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Kostas Kourtides" <Kostas Kourtides@.discussions.microsoft.com> wrote in m
essage
> news:1E944558-4968-4249-AC6B-9B9FCF87AB25@.microsoft.com...
>
>
error message.
Microsoft SQL-DMO (ODBC SQL-STATE 42000)
Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
All I know is that it is an error of severity 16.Can you post the SQL command you executed?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Kostas Kourtides" <Kostas Kourtides@.discussions.microsoft.com> wrote in mes
sage
news:1E944558-4968-4249-AC6B-9B9FCF87AB25@.microsoft.com...
> I am trying to change the file growth of a database file by 10% and I get
an error message.
> Microsoft SQL-DMO (ODBC SQL-STATE 42000)
> Error 5041 MODIFY FILE failed. File '%.*ls' does not exist.
> All I know is that it is an error of severity 16.|||The issue has been solved by changing the names of the filenames.
Thanks for the interest.
"Tibor Karaszi" wrote:
> Can you post the SQL command you executed?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Kostas Kourtides" <Kostas Kourtides@.discussions.microsoft.com> wrote in m
essage
> news:1E944558-4968-4249-AC6B-9B9FCF87AB25@.microsoft.com...
>
>
50(The request is not supported.)
I'm attempting to create an assembly in SQL Server Management Studio
express and I'm getting the following error message.
Msg 6502, Level 16, State 7, Line 1
CREATE ASSEMBLY failed because it could not read from the physical file
'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
supported.).
I've tried a ton of different things and I can't get this to work. Does
anyone have any ideas?<DIV>"IndyChris" <chrisshearier@.yahoo.com> wrote in message
news:1157049490.180110.320140@.74g2000cwt.googlegroups.com...</DIV>> I'm
attempting to create an assembly in SQL Server Management Studio
> express and I'm getting the following error message.
> Msg 6502, Level 16, State 7, Line 1
> CREATE ASSEMBLY failed because it could not read from the physical file
> 'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
> supported.).
> I've tried a ton of different things and I can't get this to work. Does
> anyone have any ideas?
>
Put the DLL in a folder that SQL Server can access, and reference it there.
David
express and I'm getting the following error message.
Msg 6502, Level 16, State 7, Line 1
CREATE ASSEMBLY failed because it could not read from the physical file
'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
supported.).
I've tried a ton of different things and I can't get this to work. Does
anyone have any ideas?<DIV>"IndyChris" <chrisshearier@.yahoo.com> wrote in message
news:1157049490.180110.320140@.74g2000cwt.googlegroups.com...</DIV>> I'm
attempting to create an assembly in SQL Server Management Studio
> express and I'm getting the following error message.
> Msg 6502, Level 16, State 7, Line 1
> CREATE ASSEMBLY failed because it could not read from the physical file
> 'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
> supported.).
> I've tried a ton of different things and I can't get this to work. Does
> anyone have any ideas?
>
Put the DLL in a folder that SQL Server can access, and reference it there.
David
50(The request is not supported.)
I'm attempting to create an assembly in SQL Server Management Studio
express and I'm getting the following error message.
Msg 6502, Level 16, State 7, Line 1
CREATE ASSEMBLY failed because it could not read from the physical file
'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
supported.).
I've tried a ton of different things and I can't get this to work. Does
anyone have any ideas?<DIV>"IndyChris" <chrisshearier@.yahoo.com> wrote in message
news:1157049490.180110.320140@.74g2000cwt.googlegroups.com...</DIV>> I'm
attempting to create an assembly in SQL Server Management Studio
> express and I'm getting the following error message.
> Msg 6502, Level 16, State 7, Line 1
> CREATE ASSEMBLY failed because it could not read from the physical file
> 'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
> supported.).
> I've tried a ton of different things and I can't get this to work. Does
> anyone have any ideas?
>
Put the DLL in a folder that SQL Server can access, and reference it there.
David
express and I'm getting the following error message.
Msg 6502, Level 16, State 7, Line 1
CREATE ASSEMBLY failed because it could not read from the physical file
'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
supported.).
I've tried a ton of different things and I can't get this to work. Does
anyone have any ideas?<DIV>"IndyChris" <chrisshearier@.yahoo.com> wrote in message
news:1157049490.180110.320140@.74g2000cwt.googlegroups.com...</DIV>> I'm
attempting to create an assembly in SQL Server Management Studio
> express and I'm getting the following error message.
> Msg 6502, Level 16, State 7, Line 1
> CREATE ASSEMBLY failed because it could not read from the physical file
> 'Iit457wks1.Telspan.Intra\c$\TriggerUpdate.dll': 50(The request is not
> supported.).
> I've tried a ton of different things and I can't get this to work. Does
> anyone have any ideas?
>
Put the DLL in a folder that SQL Server can access, and reference it there.
David
Monday, February 13, 2012
462 error
We have an application that connects to a MS SQL database.
Occasionally we get this message.
"Error: 462: The remote server machine does not exist or is
unavailable"
Any thoughts as to what would be causing this?You did not provide any info about your SQL Server' s Edition and version.
Ensure your SQL Server services are running. You can check them using SQL
Server Configuration Manager.
In SQL Server 2005 Express or Developer Edition, Remote Connections will be
disabled by default. Go to Surface Area Configuration tool to enable it.
If you have not, configure TCP\IP or NP protocol from SQL Server
Configuration Manager.
Also, can you post your connection string?
--
Ekrem Önsoy
"MikeS" <mike.sheats@.gmail.com> wrote in message
news:1193231306.041192.37630@.i13g2000prf.googlegroups.com...
> We have an application that connects to a MS SQL database.
> Occasionally we get this message.
> "Error: 462: The remote server machine does not exist or is
> unavailable"
> Any thoughts as to what would be causing this?
>|||I have seen this error, but its been a while. As I recall, the problem was
in DNS.
In SQL Server (2008, 2005, 2000, 7, 6.5, etc, etc, etc ... and Windows XP,
2000, 2003, etc, etc, etc ...) you access a remote server by hostname. What
this means is that you're dependent on the network DNS service (or possibly
your local hosts file) to provide you with the IP address you actually need
to connect.
While I dislike making connections via IP address, if you change your app to
use the IP and the problem goes away, it will confirm that the problem is
DNS.
Good luck,
Jay
PS. It is generally better to specify DB Server & OS versions. It's at your
fingertips and you never know when it will be relevant. Of course, I forget
sometimes too :)
"MikeS" <mike.sheats@.gmail.com> wrote in message
news:1193231306.041192.37630@.i13g2000prf.googlegroups.com...
> We have an application that connects to a MS SQL database.
> Occasionally we get this message.
> "Error: 462: The remote server machine does not exist or is
> unavailable"
> Any thoughts as to what would be causing this?
>
Occasionally we get this message.
"Error: 462: The remote server machine does not exist or is
unavailable"
Any thoughts as to what would be causing this?You did not provide any info about your SQL Server' s Edition and version.
Ensure your SQL Server services are running. You can check them using SQL
Server Configuration Manager.
In SQL Server 2005 Express or Developer Edition, Remote Connections will be
disabled by default. Go to Surface Area Configuration tool to enable it.
If you have not, configure TCP\IP or NP protocol from SQL Server
Configuration Manager.
Also, can you post your connection string?
--
Ekrem Önsoy
"MikeS" <mike.sheats@.gmail.com> wrote in message
news:1193231306.041192.37630@.i13g2000prf.googlegroups.com...
> We have an application that connects to a MS SQL database.
> Occasionally we get this message.
> "Error: 462: The remote server machine does not exist or is
> unavailable"
> Any thoughts as to what would be causing this?
>|||I have seen this error, but its been a while. As I recall, the problem was
in DNS.
In SQL Server (2008, 2005, 2000, 7, 6.5, etc, etc, etc ... and Windows XP,
2000, 2003, etc, etc, etc ...) you access a remote server by hostname. What
this means is that you're dependent on the network DNS service (or possibly
your local hosts file) to provide you with the IP address you actually need
to connect.
While I dislike making connections via IP address, if you change your app to
use the IP and the problem goes away, it will confirm that the problem is
DNS.
Good luck,
Jay
PS. It is generally better to specify DB Server & OS versions. It's at your
fingertips and you never know when it will be relevant. Of course, I forget
sometimes too :)
"MikeS" <mike.sheats@.gmail.com> wrote in message
news:1193231306.041192.37630@.i13g2000prf.googlegroups.com...
> We have an application that connects to a MS SQL database.
> Occasionally we get this message.
> "Error: 462: The remote server machine does not exist or is
> unavailable"
> Any thoughts as to what would be causing this?
>
404 on Report Manager
My report server has been in operation for 2 months now and my report
distribution portion works fine. But yesterday I started getting this
message "The request failed with HTTP status 404: Object Not Found." on my
report manager.
1. Any ideas how to fix it.
2. If it is a reinstall how do I save the RDL files.
Windows 2000 sp4
SQL Server 2000 sp3are you using SSL? If yes, make sure your Certificate haven't expired yet.
I had a similar issue & my cert had expired.
Also, try removing & enabling SSL.
"s" wrote:
> My report server has been in operation for 2 months now and my report
> distribution portion works fine. But yesterday I started getting this
> message "The request failed with HTTP status 404: Object Not Found." on my
> report manager.
> 1. Any ideas how to fix it.
> 2. If it is a reinstall how do I save the RDL files.
>
> Windows 2000 sp4
> SQL Server 2000 sp3
>
>|||No we are not using SSL
"mresanchez" wrote:
> are you using SSL? If yes, make sure your Certificate haven't expired yet.
> I had a similar issue & my cert had expired.
> Also, try removing & enabling SSL.
> "s" wrote:
> > My report server has been in operation for 2 months now and my report
> > distribution portion works fine. But yesterday I started getting this
> > message "The request failed with HTTP status 404: Object Not Found." on my
> > report manager.
> >
> > 1. Any ideas how to fix it.
> > 2. If it is a reinstall how do I save the RDL files.
> >
> >
> > Windows 2000 sp4
> > SQL Server 2000 sp3
> >
> >
> >
distribution portion works fine. But yesterday I started getting this
message "The request failed with HTTP status 404: Object Not Found." on my
report manager.
1. Any ideas how to fix it.
2. If it is a reinstall how do I save the RDL files.
Windows 2000 sp4
SQL Server 2000 sp3are you using SSL? If yes, make sure your Certificate haven't expired yet.
I had a similar issue & my cert had expired.
Also, try removing & enabling SSL.
"s" wrote:
> My report server has been in operation for 2 months now and my report
> distribution portion works fine. But yesterday I started getting this
> message "The request failed with HTTP status 404: Object Not Found." on my
> report manager.
> 1. Any ideas how to fix it.
> 2. If it is a reinstall how do I save the RDL files.
>
> Windows 2000 sp4
> SQL Server 2000 sp3
>
>|||No we are not using SSL
"mresanchez" wrote:
> are you using SSL? If yes, make sure your Certificate haven't expired yet.
> I had a similar issue & my cert had expired.
> Also, try removing & enabling SSL.
> "s" wrote:
> > My report server has been in operation for 2 months now and my report
> > distribution portion works fine. But yesterday I started getting this
> > message "The request failed with HTTP status 404: Object Not Found." on my
> > report manager.
> >
> > 1. Any ideas how to fix it.
> > 2. If it is a reinstall how do I save the RDL files.
> >
> >
> > Windows 2000 sp4
> > SQL Server 2000 sp3
> >
> >
> >
Saturday, February 11, 2012
4 processors detected - but we only have two?
Each time our server is rebooted, and SQL Server restarts, it posts an event
log message like the one below. The thing is, we only have two processors.
Does this indicate a misconfiguration, a problem, or nothing to be concerned
about? This is a brand new Dell loaded with Windows 2003 Server and SQL
Server 2000 with all patches.
Thanks in advance.
Mark
It's behaviour or hyperthreading processors (each one seems like two).
J. Lejsek
"Mark" <Mark@.nowhere.com> pe v diskusnm pspvku
news:efaTLg8$EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Each time our server is rebooted, and SQL Server restarts, it posts an
> event
> log message like the one below. The thing is, we only have two
> processors.
> Does this indicate a misconfiguration, a problem, or nothing to be
> concerned
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>
|||Hyper-Threading
http://www.intel.com/technology/hyperthread/
"Mark" wrote:
> Each time our server is rebooted, and SQL Server restarts, it posts an event
> log message like the one below. The thing is, we only have two processors.
> Does this indicate a misconfiguration, a problem, or nothing to be concerned
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>
>
log message like the one below. The thing is, we only have two processors.
Does this indicate a misconfiguration, a problem, or nothing to be concerned
about? This is a brand new Dell loaded with Windows 2003 Server and SQL
Server 2000 with all patches.
Thanks in advance.
Mark
It's behaviour or hyperthreading processors (each one seems like two).
J. Lejsek
"Mark" <Mark@.nowhere.com> pe v diskusnm pspvku
news:efaTLg8$EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Each time our server is rebooted, and SQL Server restarts, it posts an
> event
> log message like the one below. The thing is, we only have two
> processors.
> Does this indicate a misconfiguration, a problem, or nothing to be
> concerned
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>
|||Hyper-Threading
http://www.intel.com/technology/hyperthread/
"Mark" wrote:
> Each time our server is rebooted, and SQL Server restarts, it posts an event
> log message like the one below. The thing is, we only have two processors.
> Does this indicate a misconfiguration, a problem, or nothing to be concerned
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>
>
4 processors detected - but we only have two?
Each time our server is rebooted, and SQL Server restarts, it posts an event
log message like the one below. The thing is, we only have two processors.
Does this indicate a misconfiguration, a problem, or nothing to be concerned
about? This is a brand new Dell loaded with Windows 2003 Server and SQL
Server 2000 with all patches.
Thanks in advance.
MarkIt's behaviour or hyperthreading processors (each one seems like two).
J. Lejsek
"Mark" <Mark@.nowhere.com> pe v diskusnm pspvku
news:efaTLg8$EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Each time our server is rebooted, and SQL Server restarts, it posts an
> event
> log message like the one below. The thing is, we only have two
> processors.
> Does this indicate a misconfiguration, a problem, or nothing to be
> concerned
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>|||Hyper-Threading
http://www.intel.com/technology/hyperthread/
"Mark" wrote:
> Each time our server is rebooted, and SQL Server restarts, it posts an eve
nt
> log message like the one below. The thing is, we only have two processors
.
> Does this indicate a misconfiguration, a problem, or nothing to be concern
ed
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>
>
log message like the one below. The thing is, we only have two processors.
Does this indicate a misconfiguration, a problem, or nothing to be concerned
about? This is a brand new Dell loaded with Windows 2003 Server and SQL
Server 2000 with all patches.
Thanks in advance.
MarkIt's behaviour or hyperthreading processors (each one seems like two).
J. Lejsek
"Mark" <Mark@.nowhere.com> pe v diskusnm pspvku
news:efaTLg8$EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Each time our server is rebooted, and SQL Server restarts, it posts an
> event
> log message like the one below. The thing is, we only have two
> processors.
> Does this indicate a misconfiguration, a problem, or nothing to be
> concerned
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>|||Hyper-Threading
http://www.intel.com/technology/hyperthread/
"Mark" wrote:
> Each time our server is rebooted, and SQL Server restarts, it posts an eve
nt
> log message like the one below. The thing is, we only have two processors
.
> Does this indicate a misconfiguration, a problem, or nothing to be concern
ed
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>
>
4 processors detected - but we only have two?
Each time our server is rebooted, and SQL Server restarts, it posts an event
log message like the one below. The thing is, we only have two processors.
Does this indicate a misconfiguration, a problem, or nothing to be concerned
about? This is a brand new Dell loaded with Windows 2003 Server and SQL
Server 2000 with all patches.
Thanks in advance.
MarkIt's behaviour or hyperthreading processors (each one seems like two).
J. Lejsek
"Mark" <Mark@.nowhere.com> pí¹e v diskusním pøíspìvku
news:efaTLg8$EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Each time our server is rebooted, and SQL Server restarts, it posts an
> event
> log message like the one below. The thing is, we only have two
> processors.
> Does this indicate a misconfiguration, a problem, or nothing to be
> concerned
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>|||Hyper-Threading
http://www.intel.com/technology/hyperthread/
"Mark" wrote:
> Each time our server is rebooted, and SQL Server restarts, it posts an event
> log message like the one below. The thing is, we only have two processors.
> Does this indicate a misconfiguration, a problem, or nothing to be concerned
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>
>
log message like the one below. The thing is, we only have two processors.
Does this indicate a misconfiguration, a problem, or nothing to be concerned
about? This is a brand new Dell loaded with Windows 2003 Server and SQL
Server 2000 with all patches.
Thanks in advance.
MarkIt's behaviour or hyperthreading processors (each one seems like two).
J. Lejsek
"Mark" <Mark@.nowhere.com> pí¹e v diskusním pøíspìvku
news:efaTLg8$EHA.4092@.TK2MSFTNGP09.phx.gbl...
> Each time our server is rebooted, and SQL Server restarts, it posts an
> event
> log message like the one below. The thing is, we only have two
> processors.
> Does this indicate a misconfiguration, a problem, or nothing to be
> concerned
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>|||Hyper-Threading
http://www.intel.com/technology/hyperthread/
"Mark" wrote:
> Each time our server is rebooted, and SQL Server restarts, it posts an event
> log message like the one below. The thing is, we only have two processors.
> Does this indicate a misconfiguration, a problem, or nothing to be concerned
> about? This is a brand new Dell loaded with Windows 2003 Server and SQL
> Server 2000 with all patches.
> Thanks in advance.
> Mark
>
>
Subscribe to:
Posts (Atom)