log backup overwrite: February 2012

Sunday, February 26, 2012

Does anyone know how often the sysjobschedules table is updated?

Hi,
I'm trynig to write some simple code to check that all of my scheduled jobs have completed (successfully or not) by checking that the next run date and time for the active schedules is in the future. However when doing this the sysjobschedules tables
does not seem to update with the next information immediately. Does anynoe know of the frequency of this update or what controls it?
Cheers,
John
You might want to take a look at sp_help_job instead.
Andrew J. Kelly SQL MVP
"John" <j.edwards@.ausbulk.com.au> wrote in message
news:413AE3B6-4491-42AE-9412-4025D74764A6@.microsoft.com...
> Hi,
> I'm trynig to write some simple code to check that all of my scheduled
jobs have completed (successfully or not) by checking that the next run date
and time for the active schedules is in the future. However when doing this
the sysjobschedules tables does not seem to update with the next information
immediately. Does anynoe know of the frequency of this update or what
controls it?
> Cheers,
> John

Does anyone know how often the sysjobschedules table is updated?

Hi,
I'm trynig to write some simple code to check that all of my scheduled jobs
have completed (successfully or not) by checking that the next run date and
time for the active schedules is in the future. However when doing this the
sysjobschedules tables
does not seem to update with the next information immediately. Does anynoe
know of the frequency of this update or what controls it?
Cheers,
JohnYou might want to take a look at sp_help_job instead.
Andrew J. Kelly SQL MVP
"John" <j.edwards@.ausbulk.com.au> wrote in message
news:413AE3B6-4491-42AE-9412-4025D74764A6@.microsoft.com...
> Hi,
> I'm trynig to write some simple code to check that all of my scheduled
jobs have completed (successfully or not) by checking that the next run date
and time for the active schedules is in the future. However when doing this
the sysjobschedules tables does not seem to update with the next information
immediately. Does anynoe know of the frequency of this update or what
controls it?
> Cheers,
> John

Does anyone know how often the sysjobschedules table is updated?

Hi
I'm trynig to write some simple code to check that all of my scheduled jobs have completed (successfully or not) by checking that the next run date and time for the active schedules is in the future. However when doing this the sysjobschedules tables does not seem to update with the next information immediately. Does anynoe know of the frequency of this update or what controls it
Cheers
JohnYou might want to take a look at sp_help_job instead.
--
Andrew J. Kelly SQL MVP
"John" <j.edwards@.ausbulk.com.au> wrote in message
news:413AE3B6-4491-42AE-9412-4025D74764A6@.microsoft.com...
> Hi,
> I'm trynig to write some simple code to check that all of my scheduled
jobs have completed (successfully or not) by checking that the next run date
and time for the active schedules is in the future. However when doing this
the sysjobschedules tables does not seem to update with the next information
immediately. Does anynoe know of the frequency of this update or what
controls it?
> Cheers,
> John

does anyone know about this err msg?

sql2k, nt5.
I have a stored procedure drop and re-create webtask... this is the msg i've
got when running it.
Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
[SQLSTATE 42000]
does anyone know what it's about? thank you.
Steve,
You may find an explanation of this at:
http://support.microsoft.com/default...b;en-us;834116
Hope it helps,
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> sql2k, nt5.
> I have a stored procedure drop and re-create webtask... this is the msg
i've
> got when running it.
> Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
> [SQLSTATE 42000]
> does anyone know what it's about? thank you.
>
|||the job owner is sa.
I have read that article before and don't think it's related to my problem.
because the errors come and go and not related to a particular record in the
table either.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Steve,
> You may find an explanation of this at:
> http://support.microsoft.com/default...b;en-us;834116
> Hope it helps,
> Russell Fields
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> i've
statement.
>
|||Steve,
Sorry that I don't know a lot more than this. However, it is interesting
that you are running as 'sa', which I would interpret to mean you are using
Method 2 to try to work around the problem. Method 1 is to use a domain
account that has admin permissions on your server. (Interestingly, both
workarounds are "not recommended" by Microsoft.)
Anyway, have you tried the Method 1 workaround? Did it change things at
all?
You mention that the errors come and go. Do you have any idea of whether
something else in your security landscape is changing?
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:utbyTRMKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> the job owner is sa.
> I have read that article before and don't think it's related to my
problem.
> because the errors come and go and not related to a particular record in
the[vbcol=seagreen]
> table either.
> "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
msg
> statement.
>

does anyone know about this err msg?

sql2k, nt5.
I have a stored procedure drop and re-create webtask... this is the msg i've
got when running it.
Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
[SQLSTATE 42000]
does anyone know what it's about? thank you.Steve,
You may find an explanation of this at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;834116
Hope it helps,
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> sql2k, nt5.
> I have a stored procedure drop and re-create webtask... this is the msg
i've
> got when running it.
> Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
> [SQLSTATE 42000]
> does anyone know what it's about? thank you.
>|||the job owner is sa.
I have read that article before and don't think it's related to my problem.
because the errors come and go and not related to a particular record in the
table either.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
> Steve,
> You may find an explanation of this at:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;834116
> Hope it helps,
> Russell Fields
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> >
> > sql2k, nt5.
> > I have a stored procedure drop and re-create webtask... this is the msg
> i've
> > got when running it.
> >
> > Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL
statement.
> > [SQLSTATE 42000]
> >
> > does anyone know what it's about? thank you.
> >
> >
>|||Steve,
Sorry that I don't know a lot more than this. However, it is interesting
that you are running as 'sa', which I would interpret to mean you are using
Method 2 to try to work around the problem. Method 1 is to use a domain
account that has admin permissions on your server. (Interestingly, both
workarounds are "not recommended" by Microsoft.)
Anyway, have you tried the Method 1 workaround? Did it change things at
all?
You mention that the errors come and go. Do you have any idea of whether
something else in your security landscape is changing?
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:utbyTRMKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> the job owner is sa.
> I have read that article before and don't think it's related to my
problem.
> because the errors come and go and not related to a particular record in
the
> table either.
> "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
> > Steve,
> >
> > You may find an explanation of this at:
> > http://support.microsoft.com/default.aspx?scid=kb;en-us;834116
> >
> > Hope it helps,
> > Russell Fields
> >
> > "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> > news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> > >
> > > sql2k, nt5.
> > > I have a stored procedure drop and re-create webtask... this is the
msg
> > i've
> > > got when running it.
> > >
> > > Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL
> statement.
> > > [SQLSTATE 42000]
> > >
> > > does anyone know what it's about? thank you.
> > >
> > >
> >
> >
>

does anyone know about this err msg?

sql2k, nt5.
I have a stored procedure drop and re-create webtask... this is the msg i've
got when running it.
Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
[SQLSTATE 42000]
does anyone know what it's about? thank you.Steve,
You may find an explanation of this at:
http://support.microsoft.com/defaul...kb;en-us;834116
Hope it helps,
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> sql2k, nt5.
> I have a stored procedure drop and re-create webtask... this is the msg
i've
> got when running it.
> Msg 16805, Sev 11: SQL Web Assistant: Could not execute the SQL statement.
> [SQLSTATE 42000]
> does anyone know what it's about? thank you.
>|||the job owner is sa.
I have read that article before and don't think it's related to my problem.
because the errors come and go and not related to a particular record in the
table either.
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
> Steve,
> You may find an explanation of this at:
> http://support.microsoft.com/defaul...kb;en-us;834116
> Hope it helps,
> Russell Fields
> "Steve Lin" <lins@.nospam.portptld.com> wrote in message
> news:On50IjJKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> i've
statement.[vbcol=seagreen]
>|||Steve,
Sorry that I don't know a lot more than this. However, it is interesting
that you are running as 'sa', which I would interpret to mean you are using
Method 2 to try to work around the problem. Method 1 is to use a domain
account that has admin permissions on your server. (Interestingly, both
workarounds are "not recommended" by Microsoft.)
Anyway, have you tried the Method 1 workaround? Did it change things at
all?
You mention that the errors come and go. Do you have any idea of whether
something else in your security landscape is changing?
Russell Fields
"Steve Lin" <lins@.nospam.portptld.com> wrote in message
news:utbyTRMKEHA.2580@.TK2MSFTNGP12.phx.gbl...
> the job owner is sa.
> I have read that article before and don't think it's related to my
problem.
> because the errors come and go and not related to a particular record in
the
> table either.
> "Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
> news:OUX#goKKEHA.2888@.TK2MSFTNGP09.phx.gbl...
msg[vbcol=seagreen]
> statement.
>

Does anyone know a utility/batch script to Warn when close to Max DB size

Hello Group
Does anyone know of a utility or Batch script (osql or Windows cmd or mix)
to Warn an Admin when a MSDE DB is closing in on 2 GB in size (or 2005
Express closes in on 4 GB).
Any leads or tips will be appriciated highly
Best regards
Uffe
hi Uffe,
Uffe Bak wrote:
> Hello Group
> Does anyone know of a utility or Batch script (osql or Windows cmd or
> mix) to Warn an Admin when a MSDE DB is closing in on 2 GB in size
> (or 2005 Express closes in on 4 GB).
> Any leads or tips will be appriciated highly
> Best regards
> Uffe
in MSDE you can perhaps schedule a job defined to include a way to gather
that kind of data, using direct access to the sysfiles database table or via
DBCC SHOWFILESTATS..
you can then validate that data against a userdefined treshold and notify
someone via NET SEND or mail via SMPT alternative, like exploded in
http://www.karaszi.com/sqlserver/info_no_mapi.asp,
http://www.dbmaint.com/SmtpAlerter.asp , thus defining a kind of alert..
PRINT 'MSDE';
PRINT '--';
USE Northwind;
PRINT 'sp_spaceused';
EXEC sp_spaceused @.updateusage = 'TRUE';
PRINT '--';
PRINT 'DBCC SHOWFILESTATS';
CREATE TABLE #tmp_sfs (
fileid int,
filegroup int,
totalextents int,
usedextents int,
name varchar(1024),
filename varchar(1024)
);
INSERT INTO #tmp_sfs
EXECUTE('DBCC SHOWFILESTATS');
SELECT LEFT(DB_NAME(),10), (SUM(totalextents) * 64) / 1024 AS [totalextents
in MB], (SUM(usedextents) * 64) /1024 AS [usedextents in MB]
FROM #tmp_sfs;
DROP TABLE #tmp_sfs;
PRINT '--';
PRINT 'sysdatabase query';
SELECT LEFT(DB_NAME(),10) AS [Database], sum(convert(float,size)) * (8192.0
/1024.0) /1024.0 AS [Size in MB for Data files]
FROM dbo.sysfiles
WHERE (status & 0x40) <> 0x40;
SQLExpress does not provide the SQL Server Agent, so you can perhaps rely on
the native OS scheduler for something similar.. as regards the SMPT
integration, you have to (possibly) write your own CLR based mailer
solution.. I personally will... then, from the OS scheduler, you'll execute
SqlCmd command line tool to perform the SQLExpress connection and data
retrival...
just an idea..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks to Andrea and Satya for quick answers
I will look into your suggestions and return if I find a solution.
I also looked up some Scripting options, so there are as usual more than one
road to Rome
Best regards
Uffe Bak

does anyone have the old SQL server versions?

I would really love to see how the old SQL server versions looked like ..I
would love to get a copy to install and see what it looked like..
Any verion prior to 7.0. Can anyone upload it to their site if its legal to
download ?
ThanksCheck out www.ebay.com for SQL Server 6.5 and 7.0. You should determine for
yourself that any software you purchase is genuine and legal.
--
David Portas
SQL Server MVP
--|||For a real laugh, have a look at version 4.21 - the one I started with.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Hassan wrote:
> I would really love to see how the old SQL server versions looked like ..I
> would love to get a copy to install and see what it looked like..
> Any verion prior to 7.0. Can anyone upload it to their site if its legal to
> download ?
> Thanks
>|||This is a multi-part message in MIME format.
--040700040605000703020101
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Me too - quality software (just like Windows NT 3.51 - quality).
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Mark Allison wrote:
> For a real laugh, have a look at version 4.21 - the one I started with.
--040700040605000703020101
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Me too - quality software (just like Windows NT 3.51 - quality).</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Mark Allison wrote:
<blockquote cite="midODn$KMxcFHA.3488@.tk2msftngp13.phx.gbl" type="cite">For
a real laugh, have a look at version 4.21 - the one I started with.
 
</blockquote>
</body>
</html>
--040700040605000703020101--|||Looks great on OS/2 Warp too. :-)
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Mike Hodgson wrote:
> Me too - quality software (just like Windows NT 3.51 - quality).
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
>|||Do you guys have a copy of 4.2 ? Would love to have it as a collectible
"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl...
> Looks great on OS/2 Warp too. :-)
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Mike Hodgson wrote:
> > Me too - quality software (just like Windows NT 3.51 - quality).
> >
> > --
> > *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> > *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> > *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
http://www.mallesons.com
> >|||This is a multi-part message in MIME format.
--050308050508020305020302
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Not me. The earliest one I've kept is 6.5 but I've worked with 4.21,
6.0, 6.5, 7.0, 2000 & 2005 (beta) and I really don't want to go back
prior to 7.0 now (I've been spoilt). Can't wait to start plugging away
on Yukon production boxes (up until now it's been only "play" instances)
- I find Yukon a really exciting new version (with a fair bit of
potential for abuse, i.e. CLR integration - good for some things like
user-defined aggregates but should be used with extreme care methinks).
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
Hassan wrote:
>Do you guys have a copy of 4.2 ? Would love to have it as a collectible
>"Mark Allison" <mark@.no.tinned.meat.mvps.org> wrote in message
>news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl...
>
>>Looks great on OS/2 Warp too. :-)
>>--
>>Mark Allison, SQL Server MVP
>>http://www.markallison.co.uk
>>Looking for a SQL Server replication book?
>>http://www.nwsu.com/0974973602m.html
>>
>>Mike Hodgson wrote:
>>
>>Me too - quality software (just like Windows NT 3.51 - quality).
>>--
>>*mike hodgson* |/ database administrator/ | mallesons stephen jaques
>>*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
>>*E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
>>
>http://www.mallesons.com
>
>
>
--050308050508020305020302
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Not me. The earliest one I've kept is 6.5 but I've worked with
4.21, 6.0, 6.5, 7.0, 2000 & 2005 (beta) and I really don't want to
go back prior to 7.0 now (I've been spoilt). Can't wait to start
plugging away on Yukon production boxes (up until now it's been only
"play" instances) - I find Yukon a really exciting new version (with a
fair bit of potential for abuse, i.e. CLR integration - good for some
things like user-defined aggregates but should be used with extreme
care methinks).</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson | database administrator
| mallesons stephen jaques 
T +61 (2) 9296 3668 | F +61
(2) 9296 3885 | M +61
(408) 675 907 
E
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> | W <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a> 
</div>
 
 
Hassan wrote:
<blockquote cite="mid%23VjR3E2cFHA.2436@.TK2MSFTNGP10.phx.gbl"
type="cite">
<pre wrap="">Do you guys have a copy of 4.2 ? Would love to have it as a collectible
"Mark Allison" <a class="moz-txt-link-rfc2396E" href="http://links.10026.com/?link=mailto:mark@.no.tinned.meat.mvps.org"><mark@.no.tinned.meat.mvps.org></a> wrote in message
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl">news:%23QZM2hxcFHA.3120@.TK2MSFTNGP12.phx.gbl</a>...
</pre>
<blockquote type="cite">
<pre wrap="">Looks great on OS/2 Warp too. :-)
--
Mark Allison, SQL Server MVP
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.markallison.co.uk</a>">http://www.markallison.co.uk">http://www.markallison.co.uk</a>
Looking for a SQL Server replication book?
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://www.nwsu.com/0974973602m.html</a>">http://www.nwsu.com/0974973602m.html">http://www.nwsu.com/0974973602m.html</a>
Mike Hodgson wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Me too - quality software (just like Windows NT 3.51 - quality).
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* <a class="moz-txt-link-freetext" href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a> |* W*
</pre>
</blockquote>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
</body>
</html>
--050308050508020305020302--

does anyone have the old SQL server versions?

Does anyone have sql2005 EE running on 64 bit Itanium server?

I don't think mine is using all of the memory it could on the server. I've read that the Task Manager does not give you an accurate measure of the memory usage but 130 MB max does not seem right on a 12 GB server. I've set the minimum to 2 GB in SSMS. The account that is running sqlservice has Lock Pages in Memory privileges. I've turned on AWE in SSMS just to be safe. We are experiencing high CPU usage and my theory is that it is caused my unnecessary I/O due to not being able to cache. The serve has Windows 2003 sp1. The SQL2005 Buffer Manager AWE Lookup maps\sec, stolen maps\sec, unmap calls/sec, unmap pages/sec, write maps/sec are all 0.

Any help would be appreciated. Below is the out from DBCC MEMORYSTATUS. This server also has an instance of sql2000 EE on it with max memory set to 5 GB and it seems to be running fine.

Memory Manager KB

VM Reserved 12687344

VM Committed 87304

AWE Allocated 3211008

Reserved Memory 1024

Reserved Memory In Use 0

(5 row(s) affected)

Memory node Id = 0 KB

VM Reserved 12681712

VM Committed 81752

AWE Allocated 3211008

MultiPage Allocator 19864

SinglePage Allocator 272960

(5 row(s) affected)

MEMORYCLERK_SQLGENERAL (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 4240

MultiPage Allocator 4984

(7 row(s) affected)

MEMORYCLERK_SQLBUFFERPOOL (Total) KB

- --

VM Reserved 12615680

VM Committed 16384

AWE Allocated 3211008

SM Reserved 0

SM Commited 0

SinglePage Allocator 0

MultiPage Allocator 1128

(7 row(s) affected)

MEMORYCLERK_SQLQUERYEXEC (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 88

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SQLOPTIMIZER (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 672

MultiPage Allocator 96

(7 row(s) affected)

MEMORYCLERK_SQLUTILITIES (Total) KB

- --

VM Reserved 240

VM Committed 240

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 320

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SQLSTORENG (Total) KB

- --

VM Reserved 3904

VM Committed 3904

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 1280

MultiPage Allocator 472

(7 row(s) affected)

MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 728

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SQLCLR (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKER (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 112

MultiPage Allocator 320

(7 row(s) affected)

MEMORYCLERK_SQLHTTP (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SNI (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 72

MultiPage Allocator 16

(7 row(s) affected)

MEMORYCLERK_FULLTEXT (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SQLXP (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_BHF (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 56

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SQLQERESERVATIONS (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 331616

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_HOST (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

MEMORYCLERK_SOSNODE (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 3416

MultiPage Allocator 11360

(7 row(s) affected)

MEMORYCLERK_SQLSERVICEBROKERTRANSPORT (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 48

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_OBJCP (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 69400

MultiPage Allocator 672

(7 row(s) affected)

CACHESTORE_SQLCP (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 166824

MultiPage Allocator 32

(7 row(s) affected)

CACHESTORE_PHDR (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 17944

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_XPROC (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 144

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_TEMPTABLES (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 32

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_NOTIF (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_VIEWDEFINITIONS (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_XMLDBTYPE (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_XMLDBELEMENT (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_XMLDBATTRIBUTE (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_STACKFRAMES (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 0

MultiPage Allocator 8

(7 row(s) affected)

CACHESTORE_BROKERTBLACS (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 456

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_BROKERKEK (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_BROKERDSH (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_BROKERUSERCERTLOOKUP (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_BROKERRSB (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_BROKERREADONLY (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 96

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_BROKERTO (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 8

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_EVENTS (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 16

MultiPage Allocator 0

(7 row(s) affected)

CACHESTORE_SYSTEMROWSET (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 1784

MultiPage Allocator 0

(7 row(s) affected)

USERSTORE_SCHEMAMGR (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 2192

MultiPage Allocator 0

(7 row(s) affected)

USERSTORE_DBMETADATA (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 2800

MultiPage Allocator 0

(7 row(s) affected)

USERSTORE_TOKENPERM (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 872

MultiPage Allocator 0

(7 row(s) affected)

USERSTORE_OBJPERM (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 256

MultiPage Allocator 0

(7 row(s) affected)

USERSTORE_SXC (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 168

MultiPage Allocator 0

(7 row(s) affected)

OBJECTSTORE_LBSS (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 32

MultiPage Allocator 544

(7 row(s) affected)

OBJECTSTORE_SNI_PACKET (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 1824

MultiPage Allocator 48

(7 row(s) affected)

OBJECTSTORE_SERVICE_BROKER (Total) KB

- --

VM Reserved 0

VM Committed 0

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 288

MultiPage Allocator 0

(7 row(s) affected)

OBJECTSTORE_LOCK_MANAGER (Total) KB

- --

VM Reserved 8192

VM Committed 8192

AWE Allocated 0

SM Reserved 0

SM Commited 0

SinglePage Allocator 20856

MultiPage Allocator 0

(7 row(s) affected)

Buffer Distribution Buffers

Stolen 13626

Free 28271

Cached 33153

Database (clean) 315604

Database (dirty) 2557

I/O 0

Latched 5

(7 row(s) affected)

Buffer Counts Buffers

Committed 393216

Target 393216

Hashed 318166

Stolen Potential 297983

External Reservation 28759

Min Free 64

Visible 393216

Available Paging File 2528231

(8 row(s) affected)

Procedure Cache Value

TotalProcs 2358

TotalPages 31877

InUsePages 425

(3 row(s) affected)

Global Memory Objects Buffers

Resource 257

Locks 2610

XDES 42

SETLS 2

SE Dataset Allocators 4

SubpDesc Allocators 2

SE SchemaManager 273

SQLCache 505

Replication 2

ServerGlobal 48

XP Global 2

SortTables 2

(12 row(s) affected)

Query Memory Objects Value

Grants 1

Waiting 0

Available (Buffers) 241218

Maximum (Buffers) 282670

Limit 282670

Next Request 0

Waiting For 0

Cost 0

Timeout 0

Wait Time 0

Last Target 295470

(11 row(s) affected)

Small Query Memory Objects Value

Grants 0

Waiting 0

Available (Buffers) 12800

Maximum (Buffers) 12800

Limit 12800

(5 row(s) affected)

Optimization Queue Value

Overall Memory 2581880832

Target Memory 2209619968

Last Notification 1

Timeout 6

Early Termination Factor 5

(5 row(s) affected)

Small Gateway Value

Configured Units 8

Available Units 8

Acquires 0

Waiters 0

Threshold Factor 500000

Threshold 500000

(6 row(s) affected)

Medium Gateway Value

Configured Units 2

Available Units 2

Acquires 0

Waiters 0

Threshold Factor 12

(5 row(s) affected)

Big Gateway Value

Configured Units 1

Available Units 1

Acquires 0

Waiters 0

Threshold Factor 8

(5 row(s) affected)

MEMORYBROKER_FOR_CACHE Value

-- --

Allocations 33157

Rate 2

Target Allocations 301911

Future Allocations 0

Last Notification 1

(5 row(s) affected)

MEMORYBROKER_FOR_STEAL Value

-- --

Allocations 963

Rate 14

Target Allocations 269729

Future Allocations 0

Last Notification 1

(5 row(s) affected)

MEMORYBROKER_FOR_RESERVE Value

-- --

Allocations 41452

Rate 21351

Target Allocations 315171

Future Allocations 70667

Last Notification 1

(5 row(s) affected)

What "edition" of 2003 is installed. You need to have Enterprise or Data Center installed for 12gb of RAM. See http://www.microsoft.com/windowsserver2003/evaluation/features/comparefeatures.mspx.

Did you set PAE in the Windows boot.ini? If you right click on "My Computer" and select "Properties", how much memory does it show and does it say "Physical Address Extension" after the RAM?

2005 only allocates memory when needed, instead of 2000 which just grabs it all when the service starts.|||

win 2003 EE sp1.

The server doesn't seem to have a boot.ini file. Does 64 bit itanium servers usually have one?

The my computer reading is 11.9 GB of Ram. It does not say "Physical Address Extendsions"

The sql2000 instance is using 6 GB of ram so AWE should be working but it isn't for sql2005.

We use a lot of table variable in 2005 that are stored in memory if it is available an I think sql is thinking there isn't any and writing them to the tempdb instead.

Thanks for responding to my post

|||I forgot in 64bit you don't set PAE, that is only a 32 bit problem.

In SQL 2005 tempdb usage was completely changed. It now stores a lot of temp data that 2000 had in RAM, in tempdb.

See: http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx|||I read that one yesterday. "System" has locked pages in memory rights. Our instance is running under "Local System" so it should be doing this, right.|||I talked to someone at Microsoft and they said to ignore Task Manager reading (nice). You can tell SQL memory usage by using Performance Monitor object SQL Memory Management counters "Target Server Memory" and "Total Server Memory". So, unless you are a DBA and know about this Task Manager misleads you.

Does anyone have Northwind database file for SQLExpress ?

Hello.
Does anyone have Northwind database file for SQLExpress ? I really need it for learning purpose now.

Thanks in advanced.You can download ithere.

Don

Does anyone have example of opening SQL Server with ODBC using MFC

Does anyone have example of opening SQL Server with ODBC using MFCTry doing a search on http://msdn.microsoft.com/ using keywords "ODBC MFC".
One example I found was
http://msdn.microsoft.com/library/d...-us/vccore/html
/_core_ODBC_and_MFC.asp
It seems like it contains some useful infromation.
Good luck!
--
| From: "Bhavin Patel" <bpatel@.epcon.com>
| Subject: Does anyone have example of opening SQL Server with ODBC using
MFC
| Date: Tue, 13 Sep 2005 00:13:42 -0500
| Lines: 2
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| Message-ID: <eqjHuHCuFHA.444@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: h86.74.29.71.ip.alltel.net 71.29.74.86
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2699
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
|
|
|

Does anyone have example of opening SQL Server with ODBC using MFC

Does anyone have example of opening SQL Server with ODBC using MFCTry doing a search on http://msdn.microsoft.com/ using keywords "ODBC MFC".
One example I found was
http://msdn.microsoft.com/library/de...us/vccore/html
/_core_ODBC_and_MFC.asp
It seems like it contains some useful infromation.
Good luck!
| From: "Bhavin Patel" <bpatel@.epcon.com>
| Subject: Does anyone have example of opening SQL Server with ODBC using
MFC
| Date: Tue, 13 Sep 2005 00:13:42 -0500
| Lines: 2
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| Message-ID: <eqjHuHCuFHA.444@.TK2MSFTNGP15.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: h86.74.29.71.ip.alltel.net 71.29.74.86
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFT NGP15.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2699
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
|
|
|

Does anyone have any ideas ..

... on making a DB map?
Hopefully someone knows of a tool/util.
Here's where I'm coming from:
We have a list of changes to make to our DB and the PHP interface.
I'd like to put together a list (map) of every table referenced on
each php page, as well as one showing every php page which uses each
table.
I'd like to have this as a reference so that when we bring in a
programmer, they can work more efficiently and be less likely to
create bugs.
Any ideas?
-Mo
Do you mean an ERD? How about using the diagram tool built into SQL Server.
If you are on 2000 it can be found in Enterprise Manage and if 2005 in SSMS.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Mo" <Mehile.Orloff@.gmail.com> wrote in message
news:6db5c30c-f1a4-4725-831a-790fa7dbd3de@.s19g2000prg.googlegroups.com...
> .. on making a DB map?
> Hopefully someone knows of a tool/util.
> Here's where I'm coming from:
> We have a list of changes to make to our DB and the PHP interface.
> I'd like to put together a list (map) of every table referenced on
> each php page, as well as one showing every php page which uses each
> table.
> I'd like to have this as a reference so that when we bring in a
> programmer, they can work more efficiently and be less likely to
> create bugs.
> Any ideas?
> -Mo
|||On Mar 3, 5:33Xpm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> Do you mean an ERD? XHow about using the diagram tool built into SQL Server.
> If you are on 2000 it can be found in Enterprise Manage and if 2005 in SSMS.
> --
> Andrew J. Kelly X XSQL MVP
> Solid Quality Mentors
> "Mo" <Mehile.Orl...@.gmail.com> wrote in message
> news:6db5c30c-f1a4-4725-831a-790fa7dbd3de@.s19g2000prg.googlegroups.com...
>
>
>
>
>
> - Show quoted text -
Thanks for the suggestions.
I'll start there.
-Mo

Does anyone have any ideas ..

.. on making a DB map?
Hopefully someone knows of a tool/util.
Here's where I'm coming from:
We have a list of changes to make to our DB and the PHP interface.
I'd like to put together a list (map) of every table referenced on
each php page, as well as one showing every php page which uses each
table.
I'd like to have this as a reference so that when we bring in a
programmer, they can work more efficiently and be less likely to
create bugs.
Any ideas?
-MoDo you mean an ERD? How about using the diagram tool built into SQL Server.
If you are on 2000 it can be found in Enterprise Manage and if 2005 in SSMS.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Mo" <Mehile.Orloff@.gmail.com> wrote in message
news:6db5c30c-f1a4-4725-831a-790fa7dbd3de@.s19g2000prg.googlegroups.com...
> .. on making a DB map?
> Hopefully someone knows of a tool/util.
> Here's where I'm coming from:
> We have a list of changes to make to our DB and the PHP interface.
> I'd like to put together a list (map) of every table referenced on
> each php page, as well as one showing every php page which uses each
> table.
> I'd like to have this as a reference so that when we bring in a
> programmer, they can work more efficiently and be less likely to
> create bugs.
> Any ideas?
> -Mo|||On Mar 3, 5:33=A0pm, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> Do you mean an ERD? =A0How about using the diagram tool built into SQL Ser=ver.
> If you are on 2000 it can be found in Enterprise Manage and if 2005 in SSM=S.
> --
> Andrew J. Kelly =A0 =A0SQL MVP
> Solid Quality Mentors
> "Mo" <Mehile.Orl...@.gmail.com> wrote in message
> news:6db5c30c-f1a4-4725-831a-790fa7dbd3de@.s19g2000prg.googlegroups.com...
>
> > .. on making a DB map?
> > Hopefully someone knows of a tool/util.
> > Here's where I'm coming from:
> > We have a list of changes to make to our DB and the PHP interface.
> > I'd like to put together a list (map) of every table referenced on
> > each php page, as well as one showing every php page which uses each
> > table.
> > I'd like to have this as a reference so that when we bring in a
> > programmer, they can work more efficiently and be less likely to
> > create bugs.
> > Any ideas?
> > -Mo- Hide quoted text -
> - Show quoted text -
Thanks for the suggestions.
I'll start there.
-Mo

Does anyone have an ForEachColumn Procedure?

Hi

Does anyone have an ForEachColumn Procedure?
(a bit like the MSforeachdb and MSforeachtable sps)

This should be quite generic for anyone working with real life data coming in from other systems.

I need to fill out the rows with missing values in historic records from the previous current record.
(sometimes even from a previous historic record)
And sometimes the current record doesn't have data in the field, so I shouldn't get the data from current -1.

Can solve most of the complexities of the filling out part.

But it needs to be applied for (most of) my 57 columns,and then there is even some differently formatted data just beyond the horizon, so maybe I should try to get a more generic applicable solution.

Did anyone try a ForEachColumnExcept procedure

CREATE PROCEDURE ForEachColumnExcept
@.TableName varchar(200)
, @.ExceptionList varchar(8000) = '' -- the few ones to exclude
, @.DelimterInExceptionlist varchar(10) = ','
AS
...
END

the difficulty here is getting the columns from the databse's data-dictionary
)haven't done that before, but I think I'll find that out.

Or even:

CREATE PROCEDURE ForEachColumnInList
@.TableName varchar(200)
, @.ColumnList varchar(8000) -- all the ones to include
, @.DelimterInColumnList varchar(10) = ','
AS
...
END

Cheers

Drionot sure what u finally want to do with the column list, this will however generate a column list & data type based on params u declared

set @.ExceptionList = ','+ @.ExceptionList + ','
select Column_name,Data_Type from information_schema.columns
where table_name=@.TableName and column_name not in (case when charindex(','+column_name+',',@.ExceptionList) > 0 then column_name else '' end)

Does anyone have a script to reset SQL login passwords?

We are doing a consolodation whereby we are pulling 2 servers into one big one. We have a problem with duplicate logins and differing passwords. I want to be able to cursor (or tran?) through a list of logins resetting their passwords to a default.

This will currently run under SQL 2000, but I may want to do it on our 2K5 server at some time - I feel the second part may be more difficult though.

Does anyone have a script lying around in their armoury that will do this?

Thanks in advance

Under SQL 2000, I think I can cursor through master.dbo.sysxlogins and reset the passwords using sp_password, :

sp_password Null, 'Newpassword', 'loginname'

Anyone see a problem with the above?

|||

Hi,

this should be no problem, but keep in mind that in SQL Server 2005 has another table for the logins:

Select * from sys.syslogins

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

In SQL Server 2005, you can issue for each login a statement like:

ALTER LOGIN <login_name> WITH PASSWORD = <default_password>

See http://msdn2.microsoft.com/en-US/library/ms189828.aspx for more information on ALTER LOGIN.

Thanks
Laurentiu

|||

Also, in SQL Server 2005, the catalog for SQL logins is sys.sql_logins:

http://msdn2.microsoft.com/en-us/library/ms174355(SQL.90).aspx

Thanks
Laurentiu

|||It's also possible to reset the password (ie. without knowing the original password) for an individual login using MSSMS (Management Studio). After connecting to the DBSERVER with approrpriate rights to reset a password, navigate to DBSERVER -> Security -> Logins -> AccountNameForWhichToResetPassword. Right-Click -> Properties. Just change the password and confirmation password, then click OK.

Does anyone have a script to reset all logins on a server?

We want to merge 2 SQL servers into one. This means we will have duplicate logins with differing passwords.

We want to reset all the passwords on one server to something memorable. Does anyone have a script that cursor through (or trans - I'm not shy) all the logins in a mster db? I really don't fance going through hundreds of logins changing their passwords by hand!

Looking into it, I think I can cursor through master.dbo.sysxlogins and reset the passwords using sp_password, as such:

sp_password Null, 'Newpassword', 'loginname'

Anyone see a problem with the above?

does anyone have a query to check for db differences

I would like to compare 2 dbs at an object level to ensure that all schema
are the same on the 2 dbs and give me differences with any
I know of 3rd party tools from Red-gate , but was hoping someone had written
a simple script that i could use
ThanksHassan
> I know of 3rd party tools from Red-gate , but was hoping someone had
> written
> a simple script that i could use
>
Simple script? Are you kidding? It is very compicated issue. Personally , I
use Red-gate and it does work pretty good
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uilnoVmkFHA.3544@.TK2MSFTNGP15.phx.gbl...
>I would like to compare 2 dbs at an object level to ensure that all schema
> are the same on the 2 dbs and give me differences with any
> I know of 3rd party tools from Red-gate , but was hoping someone had
> written
> a simple script that i could use
> Thanks
>|||One thing you could try is to script out all the objects from each database
into two separate folders (with the option of a separate file for each
object). And then compare the folders using a tool like WinDiff that comes
with Visual Studio.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uilnoVmkFHA.3544@.TK2MSFTNGP15.phx.gbl...
>I would like to compare 2 dbs at an object level to ensure that all schema
> are the same on the 2 dbs and give me differences with any
> I know of 3rd party tools from Red-gate , but was hoping someone had
> written
> a simple script that i could use
> Thanks
>|||I mean simple such as
select a.name from dbold..sysobjects a
where not exists (select * from dbnew.dbo.sysobjects b where a.name =b.name)
select a.name from dbold..sysindexes a
where not exists (select * from dbnew.dbo.sysindexes b where a.name =b.name)
Would this be fairly accurate if i want to capture everything ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O6fu%237mkFHA.3212@.TK2MSFTNGP10.phx.gbl...
> Hassan
> > I know of 3rd party tools from Red-gate , but was hoping someone had
> > written
> > a simple script that i could use
> >
> Simple script? Are you kidding? It is very compicated issue. Personally ,
I
> use Red-gate and it does work pretty good
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:uilnoVmkFHA.3544@.TK2MSFTNGP15.phx.gbl...
> >I would like to compare 2 dbs at an object level to ensure that all
schema
> > are the same on the 2 dbs and give me differences with any
> >
> > I know of 3rd party tools from Red-gate , but was hoping someone had
> > written
> > a simple script that i could use
> >
> > Thanks
> >
> >
>|||I wasnt looking at all details such as text of sprocs, triggers, views,etc..
just the names of objects that are not present
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:%231TsN$mkFHA.3148@.TK2MSFTNGP09.phx.gbl...
> One thing you could try is to script out all the objects from each
database
> into two separate folders (with the option of a separate file for each
> object). And then compare the folders using a tool like WinDiff that comes
> with Visual Studio.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:uilnoVmkFHA.3544@.TK2MSFTNGP15.phx.gbl...
> >I would like to compare 2 dbs at an object level to ensure that all
schema
> > are the same on the 2 dbs and give me differences with any
> >
> > I know of 3rd party tools from Red-gate , but was hoping someone had
> > written
> > a simple script that i could use
> >
> > Thanks
> >
> >
>|||Hi
Well, I'd not query system tables , instead INFORMATION_SCHEMA view_name
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23xxItBnkFHA.2852@.TK2MSFTNGP15.phx.gbl...
>I mean simple such as
> select a.name from dbold..sysobjects a
> where not exists (select * from dbnew.dbo.sysobjects b where a.name
> =b.name)
>
> select a.name from dbold..sysindexes a
> where not exists (select * from dbnew.dbo.sysindexes b where a.name
> =b.name)
> Would this be fairly accurate if i want to capture everything ?
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:O6fu%237mkFHA.3212@.TK2MSFTNGP10.phx.gbl...
>> Hassan
>> > I know of 3rd party tools from Red-gate , but was hoping someone had
>> > written
>> > a simple script that i could use
>> >
>> Simple script? Are you kidding? It is very compicated issue. Personally ,
> I
>> use Red-gate and it does work pretty good
>>
>> "Hassan" <fatima_ja@.hotmail.com> wrote in message
>> news:uilnoVmkFHA.3544@.TK2MSFTNGP15.phx.gbl...
>> >I would like to compare 2 dbs at an object level to ensure that all
> schema
>> > are the same on the 2 dbs and give me differences with any
>> >
>> > I know of 3rd party tools from Red-gate , but was hoping someone had
>> > written
>> > a simple script that i could use
>> >
>> > Thanks
>> >
>> >
>>
>|||Yes...you could smply do a left or full outer join between the two databases
to work out which ones are missing on each side.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:u9iopHnkFHA.1440@.TK2MSFTNGP14.phx.gbl...
>I wasnt looking at all details such as text of sprocs, triggers,
>views,etc..
> just the names of objects that are not present
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%231TsN$mkFHA.3148@.TK2MSFTNGP09.phx.gbl...
>> One thing you could try is to script out all the objects from each
> database
>> into two separate folders (with the option of a separate file for each
>> object). And then compare the folders using a tool like WinDiff that
>> comes
>> with Visual Studio.
>> --
>> HTH,
>> Vyas, MVP (SQL Server)
>> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>>
>> "Hassan" <fatima_ja@.hotmail.com> wrote in message
>> news:uilnoVmkFHA.3544@.TK2MSFTNGP15.phx.gbl...
>> >I would like to compare 2 dbs at an object level to ensure that all
> schema
>> > are the same on the 2 dbs and give me differences with any
>> >
>> > I know of 3rd party tools from Red-gate , but was hoping someone had
>> > written
>> > a simple script that i could use
>> >
>> > Thanks
>> >
>> >
>>
>|||You can still do this by scripting the databases to seperate folders and
comparing them with a Diff tool. I have found that BeyondCompare works well,
but Windiff would work fine too. Whatever is on one side but not the other
is what is missing. I currently do this for a database with 375 tables and
450 Stored Procedures in an environment with 20 developers making changes
daily. The developers are supposed to be checking changes in through Visual
Source Safe, but often forget to do so. I catch the problems before they
become an issue and let the developers know that need to check their changes
in/out of VSS.
"Hassan" wrote:
> I wasnt looking at all details such as text of sprocs, triggers, views,etc..
> just the names of objects that are not present
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:%231TsN$mkFHA.3148@.TK2MSFTNGP09.phx.gbl...
> > One thing you could try is to script out all the objects from each
> database
> > into two separate folders (with the option of a separate file for each
> > object). And then compare the folders using a tool like WinDiff that comes
> > with Visual Studio.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
> >
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:uilnoVmkFHA.3544@.TK2MSFTNGP15.phx.gbl...
> > >I would like to compare 2 dbs at an object level to ensure that all
> schema
> > > are the same on the 2 dbs and give me differences with any
> > >
> > > I know of 3rd party tools from Red-gate , but was hoping someone had
> > > written
> > > a simple script that i could use
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>|||This tool allows you to view all the db contents al logical level
as well as to query the oledb schemas. Might be of some help (free)
http://151.100.3.84/technicalpreview/

Does anyone from MSFT monitor this forum anymore?

Most if not all other forums that I participate in include responses from people in QA and or the respective product group.... Several posts here have gone unresolved for weeks and I was curious as to why someone from MSFT hasn't attempted to respond. Thre are times when the only answer or resolution to a question or problem require inside information.

Yes, definitely MS is watching this group. But I guess there is no escalation for the threads in the groups within Microsoft, because this is a public group from MSDN.

BTW: Does anyone know or perhaps the person for himself know the name of a SQL Server guy at Microsoft whose name sounds something like SOUNDEX(Ted or Ed Lehman or Ehland) ? I got a mail from him some time ago but don′t have this mail due to crashes anymore. I would be glad if someone could point me in the right direction.

-Jens Suessmeyer.

http://www.sqlserver2005.de
|||

Chris,

Your complaint duly noted. We've been a little busy with shipping Service Pack 1 but now that it's almost out we'll go through the recent posts and answer what we can.

Jens,

I contacted Ed Lehman and either he will reply here shortly or you can contact me directly (arturl at microsoft dot com). (Spammers, you know...)

Artur Laksberg
SQL Server Team
Microsoft

Does anyone Ever Get QOD

Question of the day emailed to them I get those emailed to me everyday they on SQL server 70-228 cerfitication test. My answer was C but alot of other people answered C also..and disputing QOD saying they are incorrect..so now i am asking the GURUS what do you think?
http://www.qod.us/answer.php

You have an SQL server that contains a database named Felons. You have been assigned the task of changing the way felon IDs appear in the Felons table. The FelonID column in the Felon table relationally links to several other tables with foreign key constraints in place. You need to automate the process of updating the primary key tools. You also want to minimize record locks and administration within the database during the update process so that you don't slow things down. What should you do?

A) Create a duplicate record that has a new FelonID value. Update the foreign key fields in the other tables.
B) Disable the FOREIGN KEY constraints. Within a transaction, modify the values in the FelonID field in the other tables. Re-enable the FOREIGN KEY constraints after the keys are changed.
C) Add an ON UPDATE CASCADE constraint to the FelonID field in the Customers table. Modify the values in the FelonID field in the Felons table.
D) Create a data transformation services package. Use the package to transform the FelonID value and the values of the related foreign keys on the other tables.

Your answer is: C
Correct answer is: A

Explanation: Cascading referential integrity constraints allow you make SQL server automatically update the keys across all the tables. The other actions would either be too tedious or slow things down, or not work right at all. You could end up with duplicate records with the old and new keys in the related tables and violate your key constraints.

Now heres all the Responses

Rijon

from: United States
on: 2003-03-20 07:04:49 I'm not familiar with cascading referntial integrity constraints, so this question was confusing.
Ludynilla Lanez
from: Philippines
on: 2003-03-20 14:38:43 No comment

jtf
from: Sweden
on: 2003-03-21 06:27:33 Have just started with SQL......

Munnster
from: United States
on: 2003-09-03 07:12:50 Learn something new everyday

mbatuchic
from: United States
on: 2003-09-03 08:29:08 that was a hard one for me
Sar123
from: United States
on: 2003-09-03 10:39:16 They DID it again. Explanation says:
"Cascading referential integrity constraints allow you make SQL server automatically update the keys across all the tables. The other actions would either be too tedious or slow things down, or not work right at all..." which is answer C. I was right but since I did not answer A, QoD evaluated my answer C as incorrect answer.

Question is really GOOD and explanation is OK but answer A su**s.
CORRECT ANSWER IS CCCCCCCCCCCCCCCCCCC.

Jim Tanner
from: United States
on: 2003-09-03 12:14:55 I have to agree with Sar123. The explanation tell why C is correct, my answer, but they say the correct answer is A.??

Jim Tanner
from: United States
on: 2003-09-03 12:14:56 I have to agree with Sar123. The explanation tell why C is correct, my answer, but they say the correct answer is A.??

Ricardo Ravazzolo
from: Brazil
on: 2003-09-03 13:07:41 The answer is always A, even if incorrect?
Pitarras
from: Dominican Republic
on: 2003-09-03 13:52:37 Yeah, they made a mistake. Since the correct answer is C there are no comments to make.I get most of my Questions of the Day from DBForums ;-)|||That has to be a typo. I would agree with C, and the explanation seems to support it.|||Woohoooo ...that Settles It C Is The Correct Thats One Guru Down That Agrees...happy Dance!!!!!!!!!!!!!|||First, modesty prevents me from affirming that my concurence validates your answer.

Second, you are getting way too excited about this. Do you have any hobbies? Perhaps some charitable work...|||So what are you trying to say Blindman that I'm a boring Geek..who gets too excited about SQL Questions, SQL Knowledge...SQL Databases...etc..edt?...Dont forget that compliment I threw your way calling you a GURU, and yes I do have a hobby|||when the question is "You have been assigned the task of changing the way felon IDs appear in the Felons table" then the answer could be something else

ON UPDATE CASCADE keeps primary/foreign key values in sync, but does nothing about changing the way the primary keys appear

perhaps what the question intended was that you are asked to change the primary key from, say, integer to, say, GUID

ON UPDATE CASCADE wouldn't cover that type of change|||Ok thank you I appreciate your answer. Ok shoot I was wrong anyways Oh well learn something new every day. So A would be the correct answer well darn back to the books. Thanks R937|||I'd go for A. But that's just because I thought the other ones looked to complex for the issue.|||"So what are you trying to say Blindman that I'm a boring Geek..who gets too excited about SQL Questions, SQL Knowledge...SQL Databases...etc..edt?..."

Yes.

Welcome to the club. Your membership card is in the mail and should arrive in a few days.

B. Lindman
Assistant Secretary to the Associate Director of Membership Processing, International Disassociation of Database Administrators|||Assistant Secretary to the Associate Director of Membership Processing, International Disassociation of Database AdministratorsDon't worry, the revised update to the altered changes to the specifications will be arriving shortly (in the next 2-6 months).

-PatP|||I forgot my secret handshake. Can you e-mail it to me?|||thanks for the birthday greetings guys..I got a birthday greeting by email from dbforums|||Thanks Blindman and Pat I'm really feeling love. And I'll be looking forward to my memebership card...um is there a Fee?|||Thanks Blindman and Pat I'm really feeling love. And I'll be looking forward to my memebership card...um is there a Fee?
That would be in the 'Feelon' table which is of course accessed by 'FeelonID'
;)|||Thanks Blindman and Pat I'm really feeling love. And I'll be looking forward to my memebership card...um is there a Fee?

You have to buy the Margaritas at our next meeting. We'll let you know...|||Ok so dont call you..you'll call me??..LOL...Your people with talk to my people?|||I got this question right

0228q35
This question is provided by: www.mcsefreakpress.com

In the above question, how would you go about setting up processor usage by SQL server?

A) Run the extended stored procedure xp_confprocusage followed by the numbered processors you want SQL server to only use.
B) Go to the Services manager to the advanced properties tab and select the processors you want SQL server to use.
C) Configure usage in the Multiprocessor Control panel in NT server administrative services.
D) Configure the SQL server processor usage in the SQL server properties control panel under the processor tab in the processor controls section.

Your answer is: D
Correct answer is: D
Explanation: That's the only location where this setup can take place. The other solutions do not have the appropriate tabs and functions to set this up.|||Well...again...another question you should never have to answer...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=44676

Don't forget the Cointreau|||OMFG brett

i am *so* not a dba

:( :( :(|||Oh good grief thats it no more question of the day for me...THAT'S THE END OF QOD. I just want to pass my 70-228 cert

I'm gonna go bury my head in the sand and cry now..if you'll excuse me for a second please

*sniff*|||Big part of the problem with the certs, is they ask you questions, that not only will probably not encountered...they're probably a path that you should NEVER be thinking about anyway...

How you architect a solution should align itself that makes the most out of what you have.

SWL Server does a very good job at handling the threads|||Oh good grief thats it no more question of the day for me...THAT'S THE END OF QOD. I just want to pass my 70-228 cert

I'm gonna go bury my head in the sand and cry now..if you'll excuse me for a second please

*sniff*The problem with qod, and things like that is that they are trying to get you to give the wrong answer. Getting you to give the wrong answer is their goal.

You need to handle the questions they give like you might handle fulminate of mercury... Very carefully, with great respect, and only under duress. The whole point of that kind of question is to make (or demonstrate that) you think analytically and critically, and don't blindly take the "easy" answer.

-PatP

Does anyone bother reading this newsgroup

Seems to be like the Exchange Server newsgroup - thousands of 1 thread
posts with nobody answering. Microsoft might want to consider answering
these groupsSloppy,
You may be right...
There seems to be more activity on the MSDN Forums
http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1&PageID=1|||If you are part of the managed newsgroups MS guarantees a response.
Otherwise it is only if they happen by and otherwise it is peer only. The
MSDN forums is where MS employees are encouraged to go to.
I haven't been there much yet but will most likely start at some point.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<sloppycode@.gmail.com> wrote in message
news:1142592288.749864.310460@.i40g2000cwc.googlegroups.com...
> Seems to be like the Exchange Server newsgroup - thousands of 1 thread
> posts with nobody answering. Microsoft might want to consider answering
> these groups
>

does anybody use MOM ?

HI,
Does anybody use Microsoft Operations Manager (MOM) ?
Thank you
DannyForget my question :-)
I found forum of MOM (Microsoft.public.mom.sql)
Danny
Danny Presse a =E9crit :
> HI,
> Does anybody use Microsoft Operations Manager (MOM) ?
> Thank you
> Danny

Does anybody look at the jobs on this site

Poeple are calling me for resume 5 years old. They need DBA's all over the country. Please pass it on to look at the job opportunities on this site.Kindly post your thread in relevent forums, dude. ;-)|||eah...place it in the corral where it belongs...

http://www.dbforums.com/showthread.php?p=3928081#post3928081

And you forgot the link...

Do they need part time help?

does anybody knows....

does anyone knows how to get all the stored procedure by using C#
You can query the INFORMATION_SCHEMA.PROCEDURES view to retrieve the names of the stored procedures.
Check out Dave Penton'sINFORMATION_SCHEMA View Examples web page for some code on how to do this in C#.
|||

Hi,
If you run the below statement you wil get the list of stored procedures in that database.

SELECT * FROM SYSOBJECTS WHERE xtype = 'P'

Eralper
http://www.kodyaz.com

|||

eralper wrote:
If you run the below statement you wil get the list of stored procedures in that database.
SELECT * FROM SYSOBJECTS WHERE xtype = 'P'

Directly querying the sys* tables is discouraged by Microsoft as they are not guaranteed to be backwards-compatible. The INFORMATION_SCHEMA views are the recommended approach. See this discussion among a few SQL Server MVPs (including Adam Machanic) on this issue:Use the sys tables or INFORMATION_SCHEMA tables?.

Does anybody know why?

Hi gurus,
Recently, my SQL Server Machine is suffering auto shutdown.
After the auto shutdown, and restart of the machine, I found that the file
under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
could not be started if I didn't change it back to SSNETLIB.DLL. But after a
while (usually minutes to tens of minutes), it will auto shutdown again. If
I didn't not rename it, there will be no auto shutdown.
My SQL Server was MSDN developer edition, with SP3 applied.
My machine is Windows 2000 professional edition with the latest patches
installed.
Please help me out
Thanks in advance
FrankFrank wrote:
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the
> file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> SQL Server could not be started if I didn't change it back to
> SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> it will auto shutdown again. If I didn't not rename it, there will be
> no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest
> patches installed.
> Please help me out
> Thanks in advance
> Frank
Do you have your PC set to reboot on errors? Check to see your settings
in My Computer | Advanced | Startup and Recovery. It might give you
additional information if you also check the Application and System
event logs.
--
David Gugick
Imceda Software
www.imceda.com|||Thanks David,
I checked my PC and found the setting in my PC was set to reboot on errors.
Now I unchecked this option and am waiting for the result.
BTW, could there be any side effect unchecking it?
Thanks again
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> > Hi gurus,
> > Recently, my SQL Server Machine is suffering auto shutdown.
> >
> > After the auto shutdown, and restart of the machine, I found that the
> > file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> > SQL Server could not be started if I didn't change it back to
> > SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> > it will auto shutdown again. If I didn't not rename it, there will be
> > no auto shutdown.
> >
> > My SQL Server was MSDN developer edition, with SP3 applied.
> > My machine is Windows 2000 professional edition with the latest
> > patches installed.
> >
> > Please help me out
> > Thanks in advance
> > Frank
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||David,
Unfortunately, it doesn't work, the PC still auto-shutdown. And after
restart, the file was changed again to SSNETLIB.OLD.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:u8f$KL8HFHA.2984@.TK2MSFTNGP15.phx.gbl...
> Frank wrote:
> > Hi gurus,
> > Recently, my SQL Server Machine is suffering auto shutdown.
> >
> > After the auto shutdown, and restart of the machine, I found that the
> > file under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And
> > SQL Server could not be started if I didn't change it back to
> > SSNETLIB.DLL. But after a while (usually minutes to tens of minutes),
> > it will auto shutdown again. If I didn't not rename it, there will be
> > no auto shutdown.
> >
> > My SQL Server was MSDN developer edition, with SP3 applied.
> > My machine is Windows 2000 professional edition with the latest
> > patches installed.
> >
> > Please help me out
> > Thanks in advance
> > Frank
> Do you have your PC set to reboot on errors? Check to see your settings
> in My Computer | Advanced | Startup and Recovery. It might give you
> additional information if you also check the Application and System
> event logs.
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Frank wrote:
> David,
> Unfortunately, it doesn't work, the PC still auto-shutdown. And after
> restart, the file was changed again to SSNETLIB.OLD.
> B/R
> Frank
I can't figure out why the PC is rebooting or why the file is being
renamed. Sounds almost like you have a virus on the PC. You might be
infected with slammer. See this:
http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en
David Gugick
Imceda Software
www.imceda.com|||Frank,
Still the same thing I suggested to you a month ago -
look at what's in your startups with msconfig and check the
Software\Microsoft\Windows\CurrentVersion\Run
keys in the registry,
Try reapplying SP3.
Did you do all of these?
Sue
On Thu, 3 Mar 2005 23:06:40 -0500, "David Gugick"
<davidg-nospam@.imceda.com> wrote:
>Frank wrote:
>> David,
>> Unfortunately, it doesn't work, the PC still auto-shutdown. And after
>> restart, the file was changed again to SSNETLIB.OLD.
>> B/R
>> Frank
>I can't figure out why the PC is rebooting or why the file is being
>renamed. Sounds almost like you have a virus on the PC. You might be
>infected with slammer. See this:
>http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en|||Sue,
Thanks but I have to say month ago, I did posted for help the same help, but
I got no answer at that time. From your mail, I think there must be
something wrong with the system so I didn't see your reply.
I checked the system with msconfig, and all the values in the startup panel
are known programs.
I have also followed your suggestion to reapply the SP3, but still no use.
One thing I think should let you know is that the auto-shutdown and rename
happened only after I applied some Windows patches which our company
dispatched via the SMS system.
I could not know exactly what those patches numbers are, and what they did
to the system.
Thanks
Frank
"Frank" <wangping@.lucent.com> wrote in message
news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
> Hi gurus,
> Recently, my SQL Server Machine is suffering auto shutdown.
> After the auto shutdown, and restart of the machine, I found that the file
> under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
> could not be started if I didn't change it back to SSNETLIB.DLL. But after
a
> while (usually minutes to tens of minutes), it will auto shutdown again.
If
> I didn't not rename it, there will be no auto shutdown.
> My SQL Server was MSDN developer edition, with SP3 applied.
> My machine is Windows 2000 professional edition with the latest patches
> installed.
> Please help me out
> Thanks in advance
> Frank
>|||David,
Thanks,
I read the article you linked and found it works for the SQL Server that
doesn't have SP2 or later applied, my SQL Server has already had the SP3
applied.
B/R
Frank
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OXEWR%23GIFHA.3376@.TK2MSFTNGP14.phx.gbl...
> Frank wrote:
> > David,
> > Unfortunately, it doesn't work, the PC still auto-shutdown. And after
> > restart, the file was changed again to SSNETLIB.OLD.
> > B/R
> > Frank
> I can't figure out why the PC is rebooting or why the file is being
> renamed. Sounds almost like you have a virus on the PC. You might be
> infected with slammer. See this:
>
http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Also check the registry keys - a lot of viruses that
reinstall have install in the CurrentVersion\Run keys.
If it's something from a patch delivered with SMS, the
history of what is pushed out to what server, clients is in
SMS. I can't remember if there is a predefined report for
that or if you have to figure out what tables and write your
own query.
You'd also want to check the event logs as David suggested.
You may also want to check for a dump file - the type of
dump and the location of the file is set in properties on
the Startup and Recovery window were you just were to change
the setting to not restart on errors.
-Sue
On Mon, 7 Mar 2005 10:48:19 +0800, "Frank"
<wangping@.lucent.com> wrote:
>Sue,
>Thanks but I have to say month ago, I did posted for help the same help, but
>I got no answer at that time. From your mail, I think there must be
>something wrong with the system so I didn't see your reply.
>I checked the system with msconfig, and all the values in the startup panel
>are known programs.
>I have also followed your suggestion to reapply the SP3, but still no use.
>One thing I think should let you know is that the auto-shutdown and rename
>happened only after I applied some Windows patches which our company
>dispatched via the SMS system.
>I could not know exactly what those patches numbers are, and what they did
>to the system.
>Thanks
>Frank
>"Frank" <wangping@.lucent.com> wrote in message
>news:eiNuX07HFHA.3196@.TK2MSFTNGP15.phx.gbl...
>> Hi gurus,
>> Recently, my SQL Server Machine is suffering auto shutdown.
>> After the auto shutdown, and restart of the machine, I found that the file
>> under MSSQL\Binn\SSNETLIB.DLL was renamed to SSNETLIB.OLD. And SQL Server
>> could not be started if I didn't change it back to SSNETLIB.DLL. But after
>a
>> while (usually minutes to tens of minutes), it will auto shutdown again.
>If
>> I didn't not rename it, there will be no auto shutdown.
>> My SQL Server was MSDN developer edition, with SP3 applied.
>> My machine is Windows 2000 professional edition with the latest patches
>> installed.
>> Please help me out
>> Thanks in advance
>> Frank
>>
>

Sunday, February 26, 2012

Does anyone know how often the sysjobschedules table is updated?

Does anyone know how often the sysjobschedules table is updated?

Does anyone know how often the sysjobschedules table is updated?

does anyone know about this err msg?

does anyone know about this err msg?

does anyone know about this err msg?

Does anyone know a utility/batch script to Warn when close to Max DB size

does anyone have the old SQL server versions?

does anyone have the old SQL server versions?

does anyone have the old SQL server versions?

Does anyone have sql2005 EE running on 64 bit Itanium server?

Does anyone have Northwind database file for SQLExpress ?

Does anyone have example of opening SQL Server with ODBC using MFC

Does anyone have example of opening SQL Server with ODBC using MFC

Does anyone have any ideas ..

Does anyone have any ideas ..

Does anyone have an ForEachColumn Procedure?

Does anyone have a script to reset SQL login passwords?

Does anyone have a script to reset all logins on a server?

does anyone have a query to check for db differences

does anyone have a query to check for db differences

does anyone have a query to check for db differences

Does anyone from MSFT monitor this forum anymore?

Does anyone Ever Get QOD

Does anyone bother reading this newsgroup

does anybody use MOM ?

Does anybody look at the jobs on this site

does anybody knows....

Does anybody know why?

log backup overwrite

Blog Archive

About Me