ouch...that is a hard one.

I think you are saying you have an excel spreadsheet that contains embedded images. say someone pasted half a dozen images into an excel worksheet, and...

yeah it depends on how accurate your data needs to be; a developer might just need to know whether some table has a lot of rows or not, but other...

2000 doesn't have a Schema, just object owners...for each test.object, you want to use sp_changeObjectOwner instead.

sp_changeObjectOwner 'test.table','dbo'

2005 makes it REALLY easy by using a Common Table Expression(CTE) and the Row_number () function

here's a simple example:

with MyQuery As (

select row_number() over (order by name) as RowNumber,*...

thre's two ways to do this;

the sysindexes table has a rowcount column in it, but it is possible that it is not quite accurate; it's a good approximation of the...

i would think you'd need to add a linked server on washington to point to The california server, and repeat the process on the Cali server to point to washington.

once...

your psuedocode is pretty much the SQL;

update table2.maj_grp_seq with the table3.maj_grp_seq where table1.mgrp = table3.name.

only thing you are missing is how the data is related to table2; since they...

you'll be best served if you do this with a full text search.

Believe it or not, it's not that difficult, and there was a recent article here on SSC on...

if the table1.Key field should not repeat, why not put a unique constraint on it? why are you trying to do a constraint in a trigger, when there's a built...

you have access to that informatino in your exe

in vb6 it's app.path returns the folder the exe is running from

in .NET it's Application.StartUpPath;

it depends on what language you wrote your...

on INSERT, of course Columns_Updated returns 3...ALL columns (column 1 and column2 )are affected on INSERT, even if a null gets inserted.....

but if you UPDATE, using jeff's same example,

UPDATE TriggerTest...

you can't use a variable for an objectname..so you cannot stick something in to replace a tablename or fieldname directly in a statement...you have to use dynamic sql:

fails:

if not exists('select'+@Fieldname...

--[Inserted] And [Deleted] tables are special virtual tables that contain all the records affected by the insert or delete; it is critical that in a trigger you use a set...

SELECT

CASE WHEN LEVEL1 = 'PLEASE SPECIFY' THEN '' ELSE LEVEL1 END +

CASE WHEN LEVEL2 = 'PLEASE SPECIFY' THEN...

i got the same error on one of my databases when i tested your code;

adding collation to the first field fixed it for me:

select 'DROP INDEX ' + object_name(s2.object_id)...