One option would be to use INSERT..EXEC to build up the results in a temporary table or table variable.

Another would be to use a table valued function instead of procedures.

Another...

Please also consider using an SSIS package to import data from files to a database - that is its primary purpose in life, and I don't like to see a...

The natural tool for the job would seem to be SSIS. It's pretty easy too - I just created an SSIS package to export a table from AdventureWorks to...

Hey Bob,

I think we pretty much did already 😉

Glad you enjoyed PASS.

Paul

If enabled, you could use xp_cmdshell.

Another alternative would be to write a batch script and have that called from a Windows scheduled task.

There are myriad ways to achieve this -...

DBCC INDEXDEFRAG is deprecated, so I prefer the information found here:

http://msdn.microsoft.com/en-us/library/ms188917.aspx

Paul

The 2005 version of Florian's excellent link is here:

http://msdn.microsoft.com/en-us/library/ms177433(SQL.90).aspx

There is a wealth of information about Reporting Services on TechNet:

http://msdn.microsoft.com/en-us/library/ms159106(SQL.90).aspx

That is the introductory page, there are hundreds of pages of detail under that.

Paul

There is an excellent section dedicated to SQL Server Profiler on TechNet:

http://msdn.microsoft.com/en-us/library/ms181091(SQL.90).aspx

To add to SilverFox's links, the TechNet article on Recovery Models is at:

http://msdn.microsoft.com/en-us/library/ms366344(SQL.90).aspx

Be sure to read the pages under that top-level page if you require deeper details.

Everything you ever wanted to know about log shipping, can be found at the following Microsoft TechNet link:

http://technet.microsoft.com/en-us/library/ms190016(SQL.90).aspx

Hope that helps.

Troy,

To get the definitive server version information, run the following:

SELECT SERVERPROPERTY('productversion'),

SERVERPROPERTY ('productlevel'),

...

The primary tool used to configure SQL Server Agent is SQL Server Management Studio (SSMS). This tool is included with the product, and...

De-normalization is, generally, the practice of maintaining summary information in the database, based on detail records that are also stored in the database. De-normalization is usually performed once the...

I'm not sure whether you are asking about SQL Server schedulers (as in sys.dm_os_schedulers) or the SQL Server Agent, which allows...