Viewing 15 posts - 12,811 through 12,825 (of 13,469 total)
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...
January 10, 2007 at 12:36 pm
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...
January 10, 2007 at 12:29 pm
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...
January 10, 2007 at 12:15 pm
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...
January 10, 2007 at 12:05 pm
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...
January 9, 2007 at 1:54 pm
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...
January 8, 2007 at 12:16 pm
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...
January 8, 2007 at 12:11 pm
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.
January 5, 2007 at 7:34 am
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...
January 4, 2007 at 11:37 am
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...
January 4, 2007 at 10:05 am
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%'
January 4, 2007 at 9:02 am
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 =...
January 4, 2007 at 8:56 am
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...
January 4, 2007 at 8:28 am
[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...
January 4, 2007 at 6:47 am
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...
January 4, 2007 at 6:37 am
Viewing 15 posts - 12,811 through 12,825 (of 13,469 total)