How to know when it's time to goto sleep.

07:33 in the morning on a Sunday and I'm reading AND replying to this stuff,
and arguing with my BIND server.
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSenseiI don't know if this is the right time to inform you.. but www.vbSensei.Com
is down.
"Mike Labosh" <mlabosh_at_vbsensei_dot_com> wrote in message
news:OVCttEFQGHA.2628@.TK2MSFTNGP15.phx.gbl...
> 07:33 in the morning on a Sunday and I'm reading AND replying to this
> stuff,
> and arguing with my BIND server.
> --
> Peace & happy computing,
> Mike Labosh, MCSD MCT
> Owner, vbSensei.Com
> "Escriba coda ergo sum." -- vbSensei
>|||RE:
<< How to know when... >>
Now Mike; now would be a good time.
-HTH
"Mike Labosh" <mlabosh_at_vbsensei_dot_com> wrote in message
news:OVCttEFQGHA.2628@.TK2MSFTNGP15.phx.gbl...
> 07:33 in the morning on a Sunday and I'm reading AND replying to this
> stuff,
> and arguing with my BIND server.
> --
> Peace & happy computing,
> Mike Labosh, MCSD MCT
> Owner, vbSensei.Com
> "Escriba coda ergo sum." -- vbSensei
>|||:) For me its 3:10 AM IST...
So ur 7:33 AM is far better :))...
--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]
"Mike Labosh" wrote:

> 07:33 in the morning on a Sunday and I'm reading AND replying to this stuf
f,
> and arguing with my BIND server.
> --
> Peace & happy computing,
> Mike Labosh, MCSD MCT
> Owner, vbSensei.Com
> "Escriba coda ergo sum." -- vbSensei
>
>

How to know when a job has finished. For Experts I think.,

I have this on my page
Dim backUpDB2 As SqlClient.SqlCommand
backUpDB2 = New SqlClient.SqlCommand
backUpDB2.CommandType = CommandType.StoredProcedure
backUpDB2.CommandText = "msdb.dbo.SP_RESUMENFAC"
backUpDB2.Connection = SqlConnection1
backUpDB2.ExecuteNonQuery()

The SP has this

CREATE PROCEDURE .[SP_RESUMENFAC] AS

EXEC sp_start_job @.job_name = 'TransferirDatos(FACT) '

GO

WHen I execute the page after the SP it fills some datagrid but the data is not updated bacuase the job takes 1 minute or more to finish.

Is there anyway to prevent to show the old data? or to detect when the job has finished?

ThanksI think i would look for a way to get the execution status of the job instead.

If the job is not in an idle state, you can display something appropriate on the page.

look atsp_help_job

@.execution_status will tell you what the job is doing...
0 Returns only those jobs that are not idle or suspended.
1 Executing.
2 Waiting for thread.
3 Between retries.
4 Idle.
5 Suspended.
7 Performing completion actions.|||it says COuldnt Find Procedure.

Should I install something on the server. Its Sql Serrver 7 I think.|||its in MSDB

USE msdb
EXEC sp_help_job|||use msdb
EXEC sp_start_job @.job_name = 'TransferirDatos(FACT) '

This is the job, How can I Know when this has done and show a progress bar?|||side note: Don't prefix your procs with "sp_" this should be reserved for MS procs only and you'll get stung performance wise if you don't remove it.|||if your stored proc looks like this:

USE msdb
EXEC sp_help_job NULL, ''TransferirDatos(FACT)' ,'JOB'

you will get back a single recordset.

Look at thecurrent_execution_status column for the jobs status.
My prev post has the different results for this column.

you wont get progress (like 50% complete etc...)
but you will get Executing or Idle etc...

How to know what Version is Sql 2000

Hi Folks:
How does one determine what version and Service Pak level is SQL Server. We
have SBS 2003 and I am not sure what Service Paks have been applied.
Many thanks for your help.
JM
http://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JBM" <JBM@.nowhere.com> wrote in message news:e$llvXv0FHA.1264@.tk2msftngp13.phx.gbl...
> Hi Folks:
> How does one determine what version and Service Pak level is SQL Server. We
> have SBS 2003 and I am not sure what Service Paks have been applied.
> Many thanks for your help.
> JM
>
|||Open EM, right click on the servername select properties and look for
"Product version"
..194 is RTM
..760 is SP3
The rest of the specific build numbers can be seen in the link provided by
Tibor
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"JBM" <JBM@.nowhere.com> wrote in message
news:e$llvXv0FHA.1264@.tk2msftngp13.phx.gbl...
> Hi Folks:
> How does one determine what version and Service Pak level is SQL Server.
> We have SBS 2003 and I am not sure what Service Paks have been applied.
> Many thanks for your help.
> JM
>

How to know what Version is Sql 2000

Hi Folks:
How does one determine what version and Service Pak level is SQL Server. We
have SBS 2003 and I am not sure what Service Paks have been applied.
Many thanks for your help.
JMhttp://www.aspfaq.com/show.asp?id=2160
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JBM" <JBM@.nowhere.com> wrote in message news:e$llvXv0FHA.1264@.tk2msftngp13.phx.gbl...
> Hi Folks:
> How does one determine what version and Service Pak level is SQL Server. We
> have SBS 2003 and I am not sure what Service Paks have been applied.
> Many thanks for your help.
> JM
>|||Open EM, right click on the servername select properties and look for
"Product version"
.194 is RTM
.760 is SP3
The rest of the specific build numbers can be seen in the link provided by
Tibor
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"JBM" <JBM@.nowhere.com> wrote in message
news:e$llvXv0FHA.1264@.tk2msftngp13.phx.gbl...
> Hi Folks:
> How does one determine what version and Service Pak level is SQL Server.
> We have SBS 2003 and I am not sure what Service Paks have been applied.
> Many thanks for your help.
> JM
>

How to know what Version is Sql 2000

Hi Folks:
How does one determine what version and Service Pak level is SQL Server. We
have SBS 2003 and I am not sure what Service Paks have been applied.
Many thanks for your help.
JMhttp://www.aspfaq.com/show.asp?id=2160
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JBM" <JBM@.nowhere.com> wrote in message news:e$llvXv0FHA.1264@.tk2msftngp13.phx.gbl...[vbcol
=seagreen]
> Hi Folks:
> How does one determine what version and Service Pak level is SQL Server. W
e
> have SBS 2003 and I am not sure what Service Paks have been applied.
> Many thanks for your help.
> JM
>[/vbcol]|||Open EM, right click on the servername select properties and look for
"Product version"
.194 is RTM
.760 is SP3
The rest of the specific build numbers can be seen in the link provided by
Tibor
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"JBM" <JBM@.nowhere.com> wrote in message
news:e$llvXv0FHA.1264@.tk2msftngp13.phx.gbl...
> Hi Folks:
> How does one determine what version and Service Pak level is SQL Server.
> We have SBS 2003 and I am not sure what Service Paks have been applied.
> Many thanks for your help.
> JM
>

How to know what sql version is installed.

Hi, we are verifying the licenses of sql server that we have installed
on al the company. But we dont know how to know with type of
installation a machine has.
For example, if i execute the select @.@.version statement in QA it
returns all the information But we need a way to know this information
at a file level.
Do you know how can i get this information without using sql sentences.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Maria,
I just this week wrote this kixTart script that checks for the product
version of a local SQL client tools installation. We will be running it
through Scriptlogic which is the script running tool that we use
(recommended). Scriptlogic is a kixtart environment, but the script could
easily be made into vbscript.
The @.@.version command checks to see what is installed on the server that
hosts the database regardless of where you run it from.
$LogFile = "\\Acsb\Common\Administration\Shared\DB\inv\Cver.t xt"
$SQLFile = "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe"
$AnaLiveFile = "C:\Anasazi\Live\AS\APP\ATRAIN.ICO"
$AnaExist = "No Value"
If Exist ("$AnaLiveFile")
$AnaExist = "Y"
Else
$AnaExist = "N"
EndIf
If Exist ("$SQLFile")
$Cver = GetFileVersion("$SQLFile", "ProductVersion")
Else
$Cver = "No SQl File"
EndIf
$ReturnCode = RedirectOutput("$LogFile","0")
If $ReturnCode = 0
? @.WKSTA + "," + $Cver + "," + $AnaExist + "," + @.USERID + "," +
@.PRODUCTTYPE + "," + @.FULLNAME + "," + @.IPADDRESS0 + "," + @.DATE + "," + @.CSD
EndIf
The product version of osql.exe will be 800.760 if Service pack 3 is
installed, 800.194 if not. I hope that helps.
"MariaGuzman" wrote:

> Hi, we are verifying the licenses of sql server that we have installed
> on al the company. But we don4t know how to know with type of
> installation a machine has.
> For example, if i execute the select @.@.version statement in QA it
> returns all the information But we need a way to know this information
> at a file level.
> Do you know how can i get this information without using sql sentences.
> Thanks a lot for your help.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>

How to know what sql version is installed.

Hi, we are verifying the licenses of sql server that we have installed
on al the company. But we dont know how to know with type of
installation a machine has.
For example, if i execute the select @.@.version statement in QA it
returns all the information But we need a way to know this information
at a file level.
Do you know how can i get this information without using sql sentences.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!Maria,
I just this week wrote this kixTart script that checks for the product
version of a local SQL client tools installation. We will be running it
through Scriptlogic which is the script running tool that we use
(recommended). Scriptlogic is a kixtart environment, but the script could
easily be made into vbscript.
The @.@.version command checks to see what is installed on the server that
hosts the database regardless of where you run it from.
$LogFile = " \\Acsb\Common\Administration\Shared\DB\i
nv\Cver.txt"
$SQLFile = "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql.exe"
$AnaLiveFile = "C:\Anasazi\Live\AS\APP\ATRAIN.ICO"
$AnaExist = "No Value"
If Exist ("$AnaLiveFile")
$AnaExist = "Y"
Else
$AnaExist = "N"
EndIf
If Exist ("$SQLFile")
$Cver = GetFileVersion("$SQLFile", "ProductVersion")
Else
$Cver = "No SQl File"
EndIf
$ReturnCode = RedirectOutput("$LogFile","0")
If $ReturnCode = 0
? @.WKSTA + "," + $Cver + "," + $AnaExist + "," + @.USERID + "," +
@.PRODUCTTYPE + "," + @.FULLNAME + "," + @.IPADDRESS0 + "," + @.DATE + "," + @.CS
D
EndIf
The product version of osql.exe will be 800.760 if Service pack 3 is
installed, 800.194 if not. I hope that helps.
"MariaGuzman" wrote:

> Hi, we are verifying the licenses of sql server that we have installed
> on al the company. But we don4t know how to know with type of
> installation a machine has.
> For example, if i execute the select @.@.version statement in QA it
> returns all the information But we need a way to know this information
> at a file level.
> Do you know how can i get this information without using sql sentences.
> Thanks a lot for your help.
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>