Viewing 15 posts - 36,451 through 36,465 (of 39,771 total)
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
I took a 2 phased approach. Teach everyone to use VSS and QA, not EM.
Track new objects. When one appears, check that it's in VSS or go yell at someone.
http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp
http://www.sqlservercentral.com/columnists/sjones/vcspart4.asp
Steve...
March 24, 2003 at 3:20 pm
Ahh, it's been too long. If I get my copy of VMWare, I might try to reinstall NT4 / SQL 65 just for these questions.
In the new EM, there is...
March 24, 2003 at 3:15 pm
Not sure if you will get the info, but they are pretty good about bugs. I'd call and say that you are inquiring about the bug, which affects you, but...
March 24, 2003 at 3:11 pm
Good points, though I don't know how Tom grew the site. If we lost too many advertisers, the site would get shut down. Just too expensive.
Still, it's an interesting perspective...
March 24, 2003 at 3:08 pm
Good suggestions. We'll start looking at some of these.
Steve Jones
March 24, 2003 at 3:05 pm
March 24, 2003 at 11:03 am
Haven't worked with v6.5 replication in some time. Can you script out the replication from EM? If so, then you might be able to set a script to drop the...
March 24, 2003 at 10:49 am
It won't. Per seat means that each client must be licensed. This means you must purchase a CAL for each client that conencts to SQL Server. This is an administrative...
March 24, 2003 at 10:43 am
You can also do this in Windows if you are logged in as the account that starts SQL Server (need to restart SQL Server to see it).
Steve Jones
March 24, 2003 at 10:40 am
Viewing 15 posts - 36,451 through 36,465 (of 39,771 total)