The question is how do I set up a role that allows table creation in a given schema in this case AS400 but not dbo, as the script above does...

I thought about that , but as you cannot specify it from the GUI I dismissed it, but I rememered that I reran a scripted job and you are correct.

Thanks

Yesterday I was 'handed' 2 Amazon SQL servers that was set up by someone else ( not a DBA ) , and I hope you have a very strong sa...

The system admin guys also asks us to look at Bakbone that snap shots , and these solutions do not handle SQL Mirrorring and some replications. Whilst I appreciate that...

The system admin guys also asks us to look at Bakbone that snap shots , and these solutions do not handle SQL Mirrorring and some replications. Whilst I appreciate that...

I believe we have found the problem in that some process or one has disabled the COM+ System Application Service. The Server guys don't want me to start this until...

Like me you have posted in the wrong forum Try Administering.

If you are moving from 2000 to 64 but 2005 I would not use SSIS to copy a complete DB...

The SQL 2000 version gets this information from the registry, and the same registry settings appear to be SQL2005, so you could write your own sp, but choose you...

Check that you have set a execution timeout

Within Registered Servers

- Select Server

- Right click Properties

- Select 'Connection Properties' tab

Just noticed that this is in the wrong forum , I have created a new on in correct Administering forum

I would have a look at how much space is used in table x, compared with the other jobs

Yep totally agree, and I tend to use the sp__DBA prefix so I can easily identify the ones I created and in the hope Microsoft will not use the same...

I have aked the same question at a couple of sites which use non SQL Server using non Microsoft drivers, and I have always be told that trusted connection is...

You must be using it on a database that has a case sensitive collation

try

select 'Object name' = case si.indid

...

Yep On defining a view it throws the following

Msg 1033, Level 15, State 1, Procedure T1, Line 1

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries,...