in enterprise manager, expand the views and drill in till you see the table that contains the column you wish to change.

right click on the table>>Choose "Design Table"

A list of...

no need;

you can simply insert these user tables back into the current master; you can use either DTS to copy the tables, or sql commands

I assume you restored or attached...

try something like this: i've moved the counts you are comparing into two subselect tables instead;

I've found this improves performance for me:

SELECT rev.srvc_request_num AS serviceRequestId,

               rev.reviewed_dt AS "review.lastUpdatedDate",

               rev.reviewed_by AS...

actually very helpful Colin thanks for the response; I had suspected views of views sucked, glad to hear a confirmation.

I was hoping to simply prune the complexity of some of...

are you sure you need SQL to return the date in that format? can you do it clietn side instead?

Programming languages like vb6/.NET, delphi, etc all can handle formatting a...

neat idea;

does anyone have a compression algorythm / stored proc to do this to text? i could see how it could be nice to stuff some compressed, non-binary xml into...

im sorry i kind of confused you; i got the vbalues inverted.

0 in the replinfo means not replicated.

a non zero value means it is being replicated.

here are some of the...

select name, replinfo from sysobjects where xtype='TR'

this will return all triggers, and a zero or one value for the replinfo.

if replinfo is [zero], the "not for replication" is true.

do you have auto-create statistics turned on on the database?

an execution plan may become less effective if the table(s) it queries have a lot of inserts/updates. the statistics are used...

minor differences: a VIEW is a saved SELECT statement(script), but it has some additional constraints, like all column names in the SELECT must be unique (can't do SELECT ID,ID,* FROM...

i think Crystal requires all fields to have a name/alias, right? try this:

SELECT DISTINCT count (accts) AS ACCTCOUNT FROM SOMETABLE WHERE Base like '%bus%'

all that is missing is your WHERE statement after the join, so the SQL knows what to exclude/include in the delete:

delete

from @a

left outer join @b-2 as b

on a.col1 =...

you might also want get the user to connect, and use sp_who or sp_who2 adn see what username they connected with... that might help track down what login they use...

[Builtin\Administrators] would have the same rights as the sa user.....anyone in that group gets mapped to the dbo database owner, so it wouldn't be obvious that they have permissions, since...

this might help: it created either the appropriate DELETE or TRUNCATE statement, and created them in Foreign key hierarchy order.

you'd want to enahcne this so that it doesn't delete your...