samalex (12/5/2012)

I found this earlier too, but it appears to be an outdated article since the Download URI goes to http://www.microsoft.com/en-us/download/default.aspx which isn't valid. ...

i've got this script i posted here on SSC multiple times that seems to do a nice job for me;

for Invalid Objects, it's not like oracle, where there is a...

well so far, i haven't been able to get a duplicate in my limited testing;

i was thinking that maybe a developer had a transaction open, went to lunch, and then...

you can use a technique using SUM(CASE... to get subtotasl;

you'll have to construct the multiple case statements to match your descriptions, i think.

here's a prototype based on the query you...

we use this one at our shop:

primary key and foreign key column name must contain name of the table...ie tbCity has tbCityID as it's PK, and all foreign key columns...

david take a look at http://www.mylittleadmin.com/

if that's not what you are after, I can give you a copy of a simple aspx page I slapped together a long time...

I think your trigger model needs to look more like this.

because triggers handle multiple rows in SQL server, you should never declare a variable in a trigger, because it makes...

sure!

take a look at...

it's because you have have to specify the database name in front of information_schemas, otherwise it's the current context.

i personally avoid the information_schemas, and go for the SQL views instead;

this...

to get it to 10% of it's original size, that means deleting 90% of the data? i don't think that's what you are really asking.

besides the points above, (and compresison...

we'd have to see the actual table structure and sample data (CREATE TABLE ...INSERT INTO)

but you could do something as easy as joining with an "exotic" join...that is not with...

well, for the SQL log, exactly where the logs go is configurable...when you first install the server, one of the options is to decide on the folders.

it defaults to a...

well...

its certainly possible, you'd probably want to create a linked server to the other server, and then create the view with a full four part naming convention.

CREATE VIEW

AS

SELECT ColumnList

FROM MyLinkedServer.DatabaseName.dbo.TableName

Where...

ODBC (Open Database Connectivity)

http://en.wikipedia.org/wiki/ODBC