Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
Reload this Page Select * statement when PC starts up...
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 16th, 2007, 10:42 AM
Friend of Wrox
  
Join Date: Oct 2006
Posts: 112
Thanks: 12
Thanked 0 Times in 0 Posts
Default Select * statement when PC starts up...
Hi to all...

I would like to do a select * statement on a table
whenever my server is rebooted... automatic

Is there a way I can do it...
If so can you please help me...

Thanking you inadvance...

Rino
 
Old May 16th, 2007, 11:58 AM
Friend of Wrox
  
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default
I dont think there is a straight way of doing this. You will have to develop some script and put that into Startup to have it work.

_________________________
- Vijay G
Strive for Perfection
 
Old May 16th, 2007, 12:23 PM
SQLScott's Avatar
Wrox Author
  
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default
I have not tried this but...

You could also look at creating a Job in SQL Server that is fired when the SQL Server Agent starts.


Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html
 
Old May 16th, 2007, 12:28 PM
Friend of Wrox
  
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default
Yes that makes more sense infact than setting it up under OS startup, as sql server/agent services wouldn't have started yet.

But still doing that is tricky.

_________________________
- Vijay G
Strive for Perfection





Similar Threads
Thread Thread Starter Forum Replies Last Post
Select Statement gregalb SQL Server 2005 3 May 16th, 2008 08:51 AM
Select from another select statement to a repeater simsen ASP.NET 2.0 Professional 0 May 2nd, 2007 04:34 PM
select statement help RinoDM SQL Server 2000 2 January 16th, 2007 11:35 AM
Select Statement jmss66 VB How-To 3 March 13th, 2006 03:55 PM
get error when SELECT search starts with "@" abbylee26 Classic ASP Databases 1 March 15th, 2004 03:37 PM




Contact Us - Wrox - Privacy Statement - Top

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.