Steve,

Can I ask for one other "feature" request which is when you watch a thread and it emails you that it takes you to the right page of the thread...

Just to add a +1 for the removal of the bolding of links..

As another idea how about a SQL Server Cookbook esque wiki for common admin/sql tasks?

- James

You can use WITH INIT to overwrite backup files.

- James

If its a whole database then its probably easiest to back it up and send the backup across.

Otherwise you can use somthing like BCP to get the data out...

You can get it into a CSV file (which you can then read into Excel) using BCP - for example:

c:\> bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" queryout...

Hi there,

Your BACKUP LOG statement will fail as you expect. Not quite sure why MSFT let you set up a maintenance plan which does this - but the backups will...

Hi Sudhakara,

IIRC in the report designer you can set a parameter as "hidden" which will stop it showing up. I'm not sure about the NULL stuff but you can set...

I dont think there is a way to restore a SQL 2005 backup to a SQL2000 server however you can move the Data and Schema.

If you are not using any SQL...

Just to add to the questions

- How many indexes are you rebuilding?

- What types are the columns you are indexing?

- How many columns do the indexes contain?

- James

If you are not happy with SSIS/DTS then another option might be to look at a third party synchronization tool such as SQL Data Compare* this will allow you...

Hi there,

The following script should get you the information you need:

USE

msdb;

EXECUTE

msdb..[sp_help_jobhistory]

This will give you...

SELECT COL1, MAX(COL2), MAX(COL3), MAX(COL4) FROM table GROUP BY COL1

should do the trick.

- James

You can get the creation date\last update date by running:

SELECT * FROM [syslogins]

Hi Frank,

That script executes fine on instances of SQL 2000, SQL 2005 and SQL Express for me - are you sure thats the exact script you are running?

- James

Hi Ronald,

Glad you got it sorted. Just incase you are still interested you can use EXIT with an input file.. try running the following:

C:\>echo EXIT(SELECT 10) > c:\temp.sql

C:\>osql -E -i...