Viewing 15 posts - 36,391 through 36,405 (of 39,720 total)
Perhaps some jobs were expecting to have sysadmin rights. If you add back BI|admins, do they work again?
Might need to track the individual jobs and see what rights they appear...
April 1, 2003 at 11:14 am
I've worked in small shops where I didn't allow sysadmin access. Helped me to control things and ensure they met standards or we a good idea from the get go....
April 1, 2003 at 11:05 am
Very interesting. This server (SQL Server Central) has them the same.
A few at work have different versions. Checking further.
Steve Jones
April 1, 2003 at 11:01 am
Thomas,
Thanks for the suggestions and we will consider it, but I'm not sure we will. Mainly because we are starting to think that the email discussions detract from the community...
April 1, 2003 at 10:46 am
Blank passwords are horrible and based on the "we cannot comment on Yukon" from MS people, this is being addressed. Soon we should have expirations and possibly lockouts.
We use the...
March 31, 2003 at 10:19 am
We've had a couple Compaq/HP SANS here for our Demo system, 90 servers, all with no local storage, booting remotely off the SAN.
We just got a new SAN, 12TB, for...
March 28, 2003 at 10:02 am
March 27, 2003 at 10:23 am
Tend to agree that this might be a driver issue. Check MDAC
Steve Jones
March 27, 2003 at 10:20 am
the new id is in inserted. If you want the old one, it is in deleted.
Steve Jones
March 26, 2003 at 5:45 pm
You might need admin rights for service packs or other installations, but that shouldn't be a big deal. Have the admin there.
You don't need admin rights on the machine to...
March 26, 2003 at 5:44 pm
DECLARE @inmhlka VARCHAR(20)
DECLARE @exec_stat VARCHAR(100)
SET @inmhlka= '3,4'
SET @exec_stat = 'SELECT dbo.Table1.Field1, dbo.Revenue.Services FROM dbo.Revenue INNER JOIN
dbo.Table1 ON dbo.Revenue.Services = dbo.Table1.Field1 WHERE CONVERT(VARchar (20),Services) IN (' + @inmhlka + ');'
EXEC (@exec_stat)
Steve...
March 26, 2003 at 5:43 pm
I would prefer stored procedures, but they do not guarentee capture as they are not necessarily called outside the application.
In the next part, I'll look at selective triggers, though that...
March 25, 2003 at 4:40 pm
I'd vote for more joins, less tables.
Interesting topic and something that is worthy of a few tests. Look for something soon.
Steve Jones
March 25, 2003 at 12:24 pm
We are contacting vendors to let them know about this thread already. Most of our advertisers read the site, so I'm sure they are aware.
As an FYI, I work for...
March 25, 2003 at 12:22 pm
I used to have a job in SQL 65 that run xp_startmail periodically. That covered most bases, but it also sent an alert via an smtp client if the message...
March 24, 2003 at 3:36 pm
Viewing 15 posts - 36,391 through 36,405 (of 39,720 total)