with GoDaddy being shared hsoting, you get SQL users only for access to your SQL instance.

you might consider storing...

make sure the string is a single line when sent to the cmd :

create table #Results (

ID int identity(1,1) NOT NULL,

TheOutput varchar(1000))

declare @cmd as varchar(8000)

set @cmd = ' ren c:\sgrs\SGRS_SGCTCentral_7_20111111102846.rar...

email is raw text mode or html mode?

is that a static footer/email, or are the elements pulled dynamically in a SQL statement?

SQLRNNR (11/17/2011)

---

There is also the 1-man shop type of dba where the DBA /Domain Admin/Janitor pretty much does everything.

It really depends on the organization as to where the DBA falls...

for me, there's serveral flavors of DBA's..there sthe DBA that does what yuo are probably doing...mostly administrative, handling backups, traces and the servers themselves.

a Development DBA, which (for me anyway)...

Charmer (11/17/2011)

---

i have two tables....1st one has columns name RlseId and a datetime column..

2nd table has TrackID(primary key,automatic generated) , RlseId(foreign key of 1st table) and RlsTrackId...but no date time...

in that case, i usually just do a SELECT * INTO table_Bak

FROM Table;

with that it's very easy to update the original table from that side by side table in the...

hybrid of the wide table idea?

do those 1024 columns logically break into groups that could be, say 4 or 5 other tables? (measurement types?)then you have , dunno, 5 tables...

stop connections permanently, like using the firewall to ignore all traffic from the webserver?

i'd go firewall first, a login trigger would work for an entirely SQL solution, but the hostname...

yeah i'd consider either dynamic sql as suggested, or breaking this up into 4 procedures.

a master proc that ends up returning one of 4 proc results based on the parameters;

my...

you can grant insert permissions to public for it.dbo.AlterLogin, i *think* that will resolve the audit issue;

i've done the same, but i've been sticking my audit table in master.

USE...

i'm trying to think this through, does this sound right to everyone?

SQL retrieves the data in what the query engine deems is the fastest way possible, and caches that execution...

Steve Malley (11/16/2011)

---

I did as you suggested, Lowell, and the freeproccache ran fine. Unfortunately, there was an Db sendmail further on that failed. I would have thought that both these...

The sql plan you posted is returning a query with 247,958 rows? is that right?

an SSRS report should not be presenting a quarter million rows of data for anyone...