Hi,

Just to be clear, I don't use EM to create new objects, I create scripts for all of the databases using EM and store the scripts in Source Safe.

I want...

This was from scripting directly from enteprise manager, not creating a script manually... Surely Enteprise Manager should also qualify the name when creating the stored procedure!

Hi,

Have you tried using DBCC INDEXDEFRAG instead? This is not classed as an offline process, does this still use a large amount of CPU?

Pete

Hi,

Thanks for the replies.... But when you use All tasks - Generate scripts for stored procedures, the dbo does not get added to the CREATE PROCEDURE part of the script...

HI Carl,

I think they come under the multi processor licensing model.

Pete

Hi,

For performance I would always recommend creating a Data Warehouse reporting environment and then put some kind of reporting technology on top of that.  I personally use Business Object XI...

From your local PC can you open the file?

Hi,

When it fails are you running the process using SQL Agent? If so does the SQL Agent login have permission to the file you are bulk loading?

Pete

Hi,

Whenever I write a stored procedure I call a generic stored procedure INS_DEBUG_LOG before each statement, this generic stored procedure writes to a Debug log table which holds the last statement...

Hi all,

Well it seems there must have been something wrong with the MDF file. I created a brand new empty databases, loaded the static data and then ran a full...

Hi all,

I don't think it is the AV software, because CPU is running ok I have also disabled it to check whether it was that.

I have now copied the MDF...

Hi,

As the service pack is status CTP ( Community Technology Preview ) Does this mean it is similier to a beta version? Therefore does that mean I shouldn't install it...

Hi Rich,

Thanks for your reply... The Database is running in 'simple' logging mode, so the process shouldn't run out of log space. Both the log file size and the...

Thanks everyone for your replies, I will install SP2 on the client machine.

Are there any gotchas I should watch out for when installing this service pack? The database is hosting...

Hmmm I'm probably being really thick... But when I open the wizard, and I get to 'Choose Script Option'  the Script behavior shows either 'Generate CREATE statements only' or 'Generate...