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...

ugg that is tough; you might even have columns that don't store the the number as a varchar without dashes 9and leave the presentation layer to dash-ify it, or even...

you are correct;

there is no way to rename an instance; you have to install a new one with the new name, and drop the old when when you are ready.

davas (11/29/2012)

---

Thank you both for your quick replies! I've created a clustered index and now the table reports as being 600MB as expected so that's great.

Just wondered why the sp_spaceused...

A HEAP table (without a clustered index) has a table size which includes the space of all the deleted rows, that ever existed, EVER.

so if you insert and delete a...