Glad we could help.

I suspect that whatever connection you are using lacks the necessary permissions to administer logins. You could try to use trace/profiler to see what SMO is attempting to do...

I...

Danny: If you check my posts in this thread, you will see that I had already done all of those things and it still was not working. Turned...

There is no such thing as "a table with a direct ODBC connection to the database". That does not make sense in the context of SQL Server. Can...

Like this:

Select o.object_id

, c.column_id

, o.name

, c.name

, ROW_NUMBER() OVER(Order By o.object_id, c.column_id) as RowNum

From master.sys.system_objects o

Join master.sys.system_columns c

ON c.object_id = o.object_id

This seems highly subjective. In my experience, Log shipping is dead easy to setup and has virtually no maintenance overhead.

Mohit: This is a SQL 2000 forum, so no ROW_NUMBER().

Good. Then you aren't there yet. 😀

Here's how to get the third item:

Select TOP 1 * From (

Select TOP 3 * From (

Select TOP 5 * From syscolumns

...

You've got "begin"'s with no "end"'s. Add in the "end" and you should be fine.

This works by contructing a big string and then executing it. "+" is the...

DavidB (3/9/2009)

---

If you will permit me a moment of pessimism, I have to agree with Jeff here. I don't know that it is intentional that they are doing this or...

Here's one way:

Declare @sql as nvarchar(MAX)

Set @sql = ''

Select @sql = @sql

+ 'Create trigger ['+TABLE_SCHEMA'].[tr'+TABLE_NAME'_auto]

on ['+TABLE_SCHEMA'].['+TABLE_NAME'] for INSERT,UPDATE,DELETE as

{your-stuff-goes-here}

'

From INFORMATION_SCHEMA.TABLES

Where TABLE_TYPE = 'BASE TABLE'

Print @sql;

EXEC(@sql);

I think that you will find the XML.value method most useful. Hardly anyone uses OPENXML anymore now that the XML datatype and methods are available.

If you could post an...

Well I am going to assume that you table structure description is incorrect, and the your query attempt reflects that actual structure of your data.

If so, then this should do...