[Help] Schedule a Query

Hi. I'm a 17 year-old who is hosting a server for an online game. To store the game's data, I am using SQL Server 2005 and SQL Server Management Studio Express.

I wrote the following Query:

UPDATE Items
SET ItemID=('25')
WHERE ItemID=('200001')

It's purpose is to change an item in a player's inventory into a different item.

I would like to know how to set this Query to be executed automatically every couple of minutes. Let's say every 5 minutes.

I believe SQL 2000 had a Scheduler; but, I cannot find this in SQL 2005.

Thanks for reading this.

SQL 2005 Express does NOT have a 'scheduler' (SQL Agent).

However, read in Books Online about using SQLCmd.exe, the command line tool that will allow you to execute a stored procedure.

Combine that with Windows Scheduler, and you can reasonably 'automate' SQL code (or stored Procedures) to run on schedule.

[Fail] Could not add ASPNET user to SQL Server.

Ok here's my setup

1. Installed msde 2000 with sp3.
2. started the SQL Server and SQL Server Agent.
3. Ran IBuySpy Store Installation, when I ran the configuration I get error on bottum.

10:51:55 PM Tuesday, September 23, 2003: [Checking system requirements]
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected a local instance of SQL Server.
10:51:55 PM Tuesday, September 23, 2003: [Pass] Determined SQL Server version (8.00.194).
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected .NET Framework.
10:51:55 PM Tuesday, September 23, 2003: [Pass] Detected Internet Information Server (IIS).
10:52:03 PM Tuesday, September 23, 2003: [Begin Sample Configuration]
10:52:05 PM Tuesday, September 23, 2003: [Pass] Created IIS virtual directory.: StoreVBVS
10:52:05 PM Tuesday, September 23, 2003: [Pass] Determined SQL Server version (8.00.194).
10:52:22 PM Tuesday, September 23, 2003: [Fail] Could not add ASPNET user to SQL Server.
SQL Server does not exist or access denied.
10:52:22 PM Tuesday, September 23, 2003: [Done]

Can someone please tell me step by step on what I need to do and where to do it to get this working, thanks !!!did you add it via users in your db? when you xpand our db in sql server xplorer, you can add users using "users"...

HTH

[ask] how to run a trigger or store precedure in certain date?

hello, i have a database that will be updated on a certain date

i have a column "UPDATE_DATE" which specifies the updating date, my question is

"how should i make the trigger or stored procedure runs only on the date that has been specified"

thanks for the assistance

Create a job that runs once everyday and compares the date on the dat with the value in the column, and calls the proc if they match.|||

ok, i think that will be good idea since sqlexpress doesn't come with sqlagent

ok then, i'll try to code by that algorithm. thx anyway bro