The obvious reply is to look at reporting services, in which you should be able to produce the report you want.

Duplicate deleted

You could play around with this to make it more readable but I think it does display the data in the format you want.

SELECT DISTINCT

A.[StaffNo],

A.[Name],

STUFF(( SELECT ' | '...

Have you tried running it from the command prompt, google has a few links on how to do this.

Food for thought, I can see many uses for this.

Thanks

If you have SQL users rather than windows authenticated users see:

http://support.microsoft.com/kb/246133 this will enable you to script out all users, permissions and passwords and apply them to the new...

In an ideal world (still looking for it) you would design all your databases from a model, using a good tool, my preference Power Designer (Sybase). Then apply all changes...

Who will use - Security and Permissions

How much data - Size of database, Size of hardware required.

Retention of data - How long will data be kept , how much growth,...

You only have to give permissions on the table that you wish to link to. See BOL for

sp_addlinkedserver and sp_addlinkedsrvlogin

Probably because the Master database is set to simple mode, so there are no logs to backup. Check the properties.

Right click on the table in management studio select script table as then create to and lastly select option of where to write the script out.

Have you checked that its not related to a collation issue on the database, in that its set to a different collation to that expected. Can happen if SQL Server...

Are there any uncommitted transactions? Check the DBCC OPENTRAN topic in SQL Server Books Online.

Tested on 3 versions and got...

SQL 2000 (0,1)

SQL 2005 (1,1)

SQL 2008 (1,1)

I think the question should be re-worded and answers reset if the posts on this discussion are anything to...

Check the permissions they might be there but not visible to the user you are logged in as.