- if you modify a sp, use the alter procedure syntax, so security keeps in place.

- What's the error, how can you tell it is not working ?

sp_who / sp_who2

- why not put the tables in 1 db (if it is on the same box)? (if you want physical-files per table, use filegroups)

- You can perform the dri-checks you...

Just my 2ct

first use profiler to determine what's going on.

Activate those switches that inform which sql is being used within the sp.

this will put more load on your...

In fact, it should be the calling part that should qualify the owner of the called object.

Because sqlserver 6.5,7.0,2K did not implement schema...

put a clustering index on it and use rebuild index or indexdefrag

also take a look at pad_index and fillfactor

This might help if it were only for me or if I was the onlyone to be registering servers on clients, however, that is not the case.

I would like to...

did you adjust connection-timeout settings in EM or QA ?

I've already tested that (change of keyname) with no luck,

but the key-value is a bunch of hex-stuff, where I think It all has...

replace the "distinct" with a "group by" if you can, it might get index-only access, whilest distinct is an extra passthroug of the resultset .

- http://www.sql-server-performance.com/cursors.asp

- http://www.sql-server-performance.com/dp_no_cursors.asp

- http://www.sqlservercentral.com/articles/articlesexternal.asp?articleid=477

your last "group by" is not allowed.

How about :

update ft

  set ft.peso= fiii.NewPeso

from ft

inner join fi fii

on ft.ftstamp=fii.ftstamp

and ft.fdata between '20040201' and '20040229'

inner join

   (select...

sqlagent needs to be restarted when you activate the first alert.

- If it occurs while running the sp :

check your network-card/cable the computer where you get the error.

If it occurs on #-computers, check network-card/cable at the server.

- Check out if...

Very nice

Many have been searching for this and (like I did) build their own sqldmo-solution.

"Therefore, I am trying to create very general indexes on each table that will serve generic needs (my attempt at half-way optimizing the DB).  So each table has a unique...