wouldn't that be a simple select?

SELECT...

it also gets a lot more difficult if you have any constraints on any of those 50 columns...unique constraints, indexes, defaults, etc could prevent the ALTER command from completing.... all...

great job on providing sample ddl and data!

does this do what you are after?

With CurrencySplit(currencypair,rate_value ,ccy1,ccy2)

AS

(

SELECT

currencypair,

rate_value,

LEFT(currencypair,3),

RIGHT (currencypair,3)

...

as i remember it, MSDAORA is 32 bit, no longer supported, adn only works correctly on oracle 9 and below;

10,11 and above changed the way they handle BLOB/CLOBS, and you...

this is what i would suggest first thing, since it's not a bad thing to update statistics:

DECLARE @Exec VARCHAR(MAX)

SELECT @Exec = ''

SELECT @Exec = 'UPDATE STATISTICS ' + QUOTENAME(schema_name(schema_id))+ '.'...

umm... one nic card can listen to multiple IP addresses, right? so there's no need for 6 nic cards to watch 6 ip addresses, if that's what they are thinking.

here's...

glad it's working for you!

one more thing to consider:

if you create a new database via a RESTORE, that does not trigger the CREATE_DATABASE event. that triggers the event AUDIT_BACKUP_RESTORE_EVENT, which...

you need to provide more details; the actual execution plan would tell us exactly what happened,a nd we could identify the items in the execution plan that is causing performance...

I'm sure you have to use extended events, specifically on the

AUDIT_BACKUP_RESTORE_EVENT

I did something as a prototype that did a few things on my dev server;

if you restored a database,...

yeah, i just scripted a CREATE DATABASE from the GUI; you can see it does a bunch of alters for the properties after it does the create:

CREATE DATABASE [Example] ON...

the event data is going to have the new database name...it's already been changed by thetime you get to the ddl trigger, unless you force a rollback.

you could rollback ,...

arunyadav007 pointed you in the right direction, here's a code model for your trigger.

I',m not sure if you are just inserting the changes, updating existing, or what;

i'd think there needs...

you just need to add an alias, sorry:

select * from openquery([abc],'SELECT

...

crowellc (11/30/2012)

---

I’m seeing the following error message when I try to query seven specific views in a database: Msg 18456, Level 14, State 1, Line 1 Login failed for user...

in that case, assuming you wanted the value as columns again like your first query, it would go like this...notice i did a simple cross join, on a table we...