I agree with Nigel. In our company we have a test system which is created once a week from the backups of the test system. Considered replication, but don't want...

Sorry - didn't mention that we can't use a temporary table in the inner stored procedure because it is an extended stored proc. What we want is something like:

create procedure...

I found that using only the Sybex books and Transcenders as study guides was enough to pass the exams.

http://www.amazon.co.uk/exec/obidos/ASIN/0782129218/o/qid=1004630858/sr=2-1/ref=sr_bt_1/202-7162036-3016624

and

http://www.amazon.co.uk/exec/obidos/ASIN/0782129420/o/qid=1004630911/sr=2-4/ref=sr_bt_4/202-7162036-3016624

Best of luck.

Paul Ibison

email: Paul.Ibison@btinternet.com

Ed,

There are several options:

BULK INSERT - TSQL

BCP - command line utility program

Bulk Insert Task in Database Transformation Services - graphical extension to sql.

Transform Data in Database Transformation Services -...

If the transformation is an ActiveX script, you could use the execute method of the command object in ADO. Alternatively, the Task object in the DTS heirachy - accessible through...

When I implemented this solution at my current company I decided that I would replace it as soon as we upgrade to SQL 2000, for the support reasons you mentioned....

Granted that if you have a choice then your solution would be preferable, but the article was intended to refer to those cases where an application uses a login, and...

Doooh! Just seen it - thanks.

Paul Ibison PhD, MCSD

email: Paul.Ibison@btinternet.com

The article really applies to those circumstances where someone - a developer - needs bulk insert rights, but you don't want him to become an administrator (sorry - but that...

Thanks,

I have implemented No 2 as it was the easier. Looked at No 1 but couldn't see in the gui how to specify every 12 months. Can this really be...

The columns you're interested in exist in the Sysprocesses table. Searching under this keyword, there is a little info in BOL, but for more details, these articles are definitely worth...

Thanks for the interesting feedback - it sounds as though SQL Server OLAP isn't as widespread as I feared. I have come to the same conclusion regarding learning OLAP, and...

It sounds like at this stage you need more information to try to identify the problem. When I had similar issues with a large DTS job I found it useful...

If you're using ADO, then Recordset.AbsolutePosition will be:

a valid recordnumber

EOF

BOF

Unknown (empty recordset).

This could be used with the recordcount.

Paul Ibison PhD, MCSD

email: Paul.Ibison@btinternet.com

just a thought, but if you want to tailor the results rather than have a predefined recordset, you could save the results of sp_help_job into a temporary table then scroll...