Viewing 15 posts - 36,646 through 36,660 (of 39,771 total)
Have you checked that the SQLAgent account has rights to delete? Check the log files for the maintenance plan for errors.
Steve Jones
January 14, 2003 at 10:25 am
This is a holdover from SQL v6.5 which takes a query and then builds an HTML page from the results. It isn't documented in v7 or 2000, but was left...
January 13, 2003 at 10:34 am
Are you appending to one file or making a new one each time?
Steve Jones
January 13, 2003 at 10:21 am
Sounds like you have some bug set. Perhaps SQL is setup for dynamic ports? Check the network setup. I restart SQL and have no issues on a number of servers.
Steve...
January 13, 2003 at 10:16 am
Intersting, have to check on this. Will try to ping some MS contacts to see if we can get an explanation of the coding.
Steve Jones
January 10, 2003 at 8:45 pm
Personally I'd stick with a simple solution if I could.
backup/restore.
Script the deletion of all data.
Steve Jones
January 10, 2003 at 2:38 pm
Haven't used a NAS, though we have some on a SAN. Similar concept, slightly different architecture. The idea behind this is that the storage is consolidated and rarely, if ever,...
January 10, 2003 at 10:59 am
NO RAID 0. Not worth it on a production server. If one drive goes, your server is down. The tempdb should be on RAID 1 or 5 or 10, same...
January 10, 2003 at 10:46 am
January 10, 2003 at 10:36 am
I favor the filesystem, but that's me. Andy has good arguments in another thread (http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4169&FORUM_ID=9&CAT_ID=1&Topic_Title=Images:%20Store%20in%20SQL2000%20or%20on%20File%20Directory?&Forum_Title=General) on this.
Steve Jones
January 10, 2003 at 10:35 am
use a left outer join
select *
from affiliate a
left outer join template t
on a.affiliateid = t.affiliateid
Steve Jones
January 9, 2003 at 2:48 pm
Are these employees? Authenticated (to NT) users? If they are, you need to buy 1 SQL Server License and 15 CALs. Middle Tiers don't count.
If they are Internet or unauthenticated...
January 9, 2003 at 1:02 pm
I'm not sure I agree with all the choices made either, but it was nicely written and it appears that it works well for you to solve the problem.
I worked...
January 9, 2003 at 1:00 pm
You can also return quarters with Datepart. Scorpian has good advice.
Steve Jones
January 8, 2003 at 8:14 pm
There are a few tricks. One is to set the package to connect to (local), which will be the default instance.
another is to use the Dynamic Properties task to query...
January 8, 2003 at 12:56 pm
Viewing 15 posts - 36,646 through 36,660 (of 39,771 total)