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

ive used this in the past; it's a cursor, and resource intensive; it takes a couple of minutes to run on my 100meg database with 100's of procs and...

soemthing like this is probably what you want: you want to use a case statement to determine how a row gets counted

SELECT SUM(CASE WHEN DUES > 0 THEN 1 ELSE 0...

the EXEC command has no limitation to the length of the command, so you can append variables to death with it..., but sp_executesql has a parameter that has a limit.

can...

you can see a lot of log bloat if you have scheduled jobs that are doing things like DBCC Reindex or other similar maintenance operations. could that be what you...