Calling all MS SQL Gurus
30 May 2003, 03:53 PM
#1
Scooby Regular
Thread Starter
Join Date: Oct 2002
Location: Guildford
Posts: 276
Likes: 0
Received 0 Likes
on
0 Posts
As I am very lame at MS SQL I was hoping someone could give me some advice.
I was told I need to run a Store Procedure on our database called re-index however I don't know how to run it ???
Do I need to generate the SQL scripts and then use Query analyzer to run them ??
Any help would be most appreciated !
Thanks
Simon
I was told I need to run a Store Procedure on our database called re-index however I don't know how to run it ???
Do I need to generate the SQL scripts and then use Query analyzer to run them ??
Any help would be most appreciated !
Thanks
Simon
30 May 2003, 04:36 PM
#2
Scooby Regular
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
Simon,
If there is a stored proc. actually called somthing like 're-index' then fire up query analyser, select the correct database from the drop down and issue the command:
execute <stored_proc_name>
If you need to re-organise the data you need to create a maintenance plan, I need more info really, email me offline if you want further help, its 4:37 and hot now though so will probably be monday morning.
cheers
Gary
If there is a stored proc. actually called somthing like 're-index' then fire up query analyser, select the correct database from the drop down and issue the command:
execute <stored_proc_name>
If you need to re-organise the data you need to create a maintenance plan, I need more info really, email me offline if you want further help, its 4:37 and hot now though so will probably be monday morning.
cheers
Gary
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM