What's the issue with joining the tables together and using a WHERE clause?

Search for Security Catalog Views in books online, that will show what you need.

You could try using xp_cmdshell.

Hi,

Sorry, forgot about this.

I managed to work it out, here's the C# code if anyone is interested:

using System;

using System.IO;

using System.Data;

using System.Data.Sql;

using System.Data.SqlClient;

using Microsoft.SqlServer.Server;

using System.Text.RegularExpressions;

public class CopyDoc

{

...

If you didn't know something didn't exist, how could you ever learn about it?

That is one area where I feel certification can be good, it encourages you to read...

Thanks for replying guys. Gilamonster, that worked perfectly, thanks.

It was really annoying me and I knew it would be pretty straightforward.

In the Object Explorer for the SQL Server, expand the database, expand views, find the view, right click and Script view as > Create To > New Query window.

Hi Mahesh,

Thanks for replying.

I have already tried this and it works partially, but only if I remove the call description and the action description as they're string data types, they...