sorry for visio

You can reverse-engineer it from within visio.

New DatabaseModelDiagram

database\reverse engineer

(you may have to create and odbc-dsn to get connected)

use " NOT EXISTS " ... that's the way to do it !

speed it up by adding an index on table/view Acct_Stats column prcs_dte.

just m 2ct:

select  book, count(distinct page) as pagecount

from tl10_land

group by book

this can be don without unavailability :

check dbcc shrinkfile / shrinkdb in BOL

take special notice at Shrinking the Transaction Log.

You know SQLmail and clustering is not supported.

That's why I use smtp-mail on my clustered sqlservers.

SQLmail works, but only for a while, then it...

If it stays in rollback-state to long according to your expectation, you may need to stop and start your sqlserver-instance.

(I've had to do this frequently because some of my users...

Maybe you can get on the road with this :

(its a script I use to gather backup-job-info)

-- alzdba dd 08/01/2004

-- request Backup-job info

set nocount on

-- check BOL

select substring(case server...

I was thinking it should be something like that.

Did I overlook that documentation ?

Where/how did you...

I'm using alerts to perform these kind of task.

- Cmdshell stays closed.

- dba has control on jobs running on db-servers

- alertno-ranges support portability (DRP)

Test this...

As always : it depends.

.Net will definitely go for disconnected data with closed connections. Because of connection pooling, the overhead for having a "new" connection is minimised.

Same goes for others....

Also please do check : "Is the Schema Still Needed?" http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=32&messageid=11677 and the comments on it.

these jobs, running on SQL7sp2 with NT-4 sp6a, log  an error-eventlog when they fail.

Since the server has been replaces by a  SQLserver2ksp3a on W2Ksp4 it only logs warnings.

Check this thread. It handles the same "issue" :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=6&messageid=96649

In your select statement you can use case when ACCT_NO LIKE '%|' then REPLACE(ACCT_NO,'|','~') else ACCT_NO end.

sp_who / sp_who2 might help to determine who blocks.

If you haven en open EM connection to the db and an open connection to the db using QA, there are 2...